Dynamics Community Forum Thread Details

Plugin - SQL Server timeout expired

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>