Official SuiteCRM Outlook Plugin

by SuiteCRM

Official SuiteCRM Outlook Plugin v4 has arrived - Compatible with the Outlook Web App or Outlook 2016+ connected to Office365 or Exchange Server 2016. A complete rebuild developed and maintained by SuiteCRM developers, the addon retains previous functionality while massively improves performance, reliability and stability!

Cancel at any time!
Free Trial

#611 - Cannot sync contacts

Closed Bug? created by goddelabergayeh 7 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

    7 years 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

    5 years 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...
  • Supported Versions
  • 7.10.10 to 8.6.1
Read Our Review

  • "It works very good. You should deactivate the contacts sync on the first run, because it sorts the contacts in the main folder and thus uploads duplic..." - Wieland

    Read More Reviews

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

The simplest way to work™. Glances integrates SuiteCRM with all your favorite workplace apps, acting as your go-to hub for real-time customer insights and personal tasks.

Featured

Outlook 365 and SuiteCRM Integration

Make life easier by reducing the need to flip between apps. If you are using Outlook Web App, Outlook 2013, or Outlook 2016 connected to Office365 or Exchange Server 2013 then be sure to take advantage of this email and contact synchronization add-on. Smartly links emails to your SuiteCRM records an...

Rating

SuiteCRM Enterprise-Class Outlook Integration

Implicit FrontEnd provides deep integration with Microsoft Outlook. In addition to full two-way synchronization of Outlook data such as contacts and calendars, it allows you to sync CRM data including accounts, opportunities, quotes etc. so that you can do all your CRM work without leaving Outlook. ...

Rating
Featured
Integrations Productivity Sales outlook microsoft office email office 365