My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2022

Applies to:

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



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 <NODE_NAME> 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(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.OracleResultSetImpl.getString(
at oracle.apps.fnd.cp.util.CpUtil.getCanonicalLocalNode(
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(

[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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.