Official SuiteCRM Outlook Plugin

Hi

I have newly tried out and installed the SuiteCRM Outlook Addin and the problem is that every sync attempt and every search for contacts produces an internal server error. I saw some other tickets that mentioned internal server errors but none contained a solution that seemed applicable. I have the latest version of the addin and the server uses SuiteCRM 7.9.11 which has been freshly installed. I have tried both with a regular user that can use some functions /but including contacts, tasks and calendar. But I have also tried to use the admin user who has permission for everything and even then the sync from outlook is having exactly the same problem.

Here is the debug log:

SuiteCRM Outlook Add-In v3.0.9.0 in Outlook version 16.0.0.8827 Auto-archiving: ON

Logging level: Debug

2018-02-04 23:01:42,326 | VSTA_Main | DEBUG | Adding event handlers for folder Contacts 2018-02-04 23:01:47,600 | VSTA_Main | DEBUG | Adding event handlers for folder Tasks 2018-02-04 23:01:47,605 | VSTA_Main | DEBUG | Adding event handlers for folder Calendar

2018-02-04 23:01:49,934 | Background | INFO | LicenceValidationHelper.InterpretStatusCode: status code OK, returning True 2018-02-04 23:01:49,935 | Background | INFO | LicenceValidationHelper.Validate: returning True 2018-02-04 23:01:49,935 | Background | INFO | Licence verified... 2018-02-04 23:01:50,655 | Background | INFO | Authentication succeeded... 2018-02-04 23:01:50,655 | Background | INFO | Starting normal operations. 2018-02-04 23:01:50,659 | Background | DEBUG | Starting thread Daemon 2018-02-04 23:01:50,783 | Background | DEBUG | Starting thread AS 2018-02-04 23:01:50,788 | Background | DEBUG | Starting thread CS 2018-02-04 23:01:50,789 | AS | DEBUG | AppointmentSyncing.SynchroniseAll not running because not enabled 2018-02-04 23:01:50,943 | Background | DEBUG | Starting thread TS 2018-02-04 23:01:50,947 | CS | DEBUG | ContactSyncing SynchroniseAll starting 2018-02-04 23:01:51,002 | TS | DEBUG | TaskSyncing.SynchroniseAll not running because not enabled 2018-02-04 23:01:51,003 | Background | DEBUG | Starting thread EM 2018-02-04 23:01:51,013 | CS | DEBUG | Permissions cache miss for Contacts/export 2018-02-04 23:01:51,013 | CS | DEBUG | Note: we deliberately cache permissions for all named modules whether we're interested in them or not - it's quicker than filtering them 2018-02-04 23:01:51,064 | EM | DEBUG | Auto-Archive iteration started 2018-02-04 23:01:51,264 | CS | DEBUG | Calling get_available_modules... 2018-02-04 23:01:51,651 | CS | DEBUG | Successfully called get_available_modules. 2018-02-04 23:01:51,660 | CS | DEBUG | Cached BiDirectional permission for Home 2018-02-04 23:01:51,660 | CS | DEBUG | Cached BiDirectional permission for Accounts 2018-02-04 23:01:51,660 | CS | DEBUG | Cached BiDirectional permission for Contacts 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Opportunities 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Leads 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for AOS_Quotes 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Calendar 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Documents 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Emails 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Spots 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Campaigns 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Calls 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Meetings 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Tasks 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Notes 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for AOS_Invoices 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for AOS_Contracts 2018-02-04 23:01:51,661 | CS | DEBUG | Cached BiDirectional permission for Cases 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for Prospects 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for ProspectLists 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for Project 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for AM_ProjectTemplates 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for FP_events 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for FP_Event_Locations 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for AOS_Products 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for AOS_Product_Categories 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for AOS_PDF_Templates 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for jjwg_Maps 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for jjwg_Markers 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for jjwg_Areas 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for jjwg_Address_Cache 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for AOR_Reports 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for AOW_WorkFlow 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for AOK_KnowledgeBase 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for AOK_Knowledge_Base_Categories 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for EmailTemplates 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for Administration 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for Currencies 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for CustomFields 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for Connectors 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for Dropdown 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for Dynamic 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for DynamicFields 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for DynamicLayout 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for EditCustomFields 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for Help 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for Import 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for MySettings 2018-02-04 23:01:51,662 | CS | DEBUG | Cached BiDirectional permission for FieldsMetaData 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for UpgradeWizard 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Trackers 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Employees 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Releases 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Sync 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Users 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Versions 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for LabelEditor 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Roles 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for EmailMarketing 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for OptimisticLock 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for TeamMemberships 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for TeamSets 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for TeamSetModule 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Audit 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for MailMerge 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for MergeRecords 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for EmailAddresses 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for EmailText 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Schedulers 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Schedulers_jobs 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for CampaignTrackers 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for CampaignLog 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for EmailMan 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for Groups 2018-02-04 23:01:51,663 | CS | DEBUG | Cached BiDirectional permission for InboundEmail 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for ACLActions 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for ACLRoles 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for DocumentRevisions 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for ProjectTask 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for ModuleBuilder 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for Alert 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for ResourceCalendar 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOBH_BusinessHours 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for ACL 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for Configurator 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for UserPreferences 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for SavedSearch 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for Studio 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for SugarFeed 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for EAPM 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for OAuthKeys 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for OAuthTokens 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AM_TaskTemplates 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for Reminders 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for Reminders_Invitees 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOD_IndexEvent 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOD_Index 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOP_Case_Events 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOP_Case_Updates 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOR_Fields 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOR_Charts 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOR_Conditions 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOS_Products_Quotes 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOS_Line_Item_Groups 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOW_Actions 2018-02-04 23:01:51,664 | CS | DEBUG | Cached BiDirectional permission for AOW_Processed 2018-02-04 23:01:51,665 | CS | DEBUG | Cached BiDirectional permission for AOW_Conditions 2018-02-04 23:01:51,665 | CS | DEBUG | Cached BiDirectional permission for Calls_Reschedule 2018-02-04 23:01:51,665 | CS | DEBUG | Cached BiDirectional permission for OutboundEmailAccounts 2018-02-04 23:01:51,665 | CS | DEBUG | Cached BiDirectional permission for TemplateSectionLine 2018-02-04 23:01:51,665 | CS | DEBUG | Cached BiDirectional permission for SecurityGroups 2018-02-04 23:01:51,665 | CS | DEBUG | Cached BiDirectional permission for Bugs 2018-02-04 23:01:51,665 | CS | DEBUG | Cached BiDirectional permission for AOR_Scheduled_Reports 2018-02-04 23:01:51,665 | CS | DEBUG | Cached BiDirectional permission for Alerts 2018-02-04 23:01:51,688 | CS | INFO | ContactSyncing.SyncFolder: '\xxxxxxxxx.yyyyyyyy@outlook.com\Contacts' 2018-02-04 23:01:51,688 | CS | DEBUG | Permissions cache hit for Contacts/export 2018-02-04 23:01:52,082 | CS | WARN | Tried calling 'get_entry_list' with parameter '{ session = 2d314ed97042c3893bfbedd03a4936b6, module_name = Contacts, query = contacts.assigned_user_id = '1', order_by = date_start DESC, offset = 0, select_fields = System.String[], link_names_to_fields_array = , max_results = 0, deleted = False }', timeout is 300000ms 2018-02-04 23:01:52,092 | CS | ERROR | Failed calling 'get_entry_list' System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (500) Interner Serverfehler. bei System.Net.HttpWebRequest.GetResponse() bei SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request) bei SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput) Data:System.Collections.ListDictionaryInternal HResult:-2146233079 2018-02-04 23:01:52,098 | CS | ERROR | ContactSyncing.SyncContacts System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (500) Interner Serverfehler. bei System.Net.HttpWebRequest.GetResponse() bei SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request) bei SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput) bei SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields) bei SuiteCRMAddIn.BusinessLogic.Synchroniser1.MergeRecordsFromCrm(MAPIFolder folder, String crmModule, HashSet1 untouched) bei SuiteCRMAddIn.BusinessLogic.ContactSyncing.SyncFolder(MAPIFolder folder, String crmModule) Data:System.Collections.ListDictionaryInternal HResult:-2146233079 2018-02-04 23:01:52,098 | CS | DEBUG | ContactSyncing SynchroniseAll completed 2018-02-04 23:01:53,092 | EM | DEBUG | Auto-Archive iteration completed 2018-02-04 23:02:02,041 | VSTA_Main | DEBUG | SettingsDialog: Setting up account archiving widget. Outlook version is Outlook2016; there are 2 accounts 2018-02-04 23:02:02,042 | VSTA_Main | DEBUG | SettingsDialog: Added email archiving tab for account xxxxxxxxx@yyyyyyyy-zzzzzzz.com 2018-02-04 23:02:02,107 | VSTA_Main | DEBUG | SettingsDialog: Added email archiving tab for account xxxxxxxxx.yyyyyyyy@outlook.com 2018-02-04 23:02:10,783 | VSTA_Main | WARN | Tried calling 'get_entry_list' with parameter '{ session = 2d314ed97042c3893bfbedd03a4936b6, module_name = Contacts, query = (contacts.first_name LIKE '%test%' OR contacts.last_name LIKE '%test%') OR (contacts.id in (select eabr.bean_id from email_addr_bean_rel eabr INNER JOIN email_addresses ea on eabr.email_address_id = ea.id where eabr.bean_module = 'Contacts' and ea.email_address LIKE '%test%')), order_by = date_entered DESC, offset = 0, select_fields = System.String[], link_names_to_fields_array = , max_results = 1000, deleted = False }', timeout is 300000ms 2018-02-04 23:02:10,786 | VSTA_Main | ERROR | Failed calling 'get_entry_list' System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (500) Interner Serverfehler. bei System.Net.HttpWebRequest.GetResponse() bei SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request) bei SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput) Data:System.Collections.ListDictionaryInternal HResult:-2146233079 2018-02-04 23:02:10,791 | VSTA_Main | ERROR | Failure when custom module included (1) Query was '(contacts.first_name LIKE '%test%' OR contacts.last_name LIKE '%test%') OR (contacts.id in (select eabr.bean_id from email_addr_bean_rel eabr INNER JOIN email_addresses ea on eabr.email_address_id = ea.id where eabr.bean_module = 'Contacts' and ea.email_address LIKE '%test%'))' System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (500) Interner Serverfehler. bei System.Net.HttpWebRequest.GetResponse() bei SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request) bei SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput) bei SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields) bei SuiteCRMAddIn.Dialogs.ArchiveDialog.TryQuery(String searchText, String moduleName, List1 fieldsToSeek) Data:System.Collections.ListDictionaryInternal HResult:-2146233079 2018-02-04 23:02:11,173 | VSTA_Main | WARN | Tried calling 'get_entry_list' with parameter '{ session = 2d314ed97042c3893bfbedd03a4936b6, module_name = Contacts, query = (contacts.first_name LIKE 'test' OR contacts.last_name LIKE 'test') OR (contacts.id in (select eabr.bean_id from email_addr_bean_rel eabr INNER JOIN email_addresses ea on eabr.email_address_id = ea.id where eabr.bean_module = 'Contacts' and ea.email_address LIKE 'test')), order_by = date_entered DESC, offset = 0, select_fields = System.String[], link_names_to_fields_array = , max_results = 1000, deleted = False }', timeout is 300000ms 2018-02-04 23:02:11,179 | VSTA_Main | ERROR | Failed calling 'get_entry_list' System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (500) Interner Serverfehler. bei System.Net.HttpWebRequest.GetResponse() bei SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request) bei SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput) Data:System.Collections.ListDictionaryInternal HResult:-2146233079 2018-02-04 23:02:11,185 | VSTA_Main | ERROR | Failure when custom module included (2) Query was '(contacts.first_name LIKE 'test' OR contacts.last_name LIKE 'test') OR (contacts.id in (select eabr.bean_id from email_addr_bean_rel eabr INNER JOIN email_addresses ea on eabr.email_address_id = ea.id where eabr.bean_module = 'Contacts' and ea.email_address LIKE 'test'))' System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (500) Interner Serverfehler. bei System.Net.HttpWebRequest.GetResponse() bei SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request) bei SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput) bei SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields) bei SuiteCRMAddIn.Dialogs.ArchiveDialog.TryQuery(String searchText, String moduleName, List1 fieldsToSeek) Data:System.Collections.ListDictionaryInternal HResult:-2146233079 2018-02-04 23:02:11,191 | VSTA_Main | ERROR | Failure when custom module included (3) System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (500) Interner Serverfehler. bei System.Net.HttpWebRequest.GetResponse() bei SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request) bei SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String strMethod, Object objInput) bei SuiteCRMClient.RestAPIWrapper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields) bei SuiteCRMAddIn.Dialogs.ArchiveDialog.TryQuery(String searchText, String moduleName, List`1 fieldsToSeek) bei SuiteCRMAddIn.Dialogs.ArchiveDialog.Search(String searchText) Data:System.Collections.ListDictionaryInternal HResult:-2146233079

Any help would be greatly appreciated!