KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException

Question

We are using KingswaySoft SSIS integration to push data (60k) into CRM 2015. There is a daily job which is set to run this package, which passes successfully sometime and fails sometime with this error. Please suggest troubleshooting/fix.

Delete Sales Transaction data of months in CRM:Error: An error occurred with the following error message:

KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: CRM service call returned an error: The request channel timed out while waiting for a reply after 00:02:59.9843634. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.(Error Type / Reason: Timeout) (SSIS Integration Toolkit for Microsoft Dynamics CRM, v7.0.0.5660 - ISServerExec, v11.0.5058.0)

KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: The request channel timed out while waiting for a reply after 00:02:59.9843634. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.(Error Type / Reason: Timeout)

System.TimeoutException: The request channel timed out while waiting for a reply after 00:02:59.9843634. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.

System.TimeoutException: The HTTP request to 'crm.abc.com.au/.../Organization.svc' has exceeded the allotted timeout of 00:03:00. The time allotted to this operation may have been a portion of a longer timeout.

System.Net.WebException(Status Reason: Timeout): The operation has timed out

Also since it is giving timeout issue, is it worth trying to increase timeout period? please guide how we can perform it.

Answer 1

First of all, we thank you for choosing KingswaySoft.

For the timeout error that you are getting, it indicates that a service call is taking a longer time than what you have specified in the connection manager. There are a couple of options in your case.

• If this is happening to a CRM destination component, you should consider decreasing its Batch Size setting.
• If you are using Upsert action with manually specified key fields in the destination component, you want to make sure you have created db indexes for the fields that you have selected for Upsert matching.
• You may also increase your CRM connection manager’s Timeout setting.

Based on the error message, it appears that you are using 180 seconds as your timeout setting, which is plenty for any service calls. Having a timeout error in this case could be an indication that you have some design issues with your CRM application. You might want to revisit your CRM plugin or workflow code if you have any.