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

Srini_123

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

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

Find more posts tagged with

Reporting

BI Publisher

BI Publisher Data Models

Customizing Reports

Report Output

Accepted answers

Mallikarjuna Kuppauru-Oracle

Hi @User_IZ7U4

sql execution time exceeded the limit of 18000 seconds ,

Can you refer below -

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

Regards,

Arjun

All comments

Mallikarjuna Kuppauru-Oracle

Hi @User_IZ7U4

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

Regards,

Arjun

Sumanth V -Oracle

@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.

Srini_123

@Mallikarjuna Kuppauru-Oracle

Thanks for the response. It is Oracle cloud 24A

Mallikarjuna Kuppauru-Oracle

Hi @User_IZ7U4

sql execution time exceeded the limit of 18000 seconds ,

Can you refer below -

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

Regards,

Arjun

User_HCG55

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

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

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

Regards,

Jehosheba Amruthaluri