My Oracle Support Banner

Maximum Report Data Size for Offline or Online Reports Exceeds the Limit (Doc ID 2816218.1)

Last updated on JANUARY 24, 2022

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.

Purpose

The Maximum report data size for offline (scheduled) reports property sets the XML data size limit for the scheduled jobs.
This feature enables you to specify a maximum data size allowed for scheduled reports. When you set a maximum data size, the following occurs when a scheduled report job executes:
1. The scheduler commences processing of a report job.

2. The data engine generates the data for the report.

3. If the data generated is larger than the maximum setting, the report processing is ended. The scheduled report job fails with the following status message:
Report data size (NNNNN bytes) exceeds the maximum limit (524288000 bytes). The estimated XML data size is <xxx> bytes. Review your data model SQL queries. Add more filters to limit the data fetch size.
Report stopped processing.

Note:  The user can then set parameters (if available for the report) to limit the data.
The default value for this property is 500MB.

 

 

The Maximum report data size for online reports property enables you to specify a maximum data size allowed for online report viewing. When you set a maximum data size, the following occurs when a user opens a report for online viewing:
1. A user submits a report to view online in the browser.

2. The data engine generates the data for the report.

3. Before document generation, the size of the data (in bytes) is inspected.

4. If the data generated is larger than the maximum setting, the report processing is ended. The user gets the following message:
Report data size (NNNNN bytes) exceeds the maximum limit (314572800 bytes).
Report stopped processing.
Either re-run with parameters that reduce the data or schedule this report.
Contact your Administrator if you have questions.

Note:  The user can then either set parameters (if available for the report) to limit the data and resubmit online; or use the scheduler to submit the report.
The default value for this property is 300 MB.

 

 

Below is a screenshot of the setting when navigating to XMLPSERVER -> Administration -> Runtime Properties -> Properties -> Memory Guard:

 

See BI Publisher documentation for more details.

https://docs.oracle.com/middleware/bi12214/bip/BIPAD/BIPAD.pdf
Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Publisher
Chapter 11 - Defining Runtime Configurations
Section: Restricting Maximum Data Sizes for Report Processing

 

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.