Query Timeout Error when Printing Checks

(0) Share

Report

Posted on by JGarcia123

1,599

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?

All responses (1)

Answers (0)

Suggested answer

CFROTON 4,710 on at

Like (0)

Report

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