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

#499 - suitecrm outlook plugin Server (500) Internal Server Error

Closed Bug? created by stevebrooks 2 years ago

I have tried removing the trailing / from my url and it did not work.

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    2 years ago

    Hi stevebrooks,

    Is it possible if we could ask you to send your DEBUG logs (logs set at DEBUG level) during replicating the issue to our support email address outlook[at]salesagility[dot]com referencing this Ticket #499. If you could also include what PHP version you are running off of, that would be much appreciated and we'll investigate.

    • SuiteCRM Outlook Plugin Team
  2. justinh member avatar

    justinh Verified Purchase

    2 years ago

    Hi Steve,

    I have a similar problem.

    After uninstalling and reinstalling 3.0.5 I can no longer get past the initial Settings windows. If I enable the plugin in Outlook I get the Reconfigure prompt and enter the plugin settings. If I enter the URL, credentials and Licence Key and try to Test or Save the settings I get an alert;

    **Unable to connect to SuiteCRM **
    The remote server returned an error: (500) Internal Server Error.

    The live site is SuiteCRM v7.6.5, MS Server 2012 R2, IIS 8.5, PHP 7.1.1, MySQL 5.7.18

    No Error or Debug Log is available as I cannot complete the setup/configuration process.

    I have a SuiteCRM Dev site running v7.8.5 on the very same server, the plugin connects to the Dev site correctly. But still throws an error if trying to search and archive emails;

    Query error in module 'xxxxxx'
    An error was encountered while querying module 'xxxxxx'. The error ('The remote server returned an error: (500) Internal Server Error.') has been logged.

    Debug Log from Dev site below;

    2017-08-01 10:48:55,796 | Background | DEBUG | RestService.CreateGetResuest: sending 'https://store.suitecrm.com/api/v1/key/validate?public_key=************removed***********%'
    2017-08-01 10:48:57,496 | Background | INFO  | LicenceValidationHelper.InterpretStatusCode: status code OK, returning True
    2017-08-01 10:48:57,496 | Background | INFO  | LicenceValidationHelper.Validate: returning True
    2017-08-01 10:48:57,496 | Background | INFO  | Licence verified...
    2017-08-01 10:48:58,046 | Background | INFO  | Authentication succeeded...
    2017-08-01 10:48:58,046 | Background | INFO  | Starting normal operations.
    2017-08-01 10:48:58,046 | Background | DEBUG | Starting thread Daemon
    2017-08-01 10:48:58,063 | Background | DEBUG | Starting thread AS
    2017-08-01 10:48:58,063 | Background | DEBUG | Starting thread CS
    2017-08-01 10:48:58,063 | Background | DEBUG | Starting thread TS
    2017-08-01 10:48:58,063 | AS | DEBUG | AppointmentSyncing.SynchroniseAll not running because not enabled
    2017-08-01 10:48:58,063 | CS | DEBUG | ContactSyncing.SynchroniseAll not running because not enabled
    2017-08-01 10:48:58,063 | Background | DEBUG | Starting thread EM
    2017-08-01 10:48:58,063 | TS | DEBUG | TaskSyncing.SynchroniseAll not running because not enabled
    2017-08-01 10:48:58,080 | EM | DEBUG | Auto-Archive iteration started
    2017-08-01 10:49:19,294 | VSTA_Main | WARN  | Tried calling 'get_entry_list' with parameter '{ session = 6kmbj7crsoi4mouq4cmegfnhfb, module_name = Accounts, query = (accounts.name LIKE '%************removed***********%%') OR (accounts.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 = 'Accounts' and ea.email_address LIKE '%************removed***********%')), order_by = date_entered DESC, offset = 0, select_fields = System.String[], max_results = 1000, deleted = 0 }', timeout is 300000ms
    2017-08-01 10:49:19,362 | VSTA_Main | 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-08-01 10:49:19,362 | VSTA_Main | ERROR | Failure when custom module included (1)
        Query was '(accounts.name LIKE '%************removed***********%') OR (accounts.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 = 'Accounts' and ea.email_address LIKE '%************removed***********%'))'
    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.clsSuiteCRMHelper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
       at SuiteCRMAddIn.Dialogs.ArchiveDialog.TryQuery(String searchText, String moduleName, List`1 fieldsToSeek)
    Data:System.Collections.ListDictionaryInternal
    HResult:-2146233079
    2017-08-01 10:49:20,046 | VSTA_Main | WARN  | Tried calling 'get_entry_list' with parameter '{ session = 6kmbj7crsoi4mouq4cmegfnhfb, module_name = Accounts, query = (accounts.name LIKE '************removed***********') OR (accounts.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 = 'Accounts' and ea.email_address LIKE '************removed***********')), order_by = date_entered DESC, offset = 0, select_fields = System.String[], max_results = 1000, deleted = 0 }', timeout is 300000ms
    2017-08-01 10:49:20,046 | VSTA_Main | 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-08-01 10:49:20,046 | VSTA_Main | ERROR | Failure when custom module included (2)
        Query was '(accounts.name LIKE '************removed***********') OR (accounts.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 = 'Accounts' and ea.email_address LIKE '************removed***********'))'
    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.clsSuiteCRMHelper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
       at SuiteCRMAddIn.Dialogs.ArchiveDialog.TryQuery(String searchText, String moduleName, List`1 fieldsToSeek)
    Data:System.Collections.ListDictionaryInternal
    HResult:-2146233079
    2017-08-01 10:49:20,046 | VSTA_Main | ERROR | Failure when custom module included (3)
    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.clsSuiteCRMHelper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
       at SuiteCRMAddIn.Dialogs.ArchiveDialog.TryQuery(String searchText, String moduleName, List`1 fieldsToSeek)
       at SuiteCRMAddIn.Dialogs.ArchiveDialog.Search(String searchText)
    Data:System.Collections.ListDictionaryInternal
    HResult:-2146233079
    2017-08-01 10:49:27,713 | VSTA_Main | WARN  | Tried calling 'get_entry_list' with parameter '{ session = 6kmbj7crsoi4mouq4cmegfnhfb, module_name = Contacts, query = (contacts.first_name LIKE '%************removed***********%' OR contacts.last_name LIKE '%************removed***********%') 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 '%************removed***********%')), order_by = date_entered DESC, offset = 0, select_fields = System.String[], max_results = 1000, deleted = 0 }', timeout is 300000ms
    2017-08-01 10:49:27,713 | VSTA_Main | 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-08-01 10:49:27,713 | VSTA_Main | ERROR | Failure when custom module included (1)
        Query was '(contacts.first_name LIKE '%************removed***********%' OR contacts.last_name LIKE '%************removed***********%') 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 '%************removed***********%'))'
    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.clsSuiteCRMHelper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
       at SuiteCRMAddIn.Dialogs.ArchiveDialog.TryQuery(String searchText, String moduleName, List`1 fieldsToSeek)
    Data:System.Collections.ListDictionaryInternal
    HResult:-2146233079
    2017-08-01 10:49:28,061 | 16 | WARN  | Anonymous thread 16 running as 'Daemon'.
    2017-08-01 10:49:28,061 | 16 | INFO  | About to perform FetchEmailCategoriesAction.
    2017-08-01 10:49:28,546 | VSTA_Main | WARN  | Tried calling 'get_entry_list' with parameter '{ session = 6kmbj7crsoi4mouq4cmegfnhfb, module_name = Contacts, query = (contacts.first_name LIKE '************removed***********' OR contacts.last_name LIKE '************removed***********') 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 '************removed***********')), order_by = date_entered DESC, offset = 0, select_fields = System.String[], max_results = 1000, deleted = 0 }', timeout is 300000ms
    2017-08-01 10:49:28,546 | VSTA_Main | 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-08-01 10:49:28,546 | VSTA_Main | ERROR | Failure when custom module included (2)
        Query was '(contacts.first_name LIKE '************removed***********' OR contacts.last_name LIKE '************removed***********') 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 '************removed***********'))'
    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.clsSuiteCRMHelper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
       at SuiteCRMAddIn.Dialogs.ArchiveDialog.TryQuery(String searchText, String moduleName, List`1 fieldsToSeek)
    Data:System.Collections.ListDictionaryInternal
    HResult:-2146233079
    2017-08-01 10:49:28,546 | VSTA_Main | ERROR | Failure when custom module included (3)
    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.clsSuiteCRMHelper.GetEntryList(String module, String query, Int32 limit, String order_by, Int32 offset, Boolean GetDeleted, String[] fields)
       at SuiteCRMAddIn.Dialogs.ArchiveDialog.TryQuery(String searchText, String moduleName, List`1 fieldsToSeek)
       at SuiteCRMAddIn.Dialogs.ArchiveDialog.Search(String searchText)
    Data:System.Collections.ListDictionaryInternal
    HResult:-2146233079
    2017-08-01 10:49:28,895 | 16 | INFO  | FetchEmailCategoriesAction completed.
    2017-08-01 10:49:30,507 | EM | DEBUG | Auto-Archive iteration completed
    2017-08-01 10:49:58,911 | 16 | WARN  | Anonymous thread 16 running as 'Daemon'.
    2017-08-01 10:50:28,928 | 16 | WARN  | Anonymous thread 16 running as 'Daemon'.
    2017-08-01 10:50:42,146 | VSTA_Main | DEBUG | Outlook NewMail: email received event
    2017-08-01 10:50:58,945 | 16 | WARN  | Anonymous thread 16 running as 'Daemon'.
    
  3. ron member avatar

    ron Verified Purchase

    a year ago

    Is there a solution for this

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