Datapump Export (EXPDP) fails with ORA-00600 [kotTrns:transient] ORA-39014 ORA-39029 ORA-31671 ORA-29913 Errors (Doc ID 2093472.1)

Last updated on JANUARY 15, 2016

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

1. The Datapump Export fails with the following errors:

. . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-00600: internal error code, arguments: [kotTrns:transient], [], [], [], [], [], [], [], [], [], [], []

2. The alert log and the trace file reports with the following errors and there may be a failing SQL in the incident trace file:

ORA-00600: internal error code, arguments: [kotTrns:transient], [], [], [], [], [], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=7pgw6s8c8bhj8) -----
CREATE TABLE "ET$000706EA0001"
  ( "OWNER",
"PROGRAM_NAME",
"ARGUMENT_NAME",
"ARGUMENT_POSITION",
"ARGUMENT_TYPE",
"METADATA_ATTRIBUTE",
"DEFAULT_VALUE",
"OUT_ARGUMENT",
"DEFAULT_ANYDATA_VALUE"
  ) ORGANIZATION EXTERNAL
  ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "EXPORT_DIR" ACCESS PARAMETERS ( DEBUG = (0 , 0) DATAPUMP INTERNAL TABLE "SYSTEM"."SCHEDULER_PROGRAM_ARGS" JOB ( "VAPPASA","SYS_EXPORT_FULL_01",46) WORKERID 1 PARALLEL 1 VERSION '12.1.0.2.0' ENCRYPTPASSWORDISNULL COMPRESSION DISABLED ENCRYPTION DISABLED ) LOCATION ('bogus.dat') ) PARALLEL 1 REJECT LIMIT UNLIMITED
  AS SELECT /*+ PARALLEL(KU$,1) */ "OWNER", "PROGRAM_NAME", "ARGUMENT_NAME", "ARGUMENT_POSITION", "ARGUMENT_TYPE", "METADATA_ATTRIBUTE", "DEFAULT_VALUE", "OUT_ARGUMENT", SYS_ET_IMAGE_TO_BLOB(SYS_OP_ITR("DEFAULT_ANYDATA_VALUE",1))
  FROM "SYSTEM"."SCHEDULER_PROGRAM_ARGS" KU$
----- PL/SQL Call Stack -----
 object line object
 handle number name
0x65cae210 2015 package body SYS.KUPD$DATA
0x65cae210 3141 package body SYS.KUPD$DATA
0x65cae210 3684 package body SYS.KUPD$DATA
0x68b60a38 19307 package body SYS.KUPW$WORKER
0x68b60a38 3651 package body SYS.KUPW$WORKER
0x68b60a38 12049 package body SYS.KUPW$WORKER
0x68b60a38 2081 package body SYS.KUPW$WORKER
0x695b8048 2 anonymous block

3. The failing functions and the call stack is similar to:

.... ksfdmp dbgexPhaseII dbgexProcessError dbgeExecuteForError dbgePostErrorKGE dbkePostKGE_kgsf kgeadse kgerinv_internal kgerinv kgesinv kgesin kotTrns kadadTr kolo_dispatch kokecbeitr rpiswu2 kokeOpqTransform2 kokeeitr evaopn2 .....

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