Sugar Error: [Users:-20006] Database Failure. Please Refer to sugarcrm.log for Details. [v6.2.1]

Article ID: 578

Last updated: 02 Nov, 2016

Issue

When Riva Cloud or Riva On-Premise connects to Sugar 6.2.1 Pro, the following error may occur:

[Users:-20006] INVALID_SOAPXML_RESPONSE : Invalid response content type of 'text/html' but expected 'text/xml'

Examination of the log file would reveal something similar to this:

2012-01-05 11:48:11,816 ERROR [CTP-exu #0] [1142271431] Error occurred during synchronization.
System.InvalidOperationException: Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
The request failed with the error message:
--
Database failure. Please refer to sugarcrm.log for details.

Cause

This error is related to a bug in the User.php file related to a create_new_list_query function.

Solution

Apply the fix recommended in http://www.sugarcrm.com/crm/support/bugs.html?tmpl=#issue_45574.

The file that contains the bug is SUGAR_ROOT/modules/Users/User.php

Depending on the version and edition of Sugar, the line number may be different.

For Sugar Professional 6.2.1, it is line 1722.

Line to replace:

//add null check to end of the Join statement
$ljVal =' LEFT JOIN '.$ljVal.' and '.$alias.'.id is null ';

Replace with:

//add null check to end of the Join statement
if(preg_match('/_cstm$/', $alias)){
$ljVal =' LEFT JOIN '.$ljVal.' and '.$alias.'.id_c is null ';
}else{
$ljVal =' LEFT JOIN '.$ljVal.' and '.$alias.'.id is null ';
}

Applies to

Riva Cloud for Sugar 6.2.1.
Riva On-Premise for Sugar 6.2.1.

This article was: Helpful | Not helpful

Report an issue

Article ID: 578

Last updated: 02 Nov, 2016

Revision: 3

Comments: 0

Also listed in

Riva On-Premise - CRM Sync -> Manage Riva On-Premise (Admin Guides) -> CRM Systems -> Sugar -> Errors & Troubleshooting

« Sugar: Error "Access Denied" Explanation

Sugar: Modules fail with "INVALID_SOAPXML_RESPONSE: Invalid... »