You’re offline. This is a read only version of the page.
155
I have an Async plugin that track updates to contact entity fields (almost 55 attributes) and sends the updated information to external database via stored proc. The stored proc then inserts a record in the table and there are triggers on insert.
The plugin errors out with SQL Server timeout when it executes the stored proc. But the same plugin executes successfully when the triggers are disabled. My understanding is the plugin execution time is exceeding 2minutes when the triggers are enabled.
Please suggest me if there is any other alternative way to handle this scenario?
<InnerFault>
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #8ED49518</Message>
<Timestamp>2018-04-06T14:33:39.1666206Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault>
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d4p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>System.ComponentModel.Win32Exception: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #FD5C041C</Message>
<Timestamp>2018-04-06T14:33:39.1666206Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</InnerFault>
Thank you..
*This post is locked for comments
I have the same question (0)
Hi,
I am afraid how you are communicating another database using stored procedure inside plugin. Try to avoid this kind of design as you are using asynchronous plugin.
Ideally in this scenario it is prefer to use WCF service to communicate with another application or database.
Or if you are using same server then you may use some batch application or console application to pull the data from CRM using API and send it to the another database.
Please refer below thread where I have shared one console application -
community.dynamics.com/.../273478
Hope this helps.
Share
Report
All responses (
Answers (
