File Size restriction for XML Publisher Report Bursting Program

Question

Summary

Content

Hi All,

Do we have any file size restriction to pick the file from outbound directory for the program 'XML Publisher Report Bursting Program'??

I have developed a program which gives XML file as output which is nearly 10MB in size. The bursting program(the call to bursting program is done in my custom code) for this program is getting failed with the below error:

[030617_075415393][][EXCEPTION] java.lang.NullPointerException

at java.util.Hashtable.put(Hashtable.java:394)

at oracle.apps.xdo.oa.cp.CPUtil.setProperty(CPUtil.java:67)

at oracle.apps.xdo.oa.cp.CPUtil.getSessionProperties(CPUtil.java:45)

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

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

XML/BI Publisher Version : 5.6.3

Updating request description

Retrieving XML request information

Preparing parameters

File /d01/app/stoa083/share/conc/out/o124111374.out is not accessable from node/machine L118464VAPS2006.

--Exception

File /d01/app/stoa083/share/conc/out/o124111374.out is not accessable from node/machine L118464VAPS2006.

oracle.apps.fnd.cp.request.FileAccessException: File /d01/app/stoa083/share/conc/out/o124111374.out is not accessable from node/machine L118464VAPS2006.

at oracle.apps.fnd.cp.request.RemoteFile.getFile(RemoteFile.java:440)

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

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

However when I submit the same program to fetch data in less size (around 500  KB) for different input parameters, the bursting program works fine and the email is sent to respected recipient without any issues.

So can you please confirm if we have any restrictions on the size of the file that bursting program will pick. Please let us know what would be the workaround for this.

Thanks,

Sreekanth

Brajesh Shukla-95078 · Answer

Hi,

Busting program will not restrict size of the output. This may be issue with the space available for busting in busting path directory.

Go to XML Publisher Administrator > Administration tab > Under Property >  General > Temporary directory , please check what is the directory path provided here. This is the path used by XML Busting program to generate Busting output. Check if you have enough space allocated for this directory.

Regards,

Brajesh

Dwalczak · Answer

I know there is a size limitation. Also, there is some setting in possibly jde.ini or jas.ini for kernels. You need to search on that. Option was to have a wrapper report that calls the BIP report in sections.