XML Bursting Completed With Error

Question

Summary

Content

Hello All,

We are doing bursting program to place the output of one particular concurrent program in the same server as csv file. Here we are getting error as below

LeftOver are  sT7J¿[050217_113544863][oracle.apps.xdo.delivery.ssh2.transport.TransportProtocolClient][STATEMENT] Sending Secret

[050217_113544920][oracle.apps.xdo.delivery.ssh2.transport.MessageSender][STATEMENT] Sending Msg with ID = 30 and Msg length is 140 and padding len is 5

[050217_113544920][oracle.apps.xdo.delivery.ssh2.transport.MessageSender][STATEMENT] Msg ID is 30

[050217_113545021][oracle.apps.xdo.delivery.ssh2.transport.MessageProcessor][STATEMENT] Msg ID is 20

[050217_113545021][oracle.apps.xdo.delivery.ssh2.transport.MessageProcessor][STATEMENT] ***TPC:readMessage: Num of available bytes are :0

[050217_113545022][oracle.apps.xdo.batch.DeliveryHelper][EXCEPTION]a

at oracle.apps.xdo.delivery.ssh2.transport.MessageProcessor.readAndProcessMessage(Unknown Source)

at oracle.apps.xdo.delivery.ssh2.transport.MessageProcessor.sendMessage(Unknown Source)

at oracle.apps.xdo.delivery.ssh2.transport.TransportProtocolClient.sendSecret(Unknown Source)

at oracle.apps.xdo.delivery.ssh2.transport.TransportProtocolClient.startTransportProtocol(Unknown Source)

at oracle.apps.xdo.delivery.ssh2.SFTPDeliveryRequestHandler.submitRequest(Unknown Source)

at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(Unknown Source)

at oracle.apps.xdo.batch.DeliveryHelper.submitRequests(Unknown Source)

at oracle.apps.xdo.batch.bursting.DocumentDelivery.submitCoreDeliveryRequests(Unknown Source)

at oracle.apps.xdo.batch.BurstingProcessorEngine.addDocument2Queue(Unknown Source)

at oracle.apps.xdo.batch.BurstingProcessorEngine.createBurstingDocument(Unknown Source)

at oracle.apps.xdo.batch.BurstingProcessorEngine.burstDocument(Unknown Source)

at oracle.apps.xdo.batch.BurstingProcessorEngine.endDocument(Unknown Source)

at oracle.xml.parser.v2.XMLContentHandler.endDocument(XMLContentHandler.java:120)

at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:430)

at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:307)

at oracle.apps.xdo.batch.BurstingProcessorEngine.burstingRequest(Unknown Source)

at oracle.apps.xdo.batch.BurstingProcessorEngine.burstingEndElement(Unknown Source)

at oracle.apps.xdo.batch.BurstingProcessorEngine.endElement(Unknown Source)

at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:211)

at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1628)

at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:455)

at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:401)

at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:341)

at oracle.apps.xdo.batch.BurstingProcessorEngine.burstingConfigParser(Unknown Source)

at oracle.apps.xdo.batch.BurstingProcessorEngine.process(Unknown Source)

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

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

The same code works well in another environment without any issue, the only difference between the two environment is Operating System.

Application Version: R12.2.6

Database Version: 12.1.0.2

OS : Solaris SPARC 11.3

Kindly help us on this issue.

Regards,

Venkatesh

Vinodkumars · Answer

Hello All,

I am also getting the same error:

+---------------------------------------------------------------------------+

XML Publisher: Version : 12.2

XDOBURSTREP: XML Publisher Report Bursting Program

+---------------------------------------------------------------------------+

Current system time is 10-MAY-2017 11:51:33

+---------------------------------------------------------------------------+

XML/BI Publisher Version : 10.1.3.4.2

--Exception

For input string: "Y"

java.lang.NumberFormatException: For input string: "Y"

at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

at java.lang.Integer.parseInt(Integer.java:492)

at java.lang.Integer.parseInt(Integer.java:527)

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

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

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

Oracle error -20001: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON, ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.POPULATE_ORGS, N, ERRNO, 100, N, REASON, ORA-01403: no data found has been detected in MO_GLOBAL.INIT.

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

Executing request completion options...

Output file size:

0

Finished executing request completion options.

+---------------------------------------------------------------------------+

APP-FND-01388: Cannot read value for profile option CONC_REQUEST_STAT in routine &ROUTINE.

Concurrent request completed

Current system time is 10-MAY-2017 11:51:36

+---------------------------------------------------------------------------+

Rajesh123 · Answer

can you please paste the code how you are submitting burst program? (with parameters)

Rajesh123 · Answer

can u please get me OPP log file for this request ?