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

BIP report issue

edited Jan 14, 2019 4:26PM in Reporting and Analytics for HCM 8 comments

Summary

SQL query time exceeds the limit (2400 sec). Stopped processing.

Content

Hi Team,

As an Admin, I can run a report and it completes sucessfully for me. Users can't run the report. For entire population, the report runs for 40min (probably time out maximum) and then throw: SQL query time exceeds the limit (2400 sec). Stopped processing.

It is not a performance issue because I can run the same report with same parameters in around 22 min.

It seems some bad data or bad code is causing the issue but not for entire population because even users can run the report for indiviuals IDs.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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