Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

BIP Report fails with Maximum Limit Exceeded even after applying all filters

Received Response
105
Views
3
Comments
Parag Hiremath
Parag Hiremath Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

BIP Report fails with Maximum Limit Exceeded even after applying all filters

Content (please ensure you mask any confidential information):

Hi Team,

Greetings!

We are getting below error for one of the payroll reports - even after providing the limited values of date range and applying values to all the filters -

Stopped processing the report. Report data size of 16106127838 bytes exceeds the maximum limit of 16106127360 bytes.The estimated XML data size exceeds the 16106127360 bytes.Review your data model SQL queries. Add more filters to limit the data fetch size.

if anyone has any inputs to get this working - please let me know.

Thanks

Parag

Tagged:

Answers

  • Praveen Kumar Akkala-Oracle
    Praveen Kumar Akkala-Oracle Rank 6 - Analytics Lead

    Hello @Parag Hiremath,
    The error message still says that the report output size has exceeded the maximum limit, So you still need to apply more filters to restrict the amount of the data generated in the report.

    Thanks,
    Praveen

  • ravikiran goda-Oracle
    ravikiran goda-Oracle Rank 6 - Analytics Lead

    hi @Parag Hiremath

    are you calling OTBI report from BIP data model? or issue is related to OTBI report?

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead

    There are memory guard limits that are set on the BI server which helps in performance and limits the chance of a BI server crash.
    These parameters are set fleet wide and cannot be changed.

    Solutions to Reduce Report Size & Prevent Errors:

    1. Optimize Data Model SQL Queries
    2. Reduce Output File Size
    3. Choose Alternative Delivery Methods

    Review below KM note which might be helpful:

    oracle.xdo.memoryguard.XDODataSizeLimitException: Report data size (1240583079 bytes) exceeds the maximum limit (524288000 bytes). Stopped processing. (Doc ID 2581748.1)

    Why Error Detail oracle.xdo.memoryguard.XDODataSizeLimitException: Report data size (X bytes) exceeds the maximum limit (X bytes). Stopped processing occurs? (Doc ID 2853652.1)

    BI Publisher Memory Guard Error "Report Data Size Exceeds The Maximum Limit" (Doc ID 2370893.1)