Bursting (XML Publisher Report Bursting Program) Error

Question

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

User910243567 · Answer

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}

MK_User · Answer

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

User910243567 · Answer

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}