Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Bursting (XML Publisher Report Bursting Program) Error

Received Response
171
Views
5
Comments
Tnuckchady
Tnuckchady Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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

  • Tnuckchady
    Tnuckchady Rank 3 - Community Apprentice

    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

  • Srikkanthmani
    Srikkanthmani Rank 3 - Community Apprentice

    Hi,

    could you please share the bursting control file if possible.

    Thanks & Regards

    Sri

  • User910243567
    User910243567 Rank 6 - Analytics Lead

    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}

  • User910243567
    User910243567 Rank 6 - Analytics Lead

    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}

  • Tnuckchady
    Tnuckchady Rank 3 - Community Apprentice

    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