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

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

Closed Bug? created by stevebrooks 7 years ago

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

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    7 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

    7 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

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