SQL query time out error in BI Reports
Summary
Getting SQL query time out error in BI ReportsContent
Hi Experts,
We are getting SQL query time out error in BI Reports.
have made changes Query Time out to 1000000 and Enabling SQL Pruning to “On” – SQL pruning enhances in the Data Model Properties.
But we are getting below timeout error. We are requesting you to help me on this issue.
Error Message:
Detail Message:
::JOB_WAIT_TIME_SECONDS{2}::JOB_FETCH_TIME_HOURS{14.2}::JOB_EXECUTION_TIME_HOURS{14.2}::JOB_PRIORITY_COLON_NORMAL::::JOB_PROCESSOR_EXCEPTION::[INSTANCE_ID=bip.bi_server1] [INSTANCE_JOB_ID=1640034]::::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=bip.bi_server1] DataException:[INSTANCE_JOB_ID=1640034] oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 246 with name “_SYSSMU246_3157079749$” too small