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.
