ORA-00600: internal error code, arguments: [kqludp2], [0x08D226918], [0], [], [], [], [], [], [], [], [], []

问题描述:

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)'

posted @ 2017-12-29 17:36  甩手掌柜文刀  阅读(577)  评论(0编辑  收藏  举报