Support Article
Unable to open the report
SA-2167
Summary
When accessing a report in Production, getting the below error message:
"Retrieving the report data exceeded the limit of 30 seconds. Please try making the report more specific by further limiting which rows to include".
On accessing the same report and running the Tracer, observed the following message.
'There was a problem performing a database query: There was a problem getting a list: code: 1013 SQLState: 72000 Message: ORA-01013: user requested cancel of current operation '.
Error Messages
"Retrieving the report data exceeded the limit of 30 seconds. Please try making the report more specific by further limiting which rows to include".
Steps to Reproduce
N/A
Root Cause
Maximum elapsed time was very low ( around 10 seconds ) which was causing the issue
Resolution
Incresae the maximum elapsed time in seconds to 30 seconds and report is opening properly.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.