问题描述:
1)report builder + xml publisher 做的报表,报表提交后报黄色警告,输出文件是XML格式,日志提示如下:
+--------- 1) POST-PROCESSING ---------+
无法找到“输出提交处理程序”服务以提交处理请求 494830.
请检查“输出提交处理程序”服务是否正在运行。
+---------------------------------------+
2) 查看“输出提交处理程序”管理器日志
路径:系统管理员/并发/经理/管理
日志信息如下:
-----------------------------------------------------------------log begin
[10/25/17 10:40:43 AM] [main] Starting GSF service with concurrent process id = 11890.
[10/25/17 10:40:43 AM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[10/25/17 10:40:43 AM] [Thread-18] Service thread starting up.
[10/25/17 10:40:43 AM] [Thread-19] Service thread starting up.
[10/25/17 10:40:43 AM] [EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-00600: internal error code, arguments: [kqludp2], [0x08D226918], [0], [], [], [], [], [], [], [], [], []
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.initAQ(OPPAQMonitor.java:568)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.init(OPPAQMonitor.java:544)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.initialize(OPPAQMonitor.java:92)
at oracle.apps.fnd.cp.opp.OPPServiceThread.init(OPPServiceThread.java:95)
at oracle.apps.fnd.cp.gsf.BaseServiceThread.run(BaseServiceThread.java:135)
[10/25/17 10:40:43 AM] [UNEXPECTED] [OPPAQMON:11890] java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:3416)
at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:3377)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:422)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:117)
at java.lang.Thread.run(Thread.java:619)
……
-----------------------------------------------------------------log end
解决方法:
1) Shut down all services
2) Run $FND_TOP/patch/115/sql/afopp001.sql as SYSTEM
3) Run $FND_TOP/patch/115/sql/afopp002.sql as APPLSYS. Commit.
4) Restart managers and test again.
参考:OPP Manager Error 'ORA-600 [kqludp2]' Unable To Publish XML Reports (文档 ID 1083510.1)'