Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Query Timeout Error when Printing Checks

Posted on by 1,357

Our side was printing checks this morning and ran into the following:

System Message 63: [Microsoft][SQL Server Native Client 11.0]Query timeout
expired

The process would start and would stop a few seconds later with the above message in the Event Log.  After some investigation the issue was a trigger in the AcctXRef and AcctSub.  The resolution was to add the SET NOCOUNT ON parameter to the appropriate triggers and the issue was resolved.  

This site has been operational on SL2015 for 3 or 4 years and fairly stable.  I'm a bit confused as to why this would become a problem all of a sudden?  Any thoughts out there?

JG 

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Query Timeout Error when Printing Checks

    Hello JG,

    I'm guessing that they ran procs and indexes on the database.

    Best Regards,

    Jana MacDonald

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans