Oracle Analytics Cloud and Server

Products Banner

Bursting: java.io.FileNotFoundException (No such file or directory)

Received Response
509
Views
3
Comments

Summary

Bursting: java.io.FileNotFoundException (No such file or directory)

Content

Hi All,

My Bursting program completes in error with the exception

--Exception

/slot/ems3321/appmgr/apps/apps_st/appl/xdo/12.0.0/temp/1559614.xml (No such file or directory)

java.io.FileNotFoundException: /slot/ems3321/appmgr/apps/apps_st/appl/xdo/12.0.0/temp/1559614.xml (No such file or directory)

at java.io.FileInputStream.open(Native Method)

at java.io.FileInputStream.<init>(FileInputStream.java:106)

at java.io.FileInputStream.<init>(FileInputStream.java:66)

at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.zipOutputFiles(JCP4XDOBurstingEngine.java:523)

at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:292)

at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

I set up the temp folder in the administration tab and still i face this issue.

My Control file is as below --

<?xml version="1.0" encoding="utf-8"?>

<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">

<xapi:request select="/XXXDPTAXML/LIST_G_TRX/G_TRX">.

<xapi:delivery>

<xapi:filesystem id="outbound_inv_xml" output="/tmp/${CUSTOMER_TRX_ID}.xml" />

</xapi:delivery>

<xapi:document output-type="xml" delivery="outbound_inv_xml" >

<xapi:template type="XSL" location="xdo://XXX.XXXPTAXML.en.US/?getsource=true" />

</xapi:document>

</xapi:request>

</xapi:requestset>

I tried setting up the XDO.cfg file with the system-temp-dir property to /tmp directory and still facing this issue.

Please help in resolving the issue with  bursting.

Thanks

Anil

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 ✭✭✭✭✭

    The error can come with below reason, you can verify each (ignore if already checked)

    1. Please check the physical path exists in Unix application server which you specify under Administration tab. And you should have write access to that folder. It will be great if you can provide screen shot of the path you set

    2. specify document tab as below

       <xapi:document output="/tmp/${CUSTOMER_TRX_ID}" output-type="xml" delivery="outbound_inv_xml">

    3. Verify that XSL file XXXPTAXML registor under territory US, you can check this by below sql

             

                select TERRITORY from xdo_lobs where lob_code = 'XXXPTAXML';

          if it gives territory as 00 then change template tag as

             

                <xapi:template type="XSL" location="xdo://XXX.XXXPTAXML.en.00/?getsource=true" />

  • Hi Brajesh

    1. Please check the physical path exists in Unix application server which you specify under Administration tab. And you should have write access to that folder. It will be great if you can provide screen shot of the path you set

    The /temp path exists in the application server and the same is specified in Administration Tab. The Folder has all the access granted.

    image

    image

    2. specify document tab as below

       <xapi:document output="/tmp/${CUSTOMER_TRX_ID}" output-type="xml" delivery="outbound_inv_xml">

    -- Still the same error

    3. Verify that XSL file XXXDPTAXML registor under territory US, you can check this by below sql

    i verrified it using the below query

    SELECT APPLICATION_SHORT_NAME||'.'||

    TEMPLATE_CODE||'.'||

    DEFAULT_LANGUAGE ||'.'||

    DEFAULT_TERRITORY

    FROM XDO_TEMPLATES_VL

    WHERE TEMPLATE_CODE like 'XXXDPTAXML'

    -- XXX.XXXDPTAXML.en.US

    Also, Please let me know if the template tye should be XSL or XSL-XML, tried both but the same error

    Thanks

    Anil

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 ✭✭✭✭✭

    This error prompt that template is not getting picked up properly .....Can you specify template type as "xslxml" and try as below

    <xapi:template type="xslxml" location="xdo://XXX.XXXPTAXML.en.US/?getsource=true" />