Accelerator Troubleshoot
28 May 2018 - updated this help to archive old issues
Cannot see Accelerator in Outlook
The add in may be disabled or in-active.
To check this Open outlook and view the File->Options->Add-ins
Within this area check if the add-in is disabled and re-enable if so
To view add-in options click File
select Options
Click Add-ins
Click the Go... button
and check the box and click OK
The restart outlook
If the add-on is disabled select the disabled option from the drop down and re-enable
If you see an error when clicking on the history button you may need to change the setting sqldatetimeformat
By default it is set to
<add key="sqldatetimeformat" value="yyyy-dd-MM"/>
You may need to change to
<add key="sqldatetimeformat" value="yyyy-MM-dd"/>
Cannot see emails filed within CRM
Ths issue is that the default filter on the communications screen is set to "Pending" and the emails are filed as "Complete". Change your filter to view the emails.
You cannot use the ampersand '&' character or '%' character in a password when using Accelerator. This is due to a bug in the Sage CRM web-service API
Ref: https://community.sagecrm.com/user_community/f/84/p/9460/30971.aspx#30971
Users must have web-service access set to true
New Appointment/Task error in Outlook (webpicker)
If you add a new custom entity to CRM and add the "Communication" field that was created to the screen "AcceleratorWebPicker" you will see this error.
To resolve remove the field from this screen.
Reconnect to CRM - Prompt when outlook is opened. (Sage CRM Offline Access failed)
This can happen when the logon fails when Outlook is started.
A checklist for this is as follows:
1. User is allowed log on to CRM via CRM's web services (Allow WebService Access:True)
Navigate to the users details (Administration -> Users -> Users) and view the users details and check that the "Allow WebService Access" setting is set to true
2. Accelerator license check.
Navigate to "Administration -> Accelerator -> User Management" From that screen check that the user is in the list
3. In the Outlook settings check that the active path is set and that the value is correct
4. You cannot use the ampersand '&' character in a password when using Accelerator (this is due to a web-service bug in Sage CRM).
Date/Time Formatting
The screens displayed in outlook are CRM screens and the date/time formatting is controlled from CRM via the user preferences.
Once changed the changes will only be reflected on the next user session logon. With Outlook this typically will not happen until IIS is reset (or CRM restarts) as it keeps the same session.
Large emails not filing
Issue is down to the size of the email and a limit in IIS
To adjust the limit do the following:
IIS7, IIS Admin & Click your CRM site and expand it then click the ASP icon.
Expand the Limits Properties icon, and change the value in the “Maximum Requesting Entity Body Limit” to a value larger than 200000.
Max value is 2147483647
The Error for this can look like the following:
pr_insertCommunication failed: Entity:person;ID:471;UserId:;Message:Communication creation failed for person:Error occurred during the call to eWare.Init().Exception: Type mismatch
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.;Stack Trace: at SageCRMWSBase.SageCRMWSBaseService.pr_insertCommunication(StringDictionary CommParams, String EntityName, String EntityID, StringDictionary CommLinkParams, String UseUserId, String CommId, Boolean UpdateCommLinks)
15/06/2016 Issue can also appear as:
Error :System.Web.Services.Protocols.SoapException: Communication creation failed for: personID:Error occurred during the call to eWare.Init().Exception: Type mismatch
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.;Message:Communication creation failed for person:Error occurred during the call to eWare.Init().Exception: Type mismatch
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.;Stack Trace: at SageCRMWSBase.SageCRMWSBaseService.pr_insertCommunication(StringDictionary CommParams, String EntityName, String EntityID, StringDictionary CommLinkParams, String UseUserId, String CommId, Boolean UpdateCommLinks) at SageCRMWSBase.SageCRMWSBaseService.pr_insertCommunication(StringDictionary CommParams, String EntityName, String EntityID, StringDictionary CommLinkParams, String UseUserId, String CommId, Boolean UpdateCommLinks) at SageCRMWSBase.SageCRMWSBaseService.pr_insertCommunication(StringDictionary CommParams, String EntityName, String EntityID, StringDictionary CommLinkParams) at SageCRMWS.SageCRMWSAccelerator.insertCommunicationEmail(String EntityName, String EntityID, CRMDocumentClass dc, String emailType)
IIS 8 and 404 messages on screens
You must install .net4.5 via the server manager (add feature) to enable.
Outlook add on keeps disappearing
You need to open your registry and navigate to
HKEY_CURRENT_USER\Software\Microsoft\Office\Outlook\Addins\CRM Together Outlook Add On\
and delete the key
Warmup
and set the value for
LoadBehavior
to be 3
Re-start outlook then
Email date and times are going in incorrectly (EG as 1899)
Chances are you are running MSSQL 2012 and you need to set this as follows:
<add key="sqldatetimeformat2" value="o"/>
CRMCodedPath setting
If your system does not allow http requests from with IIS to an outside/external address you can set the internal address within the web config
<add key="CRMCodedPath" value="" />
sample value
http://localhost/crm
*requires CRM setting IPAddressChecking to be disabled – this is in the registry
Take control of your Outlook 2013 add-ins
https://blogs.office.com/2012/10/08/take-control-of-your-outlook-2013-add-ins/
See also
https://support.microsoft.com/en-us/kb/2733070
System Logging - This is used ONLY to detect environment specific issues
Open windows and enter %temp% in the path
This should open the folder "C:\Users\username\AppData\Local\Temp" for example (or even "C:\Users\username\AppData\Local\Temp\1")
Create a file called "ctlog.txt"
Re-start Outlook.
When you use Accelerator the system will create a file for each day with logging information *this should not be used long term
The log files will be created with the name format
CRMTogetherLogFile_mmddyyyy.txt
EG
CRMTogetherLogFile_06162015.txt
Reproduce any issue and send the file to support (zip up if needed as the file may be large)
Could not create SSL/TLS secure channel
This issue is due to the SSL path (https) not working from the server.
The system acts like a proxy and so if https is used from outside then it is used internally (from the server) also.
Two options here are:
1. Configure the server to work with the https path.
2. Use the CRMCodedPath setting. If your system does not allow http requests from with IIS to an outside/external address you can set the internal address within the web config <add key="CRMCodedPath" value="" /> sample value
*requires CRM setting IPAddressChecking to be disabled – this is in the registry
Manage your add-ins
Click File
You will see a button "Manage COM add-ins".
Click this.
You will see a dialog
Click Always Enable this add-in
and then click Close
Error on Summary screens -
"An existing connection was forcibly closed by the remote host"
Fix: you need to set the "GatewayCRMPath" in the web.config file
EG
<add key="GatewayCRMPath" value="http://www.server.com/CRM/" />
Some users getting errors when filing emails with attachments
This can be caused by the user in CRM not having a first and last name set and also by the first name having a space before the name.
Fix this in CRM itself to resolve this issue (outlook restart required)
4.7.1.0 issue If when using Accelerator a request is made with an invalid session the error response is cached.
In the custompages/sagecrmws/web.config
Add in the line
<add key="DisableCaching" value="Y"/>
to disabled the caching to resolve this.
This will be fixed in 4.7.1.1
