[Solved] BI Publisher 12c - oracle.xdo.memoryguard.XDODataSizeLimitException - Report data size exceeds the maximum limit

Issue: oracle.xdo.memoryguard.XDODataSizeLimitException: Report data size exceeds the maximum limit.

Cause: The report was having a large number of records. Which exceeded the 300 MB default data size limit for BI Publisher. In-order to overcome this we required to change the memory guard limit in BI Publisher Runtime configuration.

Resolution:

• Log in to Oracle BI Publisher - http://hostname:9502/xmlpserver/
• Go to Administration > Runtime Configuration > Memory Guard

And Administration > Runtime Configuration > Data Model

Note: The values should be in bytes and not in Megabytes.If you want to give in MB or GB make the parameter values as 2GBb instead of 2 GB etc. Remember to remove the space in this case. 

• Here increase the size for maximum report data size from default to increased value as seen in the above screenshot.

Change/Increase the parameters

1. Maximum Report Data Size for online reports  
2. Maximum report data size for offline (scheduled) reports 
3. Maximum data size limit for data generation 

• Apply the changes. 
• Wait for confirmation that configuration has been changed successfully. 
• Run the report again to see whether the changes have been reflected. 

courtesy: Oracle Blog