Scalable, Enterprise-Class solution for integrating SuiteCRM with Exchange / Office 365. Synchronize contacts, calendars and tasks. Set rules for auto-archiving of incoming/outgoing emails. Combine (optional) with an Exchange / Office 365 add-on that presents an Email Side-Panel in Outlook and allows users to view, create and edit CRM records from within Outlook.
#1394 - Sync of contacts fails when a large number of contacts are synced
Use case is a one way sync of contacts from SuiteCRM to Exchange 2013. I have 6000 contacts, the initial sync needs to push them all over, then sync as they change. Sync of a 100 contact test subset worked. I flagged all contacts to sync and it failed. See attached log below.
09/05/2018 6:15:57.541 (7396) :- WALogout Start 09/05/2018 6:15:57.541 (7396) :- Begin SugarSoapApi::Logout; session: 'xxxxxx' 09/05/2018 6:15:57.841 (7396) :- End SugarSoapApi::Logout 09/05/2018 6:15:57.841 (7396) :- WALogout End 09/05/2018 07:15:58.876 (6344) Obtained next user - xxxxxx 09/05/2018 07:15:58.878 (6316) User synchronization started - xxxxxx 09/05/2018 07:15:59.095 (9080) Synchronizing user items started - xxxx:C 09/05/2018 7:16:01.004 (9080) :- WALogin Start 09/05/2018 7:16:01.004 (9080) :- Begin SugarSoapApi::LoginImpersonated 09/05/2018 7:16:01.467 (9080) :- End SugarSoapApi::LoginImpersonated; session: '33c8a8a3fba505122a7dbee8dfc0d302' 09/05/2018 7:16:01.467 (9080) :- WALogin End 09/05/2018 7:16:01.467 (9080) :- WAGetUser Start 09/05/2018 7:16:01.467 (9080) :- Begin SugarSoapApi::get_entry_list; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Users'; query: 'users.id='1''; Offset: '0'; max_results: '1'; deleted: '0' 09/05/2018 7:16:01.826 (9080) :- End SugarSoapApi::get_entry_list; result_count: '1'; total_count: '1'; next_offset: '1'; entry_list.Length: '1'; relationship_list.Length: '0' 09/05/2018 7:16:01.827 (9080) :- WAGetUser End 09/05/2018 7:16:01.861 (9080) :- WAGetServerTime Start 09/05/2018 7:16:01.861 (9080) :- Begin SugarSoapApi::get_server_info 09/05/2018 7:16:02.156 (9080) :- End SugarSoapApi::get_server_info; flavor: 'CE'; gmt_time: '2018-09-05 12:15:59'; version: '6.5.25' 09/05/2018 7:16:02.156 (9080) :- WAGetServerTime End 09/05/2018 7:16:02.156 (9080) :- WASyncWebToOutlookAllContacts Start 09/05/2018 7:16:02.156 (9080) :- Begin SugarSoapApi::get_server_info 09/05/2018 7:16:02.442 (9080) :- End SugarSoapApi::get_server_info; flavor: 'CE'; gmt_time: '2018-09-05 12:15:59'; version: '6.5.25' 09/05/2018 7:16:02.442 (9080) :- Begin SugarSoapApi::get_modified_relationships; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Users'; related_module: 'Contacts'; from_date: '2018-09-05 02:18:14'; to_date: '2018-09-05 12:15:59'; offset: '0'; max_results: '500'; deleted: '0'; module_user_id: '1'; relationship_name: 'contacts_users'; deletion_date: '2018-09-05 02:18:14' 09/05/2018 7:16:03.012 (9080) :- End SugarSoapApi::get_modified_relationships; result_count: '500'; next_offset: '500'; entry_list.Length: '500' 09/05/2018 7:16:03.015 (9080) :- Begin SugarSoapApi::get_modified_relationships; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Users'; related_module: 'Contacts'; from_date: '2018-09-05 02:18:14'; to_date: '2018-09-05 12:15:59'; offset: '500'; max_results: '500'; deleted: '0'; module_user_id: '1'; relationship_name: 'contacts_users'; deletion_date: '2018-09-05 02:18:14' 09/05/2018 7:16:03.534 (9080) :- End SugarSoapApi::get_modified_relationships; result_count: '500'; next_offset: '1000'; entry_list.Length: '500' 09/05/2018 7:16:03.538 (9080) :- Begin SugarSoapApi::get_modified_relationships; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Users'; related_module: 'Contacts'; from_date: '2018-09-05 02:18:14'; to_date: '2018-09-05 12:15:59'; offset: '1000'; max_results: '500'; deleted: '0'; module_user_id: '1'; relationship_name: 'contacts_users'; deletion_date: '2018-09-05 02:18:14' 09/05/2018 7:16:04.097 (9080) :- End SugarSoapApi::get_modified_relationships; result_count: '500'; next_offset: '1500'; entry_list.Length: '500' 09/05/2018 7:16:04.100 (9080) :- Begin SugarSoapApi::get_modified_relationships; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Users'; related_module: 'Contacts'; from_date: '2018-09-05 02:18:14'; to_date: '2018-09-05 12:15:59'; offset: '1500'; max_results: '500'; deleted: '0'; module_user_id: '1'; relationship_name: 'contacts_users'; deletion_date: '2018-09-05 02:18:14' 09/05/2018 7:16:04.709 (9080) :- End SugarSoapApi::get_modified_relationships; result_count: '500'; next_offset: '2000'; entry_list.Length: '500' 09/05/2018 7:16:04.713 (9080) :- Begin SugarSoapApi::get_modified_relationships; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Users'; related_module: 'Contacts'; from_date: '2018-09-05 02:18:14'; to_date: '2018-09-05 12:15:59'; offset: '2000'; max_results: '500'; deleted: '0'; module_user_id: '1'; relationship_name: 'contacts_users'; deletion_date: '2018-09-05 02:18:14' 09/05/2018 7:16:05.275 (9080) :- End SugarSoapApi::get_modified_relationships; result_count: '500'; next_offset: '2500'; entry_list.Length: '500' 09/05/2018 7:16:05.278 (9080) :- Begin SugarSoapApi::get_modified_relationships; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Users'; related_module: 'Contacts'; from_date: '2018-09-05 02:18:14'; to_date: '2018-09-05 12:15:59'; offset: '2500'; max_results: '500'; deleted: '0'; module_user_id: '1'; relationship_name: 'contacts_users'; deletion_date: '2018-09-05 02:18:14' 09/05/2018 7:16:05.813 (9080) :- End SugarSoapApi::get_modified_relationships; result_count: '500'; next_offset: '3000'; entry_list.Length: '500' 09/05/2018 7:16:05.816 (9080) :- Begin SugarSoapApi::get_modified_relationships; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Users'; related_module: 'Contacts'; from_date: '2018-09-05 02:18:14'; to_date: '2018-09-05 12:15:59'; offset: '3000'; max_results: '500'; deleted: '0'; module_user_id: '1'; relationship_name: 'contacts_users'; deletion_date: '2018-09-05 02:18:14' 09/05/2018 7:16:06.155 (9080) :- End SugarSoapApi::get_modified_relationships; result_count: '6'; next_offset: '3006'; entry_list.Length: '6' 09/05/2018 7:16:06.156 (9080) :- Begin SugarSoapApi::get_entries; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Contacts' 09/05/2018 7:16:20.400 (9080) :- Exception in SugarSoapApi::get_entries: System.InvalidOperationException: Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'. The request failed with an empty response. 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 WAAPI.SugarCRM.sugarsoap.get_entries(String session, String module_name, String[] ids, String[] select_fields, link_name_to_fields_array[] link_name_to_fields_array, Boolean track_view) at WAAPI.SugarApi.GetEntries(String moduleName, String[] ids, String[] selectFields, link_name_to_fields_array[] linkNameToFieldsArray, Boolean trackView) 09/05/2018 7:16:20.501 (9080) :- Begin SugarSoapApi::get_entries; session: '33c8a8a3fba505122a7dbee8dfc0d302'; module_name: 'Contacts' 09/05/2018 7:16:22.993 (9080) :- Exception in SugarSoapApi::get_entries: System.InvalidOperationException: Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'. The request failed with an empty response. 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 WAAPI.SugarCRM.sugarsoap.get_entries(String session, String module_name, String[] ids, String[] select_fields, link_name_to_fields_array[] link_name_to_fields_array, Boolean track_view) at WAAPI.SugarApi.GetEntries(String moduleName, String[] ids, String[] selectFields, link_name_to_fields_array[] linkNameToFieldsArray, Boolean trackView) 09/05/2018 7:16:23.094 (9080) :- Begin SugarSoapApi::Login 09/05/2018 7:16:23.751 (9080) :- End SugarSoapApi::Login; sessionID: 'c419a087d11248c11726a7e17a1d60dc'; version: '6.5.25'; flavor: 'CE'; teams: 'False'; securitygroups: 'True' 09/05/2018 7:16:23.751 (9080) :- Begin SugarSoapApi::get_entries; session: 'c419a087d11248c11726a7e17a1d60dc'; module_name: 'Contacts' 09/05/2018 07:16:26.435 (9080) Synchronizing user items ended - xxxxxx:C
6 years ago
Hi,
This seems to be a SuiteCRM server issue. After syncing 3000 contacts, the server starts sending back empty responses. Please check the configuration and logs on the server. This could be an issue of PHP limits or other similar issues. we highly recommend NOT syncing that high number of contacts to Exchange. Exchange will need to sync it to users' Outlook which will slow down your whole system.
6 years ago
Thank you for the reply. My users requested that every contact in CRM be synced into Outlook. I had hopped that after the initial big sync, just syncing the changes would not slow down the system.