Absence Accrual Report is getting Timeout error.
Summary:
Absence Accrual Report is getting Timeout error.
Error Code: SQL Query execution time exceeds the limit (500 sec)..stopped processing
We have reproduced the issue in the TEST Pod, and the issue occurs only in Online view mode. When the report is executed in Schedule mode, it completes successfully (please see the attachment). However, when the same report is scheduled in the PROD environment, it fails.
→ Query timeout parameter in Data model is not working when schedule. (How much we can mention)
→ SQL Prune also not working
Can anyone help me in this case please.
Content (please ensure you mask any confidential information):
Tagged:
0