Sugar: Modules Fail With "INVALID_SOAPXML_RESPONSE: Invalid Response Content Type of 'text/html', ..."

  • Updated

Issue

Riva Cloud or Riva On-Premise reports an "INVALID_SOAPXML_RESPONSE" problem with many modules.

This is the error logged:

ERROR [CTP-zgy #0] Exception Occurred:
ERROR [CTP-zgy #0] [CL: xebac3a1913fd085c; M:ctor] [Meetings:-20006] INVALID_SOAPXML_RESPONSE : Invalid response content type of 'text/html', but expected 'text/xml'
ERROR [CTP-zgy #0] **** EXCEPTION ****************************************************************************************************
ERROR [CTP-zgy #0] *     Omni.Connection.SugarCrm.x8a79268e94c1c543: [Meetings:-20006] INVALID_SOAPXML_RESPONSE : Invalid response content type of 'text/html', but expected 'text/xml'
ERROR [CTP-zgy #0] *    
ERROR [CTP-zgy #0] *******************************************************************************************************************

<<<TRUNCATED>>>

ERROR [CTP-zgy #0] *******************************************************************************************************************
ERROR [CTP-zgy #0] **** EXCEPTION ****************************************************************************************************
ERROR [CTP-zgy #0] *     System.InvalidOperationException: Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message:
--
Error running count query for Meeting List:  Query Failed: SELECT count(*) c FROM meetings   LEFT JOIN  users jt0 ON
jt0.id= meetings.modified_user_id AND jt0.deleted=0
 AND jt0.deleted=0  LEFT JOIN  users jt1 ON
jt1.id= meetings.created_by AND jt1.deleted=0
 AND jt1.deleted=0  LEFT JOIN  users jt2 ON
jt2.id= meetings.assigned_user_id AND jt2.deleted=0
 AND jt2.deleted=0  LEFT JOIN  meetings_contacts jtl3 ON meetings.id=jtl3.meeting_id  AND jtl3.deleted=0
 LEFT JOIN  contacts contacts ON contacts.id=jtl3.contact_id AND contacts.deleted=0
 AND contacts.deleted=0  LEFT JOIN  users jt4 ON
jt4.id= meetings.modified_user_id AND jt4.deleted=0
 AND jt4.deleted=0 where ((meetings.date_modified = '2010-08-10 22:00:00' AND meetings.date_modified = '2010-08-12 18:44:50') AND (0  (SELECT count(*) FROM meetings_users WHERE deleted = 0 AND user_id = '9339056c-7e80-effb-4a9e-4c62ee2fbcf4' AND meetings.id = meetings_users.meeting_id))) AND meetings.deleted=0
 ::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SELECT count(*) FROM meetings_users WHERE deleted = 0 AND user_id = '9339056c-7' at line 11
--.
ERROR [CTP-zgy #0] *        at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at SugarCrm.Soap.sugarsoap.get_entry_list(String session, String module_name, String query, String order_by, Int32 offset, String[] select_fields, Int32 max_results, Int32 deleted)
  
<<<TRUNCATED>>>

 

Cause

The error can be caused by a bug in the libxml2 2.7.1 library shipped with many Linux distributions.See bug reference http://bugs.php.net/bug.php?id=45996.

Solution

Upgrade the version of libxml2 from 2.7.1 to a minimum version of 2.7.3.

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.