BI Publisher Report Results In Java Heap Size Error

(Doc ID 1549274.1)

Last updated on MARCH 19, 2017

Applies to:

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

Symptoms

On: 11.1.1.6.4 version, when attempting to execute the interactive report, the error below occurs.
This error occurs for one report that extract huge data:

Error

The report cannot be rendered because of an error, please contact the administrator.

Error Detail
Java heap space

 
The xdo.log or bipublisher.log show the following errors:

[042313_185546741][][EVENT] DEConnection::closeConnections: close connection for  [PEX_SIT]
[042313_185546743][][EXCEPTION] java.sql.SQLException: Protocol violation: [8, 1]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:502)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF

 

[042313_185546744][oracle.xdo.servlet.XDOServlet][EXCEPTION] java.lang.OutOfMemoryError: Java heap space

[042313_185546744][][EXCEPTION] UIUTils.renderError: strict servlet API: cannot call getWriter() after getOutputStream()

 

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