Common Oracle BI Publisher Errors

Home/OBIEE/Common Oracle BI Publisher Errors

Common Oracle BI Publisher Errors

 

033017_0320_CommonBIPub1 Common Oracle BI Publisher Errors

 

This section I have posted the common BI Publisher errors that I have got during the report development. These are runtime properties so the server restart is not required.  The parameter I specified here are for demonstration purpose, the values may vary for each one and it depends on the report. 

 

A) Report data size exceeds the maximum limit (XXXX bytes). Stopped processing.

 

The scheduled report data size exceeds the default size server runtime property. The default size is 500MB. Increase the data size will solve this issue. No restart is required after setting this property

 

Solution:

1. Login into BI Publisher ( http://HOST:PORT/xmlpserver ) as Administrator

2. Click on the Administrator in the top right corner

3. Click Runtime Property under Runtime Configuration

4. Scroll down and increase the size of Maximum report data size for offline (scheduled) reports under Memory Guard

 

033017_0320_CommonBIPub2 Common Oracle BI Publisher Errors

 

Note: Click BI Publisher Runtime Properties for a step by step instruction to understand and navigate to Server Runtime Property

 

B) SQL query time exceeds the limit (600 sec). Stopped processing

 

The SQL Query in the data model takes more than the time specified in the server runtime properties. The default is 600 sec

 

Solution:

 

1. Login into BI Publisher ( http://HOST:PORT/xmlpserver ) as Administrator

2. Click on the Administrator in the top right corner

3. Click Runtime Property under Runtime Configuration

4. Increase the SQL Query Timeout

 

033017_0320_CommonBIPub3 Common Oracle BI Publisher Errors

 

C) The report you are trying to run exceeds the data limit set for this server. Either re-run with parameters that reduce the data or schedule this report. Contact your Administrator if you have questions

 

The report you are running exceeds the data size that specified in the BI Publisher Runtime property. The default is 300MB. Increase the value will solve the issue

 

Solution:

 

1. Login into BI Publisher ( http://HOST:PORT/xmlpserver ) as Administrator

2. Click on the Administrator in the top right corner

3. Click Runtime Property under Runtime Configuration

4. Increase the Maximum report data size for Online reports

 

033017_0320_CommonBIPub4 Common Oracle BI Publisher Errors

 

Note: Click BI Publisher Runtime Properties for a step by step instruction to understand and navigate to Server Runtime Property

 

D) oracle.xdo.server.ServerException: oracle.xdo.memoryguard.XDOFormattingTimeoutException: Formatting time(653 seconds) exceeds the time limit(600 seconds). Stopped processing.

The report you are running exceeds the report formating time limit that specified in the BI Publisher Runtime property. The default is 600 seconds. Increase the value will solve the issue

Solution:

1. Login into BI Publisher ( http://HOST:PORT/xmlpserver ) as Administrator

2. Click on the Administrator in the top right corner

3. Click Runtime Property under Runtime Configuration

4. Increase the Process timeout for Online Report Formatting 

 

Note: This property was not disabled on my local BI Publisher 11.1.1.9.0 version and came after installed the latest BI patch. From BI 12C onwards, this is one of default BI Runtime property 

 

040117_0312_A1 Common Oracle BI Publisher Errors

 

 

Thanks for reading my post. Hope you might get useful information here.  I will add BI Publisher errors and solution to this post whenever I get a new one.

govindan Common Oracle BI Publisher Errors
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan Common Oracle BI Publisher Errors
Connect me
Like us on Facebook.
Connect!