You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Subledger Period Close Exceptions Report - SQL query time exceeds the limit (2400 sec)

Received Response
19
Views
3
Comments
edited May 22, 2021 6:39AM in Subledger Accounting & Accounting Hub 3 comments

Summary

Report times out when run for Projects

Content

Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptions Report timing out when it usually completes for all Sources in around a minute? I've put a post on the reporting forum regarding this too, should the problem be with the report code rather than caused by data.

After some investigation, it looks like the problem is with Projects - running the report for other sources completes successfully within a minute or so but running it for a source of Projects shows the same behaviour when run for everything - i.e. it runs for 40 minutes then errors with the SQL timeout.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!