My Oracle Support Banner

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 SEPTEMBER 10, 2021

Applies to:

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


After generating and successfully using an Oracle Data Integrator (ODI) 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(
  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(
  at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(
  at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.executeBatch(
  at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(

Further information is seen in the database trace file.

Trace file <INSTALL_LOCATION>/oracle/diag/rdbms/[svcname]/<INSTANCE_NAME>/trace/<INSTANCE_NAME>_ora_145300.trc
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options
ORACLE_HOME = <INSTALL_LOCATION>/oracle/product/12.1.0/dbhome_1
System name: Linux
Node name: <NODE_NAME>
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_NAME>

*** 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:(<SERVICE_NAME>) 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 = <TABLE_ID>, flag = 4
kokliccx: NULL table infokokliccx : Invalid table info for table_id = 122125, flag = 4
kokliccx: NULL table infoIncident 19809 created, dump file: <INSTALL_LOCATION>/oracle/diag/rdbms/<SERVICE_NAME>/<INSTANCE_NAME>/incident/incdir_19809/<INSTANCE_NAME>_ora_145300_i19809.trc
ORA-00600: internal error code, arguments: [kglgtbo1], [0xDD5276A68], [], [], [], [], [], [], [], [], [], []



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.