EXPDP And IMPDP - UDE-31626 And ORA-31626 (job Does Not Exist) At End Of Job, While No Errors In The Logfile (Doc ID 1970322.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.7.0 [Release 10.1 to 12.1]
Oracle Database - Personal Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Information in this document applies to any platform.

Symptoms

1.You have an Operating System script file or CRON job that runs an Export DataPump (expdp) periodically. Occasionally the script output file shows the following errors at the end of the file:

...
. . exported "OLAPSYS"."CWM2$HIERCUSTOMSORT"                 0 KB       0 rows

UDE-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1

or:

...
. . exported "OLAPSYS"."CWM2$HIERCUSTOMSORT"                 0 KB       0 rows

Execute Failed: ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-6512: at "SYS.DBMS_DATAPUMP", line 2772
ORA-6512: at "SYS.DBMS_DATAPUMP", line 3886
ORA-6512: at line 27 (DBD ERROR: OCIStmtExecute)

or:

...
. . exported "OLAPSYS"."CWM2$HIERCUSTOMSORT"                 0 KB       0 rows

UDE-00008: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2745
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3712
ORA-06512: at line 1

or incidently also for an Import Data Pump job (impdp):

...
. . imported "OLAPSYS"."CWM2$HIERCUSTOMSORT"                 0 KB       0 rows

UDI-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2862
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: at line 1

2. The logfile of the DataPump job however, does not show any errors.

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