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

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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