Inconsistent report bahavior with error ORA-56733: logical I/O limit exceeded - call aborted
Hello,
We have a BIP report which is a customized version of the Account Analysis report.
In this report, we have added sub-queries to have the reconiciliation details in the report. It was a complex query with multiple sub-queries within, cases conditions, etc.
Our problem is that it has an inconsistent behavior. |
For example, if we run the report for Jan-23 to Dec-23 period for the same ledger, one instance it would succeed, one instance it would fail.
The error we are getting when it fails is ORA-56733: logical I/O limit exceeded - call aborted.
And at first we thought it was just a timeout error. Because we also have this message:
Tagged:
2