nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

BIP Reports are ending in Error with ORA-56733: logical I/O limit exceeded - call aborted

Siv

Custom Scheduled BIP Reports are ending in error with the below details. The Report ran approx 1 hour and got ended in error.

Error getting report data

[INSTANCE_ID=bip.bi_server1] DataException:[INSTANCE_JOB_ID=1733694] SQL execution was terminated by DB resource manager as the sql execution time exceeded the limit of 18000 seconds.

oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-56733: logical I/O limit exceeded - call aborted

Please let us know how to fix the issue.

Find more posts tagged with

BI Publisher

Accepted answers

Srini_123

I created a new post for the same issue .

https://community.oracle.com/products/oracleanalytics/discussion/21818/bip-reports-are-ending-in-error-with-ora-56733-logical-i-o-limit-exceeded-call-aborted

All comments

Mallikarjuna Kuppauru-Oracle

Hi User_EAJJJ ,

Can you refer below MOS doc -

Scheduling Report Both Online and Offline Generates 'SQL query time exceeds the limit' Error (Doc ID 2422215.1)

ANNOUNCEMENT: FA-SAAS SQL Guardrails for Long-Running BI Reports and Queries (Doc ID 2884584.1)

Regards,

Arjun

Abhinay Singh-Oracle

Hi User_EAJJJ,

Are you able to find a solution to this? wherein Report ran approx 1 hour and got ended in error.

Thanks,

Abhinay

Srini_123

Hi @Mallikarjuna Kuppauru-Oracle , I am receiving "400 Bad Request" message when I tried to open the above links that you mentioned. We have similar issue with BIP reports completing with timeout error. I have increased the DM query time out limit to 10800 but it still completes with above mentioned error message. Please let us know

Sumanth V -Oracle

@User_IZ7U4 - This is an old thread, please create a new one with all the issue details along with version of application used. Even though error appears same behavior may be different based on version of application and the query being used etc. Also, newer threads have better visibility and avoids ambiguity. Thanks.

Mallikarjuna Kuppauru-Oracle

Hi @User_IZ7U4

Above links are valid . You need to login into support.oracle.com to see the MOS document information.

however its better to raise an new question, instead of posting on old thread.

Regards,

Arjun

Srini_123

I created a new post for the same issue .

https://community.oracle.com/products/oracleanalytics/discussion/21818/bip-reports-are-ending-in-error-with-ora-56733-logical-i-o-limit-exceeded-call-aborted

Raghu Seregar

trying adding hint "+PARALLEL(bal 32)" on the main select clause.