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

#934 - Internal Server error during contact search / sync

Closed Bug? created by francesca a year ago

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!

  1. francesca member avatar

    francesca

    a year ago

    It seems that the bug had to do with lacking support for PHP 7.1.
    Now, with version 3.0.11 of the Outlook Plugin the problem is fixed.

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