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
768
Views
7
Comments
User_IZ7U4
User_IZ7U4 Rank 2 - Community Beginner
in Oracle Analytics Publisher

BIP Reports completing with 'Time Out' ERROR after running around 3 hours and exceeding the Data Model 'Query Time out" limit and displaying below error message

Waiting Time: 0.7 seconds
Data Fetch Time: 2.7 hours
Total Execution Time: 2.7 hours
Job Priority: Normal

Waiting Time: 0.7 seconds
Data Fetch Time: 2.7 hours
Total Execution Time: 2.7 hours
Job Priority: Normal

Job processor caused exception
[INSTANCE_ID=bip.bi_server1] [INSTANCE_JOB_ID=1290578]

Error getting report data
[INSTANCE_ID=bip.bi_server1] DataException:[INSTANCE_JOB_ID=1290578] 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

oracle.xdo.servlet.data.DataException: oracle.xdo.serv

Tagged:

Best Answer

Answers

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

    Hi @User_IZ7U4

    Can you provide me your product details (Onprem or Cloud) and version ?

    Regards,

    Arjun

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_IZ7U4 - In the context of Business Intelligence Publisher (BIP), "Data Fetch Time: 2.7 hours" means that the process of retrieving the required data from the source database or data source took 2.7 hours. This duration includes the time needed to execute the SQL queries, fetch the data, and possibly any additional data processing or transformations performed before the data is available for report generation.
    Please let us know when you execute the query directly on the DB, how much time does it take to complete. Also, limiting the results by adding more search criteria or filters would also help overcoming this error.

  • User_IZ7U4
    User_IZ7U4 Rank 2 - Community Beginner

    @Mallikarjuna Kuppauru-Oracle

    Thanks for the response. It is Oracle cloud 24A

  • User_HCG55
    User_HCG55 Rank 2 - Community Beginner

    Hi,

    The best way to avoid this error is to create a custom ESS job for your BIP report. This works like a charm.

    Regards

    Jehosheba Amruthaluri.

  • Sowbhagya B
    Sowbhagya B Rank 1 - Community Starter
    edited December 2024

    There is a BIP custom report has ESS job Created but still it is showing below error for me. Please help what to do

    ORA-56733: logical I/O limit exceeded - call aborted

  • User_HCG55
    User_HCG55 Rank 2 - Community Beginner
    edited December 2024

    @Sowbhagya B Work on improving the performance of your query and try adding a /*+ parallel(4) */ hint in your select query.

    Regards,

    Jehosheba Amruthaluri