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 JULY 17, 2017

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

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms