Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Bursting (XML Publisher Report Bursting Program) Error

Summary
Bursting (XML Publisher Report Bursting Program) Error
Content
Hello,
I am having the error below while calling the XML Publisher Report Bursting Program from a concurrent program (Report).
XML/BI Publisher Version : 5.6.3
Updating request description
Retrieving XML request information
--SQLException
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1224)
at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:210)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)
Does anyone have an idea what can be the issue please?
Thanks
Tasneem
Answers
-
Hello,
Thanks for replying. I am new to this site.
Please advise how to add an attachment.
Else you can see the code below.
------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type = "bursting">
<xapi:request select="/MK_PAYSLIP/LIST_G_PERSON_ID/G_PERSON_ID">
<xapi:delivery>
<xapi:email server="10.87.1.222" port="25" from="Notifications@airmauritius.com" reply-to ="">
<xapi:message id="123" to="${EMAIL_ADDRESS}" cc="" attachment="true" subject="XML File For ${FULL_NAME}">
Dear All,
Please find attached your Payslip (Test). Rgrds Tasneem
</xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document output="/t01/oracle/inst/apps/TEST_eccerptestapps/logs/appl/conc/out/MK_PAYSLIP_${cp:parent_request_id}_1.pdf" output-type="pdf" delivery="123">
<xapi:template type="rtf" location="xdo://CU.MK_PAYSLIP.en.00/?getSource=true" filter="">
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>
------------------------------------------------------------------------
Thanks
Tasneem
0 -
Hi,
could you please share the bursting control file if possible.
Thanks & Regards
Sri
0 -
Couple of open questions
Did this program ever worked.?
Is this issue happening for specific scenarios.?
Cross check if bursting file above is able to derive all the values.?
If this is the first time you are testing bursting, suggest you to check this step by step.
Hard code values for your testing for this fields ${FULL_NAME}, ${EMAIL_ADDRESS}
0 -
What i meant by "is able to derive all the values". Since it is first time you are doing this, I suggest you to hard code the values for below instead of having bursting xml derive the values from xml file.
${FULL_NAME}, ${EMAIL_ADDRESS}
0 -
Thanks for your reply.
Yes it is the first time that I am using bursting in our environment.
And even while running the Bursting program alone, I am having the same issue.
Please advise what you mean by "is able to derive all the values".
I will try to hard code the variables and advise.
Brgrds
Tasneem
0