Tuesday, 29 July 2025

Datapump job is failing with UDE-31623: operation generated ORACLE error 31623

 


Issue Reported: Datapump job is failing with below error

UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747
ORA-06512: at "SYS.KUPV$FT_INT", line 2144
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2081
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4496
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6127
ORA-06512: at line 1


Alert log is flooded with below error messages while the export job fails
rrors in file C:\ORACLE\APP\diag\rdbms\db19c\db19c\trace\db19c_ora_4104.trc (incident=79808):
ORA-00600: internal error code, arguments: [kwqintExeStmt: bind string failure], [1036], [ORA-01036: illegal variable name/number
], [], [], [], [], [], [], [], [], []

Solution:

Apply latest database RU and Data Pump Recommended Proactive Patches.

 ( Doc ID 2819284.1 ) Data Pump Recommended Proactive Patches For 19.10 and Above

No comments:

Post a Comment