Output Post Processor Fails Due to java.sql.SQLException: Exhausted Resultset (Doc ID 740529.1)

Last updated on JUNE 24, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.0 to 12.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 11.5.0 to 11.5.10.2
Oracle XML Publisher - Version: 12.0.0 to 12.0.4
EXECUTABLE:XDOREPPB - Generate PDF from XML output and given template

Checked for relevance on 10-MAR-2013


Symptoms

XML Publisher related concurrent request are failing with the following error in the request log file:

...
+------------- 1) PUBLISH -------------+
Beginning post-processing of request 661465 on node AS31 at 29-SEP-2008 17:17:42.
Post-processing of request 661465 failed at 29-SEP-2008 17:17:42 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+
...

 
The Output Post Processor (OPP) log file can be determine as per the instructions from <Note 364547.1> Troubleshooting Oracle XML Publisher for Oracle Applications. Within this log file the following error is found:

...
[9/29/08 5:17:42 PM] [107442:RT661465] Executing post-processing actions for request 661465.
[9/29/08 5:17:42 PM] [107442:RT661465] Starting XML Publisher post-processing action.
[9/29/08 5:17:42 PM] [107442:RT661465] 
Template code: ARXUNAJR
Template app:  AR
Language:      en
Territory:     US
Output type:   PDF
[9/29/08 5:17:42 PM] [UNEXPECTED] [107442:RT661465] java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:382)
at oracle.apps.fnd.cp.util.CpUtil.getCanonicalLocalNode(CpUtil.java:127)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:210)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:172)

[9/29/08 5:17:42 PM] [107442:RT661465] Completed post-processing actions for request 661465.
...

It can occur on any XML Publisher related report that makes use of the Output Post Processor and it does reproduce at will by simply running such a concurrent request.

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