提交请求输出XML文件的时候出错.解决方法
最近在做 XML Publisher，在提交了请求后总是出现黄色 Warning，log 如下：
+---------------------------------------------------------------------------+
General Ledger: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
CUXJRNPRT module: OAF:Journal Print
+---------------------------------------------------------------------------+
Current system time is 28-DEC-2005 08:21:12
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
XML_REPORTS_XENVIRONMENT is :
/u02/TEST/testora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
XENVIRONMENT is set to /u02/TEST/testora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
AMERICAN_AMERICA.UTF8
'.,'
Spawned Process 1327408
Report Builder: Release 6.0.8.25.0 - Production on Wed Dec 28 08:21:13 2005
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter Username:
+---------------------------------------------------------------------------+
Executing request completion options...
+------------- 1) PUBLISH -------------+
Beginning post-processing of request 427843 on node ERP2 at 28-DEC-2005 08:21:13.
Post-processing of request 427843 failed at 28-DEC-2005 08:21:14 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+
+------------- 2) PRINT -------------+
+--------------------------------------+
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 28-DEC-2005 08:21:14
+---------------------------------------------------------------------------+
去查检了 Output Post Processor 管理器，正常运行，看 log 是有问题的，XML Publisher 的报表出现警告估计是这个原因，请大家帮忙诊断一下
[12/28/05 8:16:38 AM] [main] Starting GSF service with concurrent process id = 104012.
[12/28/05 8:16:38 AM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[12/28/05 8:16:38 AM] [Thread-14] Service thread starting up.
[12/28/05 8:16:38 AM] [Thread-15] Service thread starting up.
[12/28/05 8:21:13 AM] [OPPServiceThread1] Post-processing request 427843.
[12/28/05 8:21:14 AM] [104012:RT427843] Executing post-processing actions for request 427843.
[12/28/05 8:21:14 AM] [104012:RT427843] Starting XML Publisher post-processing action.
[12/28/05 8:21:14 AM] [104012:RT427843]
Template code: JOURNAL_RTF
Template app: SQLGL
Language: zh
Territory: CN
Output type: PDF
[12/28/05 8:21:14 AM] [UNEXPECTED] [104012:RT427843] java.sql.SQLException: Non supported SQL92 token at position: 1:
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Inlined Compiled Code))
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java(Inlined Compiled Code))
at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java(Compiled Code))
at oracle.jdbc.driver.OracleSql.handleODBC(OracleSql.java(Compiled Code))
at oracle.jdbc.driver.OracleSql.parse(OracleSql.java:72)
at oracle.jdbc.driver.OracleConnection.nativeSQL(OracleConnection.java:1269)
at oracle.jdbc.driver.OracleStatement.expandSqlEscapes(OracleStatement.java:6794)
at oracle.jdbc.driver.OracleStatement.parseSqlKind(OracleStatement.java:6781)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:152)
at oracle.jdbc.driver.OracleCallableStatement.<init>(OracleCallableStatement.java:77)
at oracle.jdbc.driver.OracleCallableStatement.<init>(OracleCallableStatement.java:48)
at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1220)
at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
at oracle.apps.fnd.cp.util.RemoteFile.transferFile(RemoteFile.java:168)
at oracle.apps.fnd.cp.util.RemoteFile.transfer(RemoteFile.java:127)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:208)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:153)
[12/28/05 8:21:14 AM] [104012:RT427843] Completed post-processing actions for request 427843.
到网上查下，发现要打补丁4473635,于是下来了，看了README.txt打了之前必须的补丁，但是还是出错,
seLECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
WHERE fcpp.processor_id = fcp.concurrent_process_id
AND fcpp.action_type = 6
AND fcpp.concurrent_request_id = 2754108
通过这条SQL语句查询到对应的LOG,日志内容如下:
A PROCEDURE RUN XML file wrong,please help me
i run a request to write a XML file ,finished but a warning occur, i have check the log ,this is the error:
[7/13/07 4:59:53 PM] [UNEXPECTED] [750649:RT2754123] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: oracle.xdo.parser.v2.XMLParseException: PI with the name 'xml' can occur only in the beginning of the document.
at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:324)
at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:290)
at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:266)
... 17 more
[7/13/07 4:59:53 PM] [750649:RT2754123] Completed post-processing actions for request 2754123.
A PROCEDURE RUN XML file wrong,please help me
i run a request to write a XML file ,finished but a warning occur, i have check the log ,this is the error:
[7/13/07 4:59:53 PM] [UNEXPECTED] [750649:RT2754123] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: oracle.xdo.parser.v2.XMLParseException: PI with the name 'xml' can occur only in the beginning of the document.
at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:324)
at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:290)
at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:266)
... 17 more
[7/13/07 4:59:53 PM] [750649:RT2754123] Completed post-processing actions for request 2754123.
看到这句Caused by: oracle.xdo.parser.v2.XMLParseException: PI with the name 'xml' can occur only in the beginning of the document. 检查存储过程的时候，发现在输出XML文件的时候在之前空了一行，去掉那一行，错误排除
