478 total views, 11 views today

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
  • Priyanka Nandi

    Hi
    I have issue with BIP reports which is integrated with siebel.I am facing time out issue while running report from siebel.
    Priyanka

    • Govindan Padmanaban

      Is it SQL Timeout? Did you check the STEP 3?

      What happen if you run the Query in SQLPLUS?

      • Priyanka Nandi

        Actually I have not created the report based on SQL.I have created the report depending on the XML from Integration Object from Siebel

  • HuanLe

    Hi Govin,
    Could you help me to explain and resolve this error, plz? When I view/export Publisher report with large data:

    oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown!
    FO processing stopped at 128MB memory usage; Large table in page header/footer detected

Like us on Facebook.
Connect!