Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Plugin - SQL Server timeout expired

(0) ShareShare
ReportReport
Posted on by 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

  • Suggested answer
    gdas Profile Picture
    50,091 Moderator on at
    RE: Plugin - SQL Server timeout expired

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
Victor Onyebuchi Profile Picture

Victor Onyebuchi 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans