Subledger Period Close Exceptions Report - SQL query time exceeds the limit (2400 sec)
SummaryReport times out when run for Projects
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.