Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
XML Bursting Completed With Error
Summary
XML Bursting Completed With Error
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
Answers
-
Hello All,
I am also getting the same error:
+---------------------------------------------------------------------------+
XML Publisher: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
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
+---------------------------------------------------------------------------+
0 -
can you please paste the code how you are submitting burst program? (with parameters)
0 -
can u please get me OPP log file for this request ?
0