by SuiteCRM

The Ultimate Outlook Plugin Has Arrived - In response to user requests, SuiteCRM have created the ultimate Outlook plugin which is maintained by SuiteCRM developers. Our plugin supports Outlook 2010 upwards and includes two way synchronisation with CRM, Calender, Calls, Meeting, Tasks and Email Archiving.

Cancel at any time!
Free Trial

#611 - Cannot sync contacts

Closed Bug? created by goddelabergayeh 2 years ago

I've just started an evaluation of SuiteCRM and the Outlook plugin in particular as we are looking at moving away from Dynamics CRM. Unfortunately the trial hasn't started well.
As far as I can see in the log file the issue points to error 500 Internal Server Error

Here are the symptoms:

**1. It takes forever to start outlook. (about 10 minutes) **
Started Outlook about 10:13 and it stays in state “processing” until about 10:24. More than 10 minutes.
1outlookstart.png

2outlookstart.png

2. Once outlook starts, contacts do not sync.
I believe I have setup everything correctly and the plugin "test connection" seems to work
6 Settings.png

7 Settings.png

8 Settings.png

9 Settings.png

10 Settings.png

3. Log file looks like this for the relevant period.


SuiteCRM Outlook Add-In v3.0.7.0 in Outlook version 15.0.0.4953
Auto-archiving: off

Logging level: Error

2017-09-12 09:36:45,557 | CS | ERROR | Failed calling 'get_entry_list'
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 09:36:45,599 | CS | ERROR | ContactSyncing.SyncContacts
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
at SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
at SuiteCRMAddIn.BusinessLogic.Synchroniser1.MergeRecordsFromCrm(MAPIFolder folder, String crmModule, HashSet1 untouched)
at SuiteCRMAddIn.BusinessLogic.ContactSyncing.SyncFolder(MAPIFolder folder, String crmModule)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 09:41:47,935 | 14 | ERROR | Failed calling 'get_entry_list'
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 09:41:47,935 | 14 | ERROR | ContactSyncing.SyncContacts
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
at SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
at SuiteCRMAddIn.BusinessLogic.Synchroniser1.MergeRecordsFromCrm(MAPIFolder folder, String crmModule, HashSet1 untouched)
at SuiteCRMAddIn.BusinessLogic.ContactSyncing.SyncFolder(MAPIFolder folder, String crmModule)
Data:System.Collections.ListDictionaryInternal

HResult:-2146233079

SuiteCRM Outlook Add-In v3.0.7.0 in Outlook version 15.0.0.4953
Auto-archiving: off

Logging level: Error

2017-09-12 09:58:38,967 | CS | ERROR | Failed calling 'get_entry_list'
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 09:58:38,977 | CS | ERROR | ContactSyncing.SyncContacts
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
at SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
at SuiteCRMAddIn.BusinessLogic.Synchroniser1.MergeRecordsFromCrm(MAPIFolder folder, String crmModule, HashSet1 untouched)
at SuiteCRMAddIn.BusinessLogic.ContactSyncing.SyncFolder(MAPIFolder folder, String crmModule)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 10:03:41,346 | 13 | ERROR | Failed calling 'get_entry_list'
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 10:03:41,346 | 13 | ERROR | ContactSyncing.SyncContacts
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
at SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
at SuiteCRMAddIn.BusinessLogic.Synchroniser1.MergeRecordsFromCrm(MAPIFolder folder, String crmModule, HashSet1 untouched)
at SuiteCRMAddIn.BusinessLogic.ContactSyncing.SyncFolder(MAPIFolder folder, String crmModule)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 10:08:43,636 | 5 | ERROR | Failed calling 'get_entry_list'
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 10:08:43,637 | 5 | ERROR | ContactSyncing.SyncContacts
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
at SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
at SuiteCRMAddIn.BusinessLogic.Synchroniser1.MergeRecordsFromCrm(MAPIFolder folder, String crmModule, HashSet1 untouched)
at SuiteCRMAddIn.BusinessLogic.ContactSyncing.SyncFolder(MAPIFolder folder, String crmModule)
Data:System.Collections.ListDictionaryInternal

HResult:-2146233079

SuiteCRM Outlook Add-In v3.0.7.0 in Outlook version 15.0.0.4953
Auto-archiving: off

Logging level: Error

2017-09-12 10:22:26,969 | CS | ERROR | Failed calling 'get_entry_list'
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 10:22:26,969 | CS | ERROR | ContactSyncing.SyncContacts
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
at SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
at SuiteCRMAddIn.BusinessLogic.Synchroniser1.MergeRecordsFromCrm(MAPIFolder folder, String crmModule, HashSet1 untouched)
at SuiteCRMAddIn.BusinessLogic.ContactSyncing.SyncFolder(MAPIFolder folder, String crmModule)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 10:27:29,216 | 13 | ERROR | Failed calling 'get_entry_list'
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 10:27:29,216 | 13 | ERROR | ContactSyncing.SyncContacts
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
at SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput)
at SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
at SuiteCRMAddIn.BusinessLogic.Synchroniser1.MergeRecordsFromCrm(MAPIFolder folder, String crmModule, HashSet1 untouched)
at SuiteCRMAddIn.BusinessLogic.ContactSyncing.SyncFolder(MAPIFolder folder, String crmModule)
Data:System.Collections.ListDictionaryInternal
HResult:-2146233079
2017-09-12 10:28:17,997 | VSTA_Main | ERROR | Auto-archiving: off
2017-09-12 10:28:17,997 | VSTA_Main | ERROR | Logging level: Error

4. Outlook takes about 2 minutes to close
5outlookclose.png

5 System Info
- SuiteCRM PHP Version: 7.1.1
- No Errors reported in the SuiteCRM log file for the relevant period
- Firewall turned off on both server and client machines
- SuiteCRM Outlook Add-In version: 3.0.7.0
- Outlook Version: Outlook 2013
- Exchange Server Version 2016
- Client Machine OS: Windows 8.1 Pro with all the latest updates
- SuiteCRM Server OS: Windows Server 2016 with all the latest updates

Let me know if you need anything else
Thanks

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    a year ago

    Hi goddelabergayeh,

    The issue is with PHP 7.1 on the SuiteCRM side rather than the SuiteCRM Outlook. Recommend turning off the Fatals until SuiteCRM is updated to resolve this.

    • SuiteCRM Outlook Plugin Team
  2. suitecrm member avatar

    SuiteCRM Provider Affiliate

    6 months ago

    Performance has improved in 3.0.11 and 3.0.18

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...