"java.sql.BatchUpdateException: ORA-00600: internal error code" during MethodServer startup in Windchill PDMLink 11.1
Applies To
- Windchill PDMLink 11.1
- Oracle 11.2.0.4
Description
- Error inserting into MiscLogEvents table during MethodServer startup:
date/time ERROR [wt.log4j.jmx.AsyncJDBCAppender.worker-2] wt.log4j.jmx.AsyncJDBCAppender - Exception while flushing connection: default
java.sql.BatchUpdateException: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], [], [], [], [], []
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032)
at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234)
at wt.log4j.jmx.AsyncJDBCAppender.executeBatch(AsyncJDBCAppender.java:1426)
at wt.log4j.jmx.AsyncJDBCAppender$SharedConnection.flushAll(AsyncJDBCAppender.java:2423)
at wt.log4j.jmx.AsyncJDBCAppender.lambda$flushAllConnections$61(AsyncJDBCAppender.java:1531)
at java.util.ArrayList.forEach(ArrayList.java:1257)
at wt.log4j.jmx.AsyncJDBCAppender.flushAllConnections(AsyncJDBCAppender.java:1526)
at wt.log4j.jmx.AsyncJDBCAppender.flushAllConnectionsWithLogging(AsyncJDBCAppender.java:1509)
at wt.log4j.jmx.AsyncJDBCAppender.pollWithIdleActionAndFallback(AsyncJDBCAppender.java:2714)
at wt.log4j.jmx.AsyncJDBCAppender$SpecialArrayBlockingQueue.poll(AsyncJDBCAppender.java:2739)
at wt.log4j.jmx.AsyncJDBCAppender$SpecialArrayBlockingQueue.poll(AsyncJDBCAppender.java:2718)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1073)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
date/time ERROR [wt.log4j.jmx.AsyncJDBCAppender.worker-2] wt.log4j.jmx.AsyncJDBCAppender - Had chained exception
java.sql.SQLException: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], [], [], [], [], []
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:9804)
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9904)
at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234)
at wt.log4j.jmx.AsyncJDBCAppender.executeBatch(AsyncJDBCAppender.java:1426)
at wt.log4j.jmx.AsyncJDBCAppender$SharedConnection.flushAll(AsyncJDBCAppender.java:2423)
at wt.log4j.jmx.AsyncJDBCAppender.lambda$flushAllConnections$61(AsyncJDBCAppender.java:1531)
at java.util.ArrayList.forEach(ArrayList.java:1257)
at wt.log4j.jmx.AsyncJDBCAppender.flushAllConnections(AsyncJDBCAppender.java:1526)
at wt.log4j.jmx.AsyncJDBCAppender.flushAllConnectionsWithLogging(AsyncJDBCAppender.java:1509)
at wt.log4j.jmx.AsyncJDBCAppender.pollWithIdleActionAndFallback(AsyncJDBCAppender.java:2714)
at wt.log4j.jmx.AsyncJDBCAppender$SpecialArrayBlockingQueue.poll(AsyncJDBCAppender.java:2739)
at wt.log4j.jmx.AsyncJDBCAppender$SpecialArrayBlockingQueue.poll(AsyncJDBCAppender.java:2718)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1073)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 600, Position : 16, Sql = insert into PDS.MiscLogEvents (JVM_ID,JVM_STARTTIME,LE_ID,LE_ID_SEQNUM,LE_TIMESTAMP,LE_LOGGERNAME,LE_LEVEL,LE_THREADNAME,LE_THREADID,LE_MDC_SESSIONPRINCIPAL,LE_MDC_METHODCONTEXTID,LE_MDC_METHODCONTEXTDETAIL,LE_MESSAGE) values (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ), OriginalSql = insert into PDS.MiscLogEvents (JVM_ID,JVM_STARTTIME,LE_ID,LE_ID_SEQNUM,LE_TIMESTAMP,LE_LOGGERNAME,LE_LEVEL,LE_THREADNAME,LE_THREADID,LE_MDC_SESSIONPRINCIPAL,LE_MDC_METHODCONTEXTID,LE_MDC_METHODCONTEXTDETAIL,LE_MESSAGE) values (?,?,?,?,?,?,?,?,?,?,?,?,?), Error Msg = ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], [], [], [], [], []
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 26 more