Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Accepted answer
3262
Views
7
Comments
Siv
Siv Rank 1 - Community Starter
edited Nov 3, 2023 11:51AM in Oracle Analytics Publisher

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.

Tagged:

Best Answer

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    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
    Abhinay Singh-Oracle Rank 1 - Community Starter

    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
    Srini_123 Rank 3 - Community Apprentice

    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
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @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
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    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

  • Raghu Seregar
    Raghu Seregar Rank 1 - Community Starter

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