My Oracle Support Banner

11.1.1.9 Business Intelligence Publisher Large Reports Fail With Error 'XMLPGEN:Report data size exceeds the maximum limit...Stopped processing' Due To Missing Memory Guard Default Values (Doc ID 2105963.1)

Last updated on APRIL 30, 2023

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.9.0 to 11.1.1.9.x [Release 11.1]
Information in this document applies to any platform.

Symptoms

Business Intelligence Publisher 11.1.1.9 Enterprise, Enterprise Administration System Configuration issues

  

The BI Publisher product documentation 'Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Publisher' states the default value for 'Maximum Report Data Size' is 300MB per below:

Table F-1 Memory Guard Properties and Descriptions

Property Maximum report data size for online reports
Description Default value: 300MB
        Sets the maximum allowed online report data size. You can set the value in GB, MB, or KB. For example: 1GB, 200MB, or 1500KB

However users receive the error "Report data size exceeds the maximum limit (20971520 bytes)" in bipublisher.log for large reports, as value 'Maximum Report Data Size' is NULL in the BI Publisher properties:

[2016-01-1T11:00:36.875+09:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 11] [userId: <anonymous>] [ecid: 00000000000000000000,0:1] [APP: bipublisher#11.1.1] XMLPGEN:Report data size exceeds the maximum limit (20971520 bytes). Stopped processing.
[2016-01-1T11:00:36.875+09:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 11] [userId: <anonymous>] [ecid: 00000000000000000000000,0:1] [APP: bipublisher#11.1.1] oracle.xdo.memoryguard.XDODataSizeLimitException: Report data size exceeds the maximum limit (20971520 bytes). Stopped processing.[[

 

Changes

 No known changes. 

Cause

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
Symptoms
Changes
Cause
Solution
References


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