XML report completing with error and not opening

[karthikmca.bhc]

Hi Erman,

I  am running one xml concurrent request and that completing with error. request log is given below. Please provide workaround/fix for this issue.

---------------------------------------------------------------------------+
Enterprise Upstream Production: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

OS1304_V2 module: Well Potentials Report
+---------------------------------------------------------------------------+
Current system time is 24-DEC-2018 13:50:39
+---------------------------------------------------------------------------+
XDO Data Engine Version No: 5.6.3
Resp: 50763
Org ID : null
Request ID: 751035
All Parameters: P_DATE=JUN-2018:P_FACL=PS3:P_CATE=
Data Template Code: OS1304_V2
Data Template Application Short Name: EU
Debug Flag: N
{P_CATE=, P_DATE=JUN-2018, P_FACL=PS3}
Calling XDO Data Engine...
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
37261
+--------- 1) POST-PROCESSING  ---------+
Beginning post-processing of request 751035 on node D1LOGPSP01 at 24-DEC-2018 13:50:42.
-- Publishing output

 Post-processing of request 751035 failed at 24-DEC-2018 13:50:42 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
 
CONC-POST-PROCESSING RESULTS

-- PUBLISH:
oracle.apps.fnd.cp.opp.PostProcessorException: java.sql.SQLException: Exhausted Resultset
+---------------------------------------+
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 24-DEC-2018 13:50:42


The OPP log is showing as below,

[12/24/18 1:35:41 PM] [122531:RT751032] Completed post-processing actions for request 751032.
[12/24/18 1:50:42 PM] [OPPServiceThread1] Post-processing request 751035.
[12/24/18 1:50:42 PM] [122531:RT751035] Executing post-processing actions for request 751035.
[12/24/18 1:50:42 PM] [122531:RT751035] Starting XML Publisher post-processing action.
[12/24/18 1:50:42 PM] [122531:RT751035]
Template code: OS1304_V2
Template app:  EU
Language:      en
Territory:     US
Output type:   PDF
[12/24/18 1:50:42 PM] [UNEXPECTED] [122531:RT751035] java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1226)
at oracle.apps.fnd.cp.util.CpUtil.getCanonicalLocalNode(CpUtil.java:131)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:184)

[12/24/18 1:50:42 PM] [122531:RT751035] Completed post-processing actions for request 751035.

[ErmanArslansOracleBlog]

1) Please provide me the details of your environment? (version?, RAC or single not?)
2) Did you check the SQL query of this failing request? Probably, the query is failing in the backend and that's why you are seeing the exhausted result set error..
3) Please enable trace for this concurrent program and re-run it. Send me the db trace of the concurrent program after the execution, so I can check the queries as well.

[karthikmca.bhc]

Thanks Emman for giving me test workaround and quick support. I enabled the trace and found some abnormal entries related to the hostname. When I check /etc/hosts file its not updated properly. I updated it and bounced the concurrent managers then it got fixed. 

Thanks a lot for your advise and it’s much helpful to me for troubleshooting and fixing this issue. 

Thanks,

Karthik

On Tue, Dec 25, 2018 at 2:39 PM ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

1) Please provide me the details of your environment? (version?, RAC or single not?)
2) Did you check the SQL query of this failing request? Probably, the query is failing in the backend and that's why you are seeing the exhausted result set error..
3) Please enable trace for this concurrent program and re-run it. Send me the db trace of the concurrent program after the execution, so I can check the queries as well.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/XML-report-completing-with-error-and-not-opening-tp7019p7023.html

To unsubscribe from XML report completing with error and not opening, click here.
NAML

--