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 SEPTEMBER 14, 2024
Applies to:
Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.2 [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.2 [Release 10.1 to 12.1]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
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 "<SCHEMA_NAME>"."<TABLE_NAME>" 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
. . exported "<SCHEMA_NAME>"."<TABLE_NAME>" 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 "<SCHEMA_NAME>"."<TABLE_NAME>" 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)
. . exported "<SCHEMA_NAME>"."<TABLE_NAME>" 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 "<SCHEMA_NAME>"."<TABLE_NAME>" 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
. . exported "<SCHEMA_NAME>"."<TABLE_NAME>" 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 "<SCHEMA_NAME>"."<TABLE_NAME>" 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
. . imported "<SCHEMA_NAME>"."<TABLE_NAME>" 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.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |