Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
BIP report issue
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:
1