ODI Load Fails With "java.sql.BatchUpdateException: ORA-00600: Internal Error Code, Arguments: [kglgtbo1]" When Executing a Scenario (Doc ID 2293692.1)

Last updated on AUGUST 11, 2017

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

After generating and successfully using an Oracle Data Integrator (ODI) 12.2.1.1.0 scenario in one environment, executing the same scenario imported into another environment results in an error similar to the following:

ODI-1228: Task Load [task_load_name]-LKM SQL to Oracle (Built-In)- fails on the target connection [target_connection].
Caused By: java.sql.BatchUpdateException: ORA-00600: internal error code, arguments: [kglgtbo1], [0xDD5276A68], [], [], [], [], [], [], [], [], [], []
  at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:15709)
  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:264)
  at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:197)
  at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.executeBatch(BatchSQLCommand.java:110)
  at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:68)
<...snip...>

Further information is seen in the database trace file.

Trace file /u02/app/oracle/diag/rdbms/[svcname]/[instance name]/trace/[instance name]_ora_145300.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options
ORACLE_HOME = /u02/app/oracle/product/12.1.0/dbhome_1
System name: Linux
Node name: [node]
Release: 3.10.0-327.el7.x86_64
Version: #1 SMP Thu Oct 29 17:29:29 EDT 2015
Machine: x86_64
Instance name: [instance name]
Redo thread mounted by this instance: 1
Oracle process number: 76
Unix process pid: 145300, image: [user]@[node]

*** 2017-08-01 13:47:09.882
*** SESSION ID:(305.28516) 2017-08-01 13:47:09.882
*** CLIENT ID:() 2017-08-01 13:47:09.882
*** SERVICE NAME:([svcname]) 2017-08-01 13:47:09.882
*** MODULE NAME:(ODI:1484266065090/1/268) 2017-08-01 13:47:09.882
*** CLIENT DRIVER:(jdbcthin) 2017-08-01 13:47:09.882
*** ACTION NAME:(410/10/1/70) 2017-08-01 13:47:09.882

kokliccx : Invalid table info for table_id = 122125, flag = 4
kokliccx: NULL table infokokliccx : Invalid table info for table_id = 122125, flag = 4
kokliccx: NULL table infoIncident 19809 created, dump file: /u02/app/oracle/diag/rdbms/[svcname]/[instance name]/incident/incdir_19809/[instance name]_ora_14
5300_i19809.trc
ORA-00600: internal error code, arguments: [kglgtbo1], [0xDD5276A68], [], [], [], [], [], [], [], [], [], []

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms