Oracle datapump error ORA-39077: unable to subscribe agent KUPC$A_1_083325450472000

Posted by

  

One of our datapump import was failing with below error. 

ORA-31626: job does not exist
ORA-31638: cannot attach to job SYS_IMPORT_FULL_01 for user HOSPITAL
ORA-06512: at "SYS.KUPV$FT", line 1142
ORA-06512: at "SYS.KUPV$FT", line 1744
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 498
ORA-39077: unable to subscribe agent KUPC$A_1_165917326000000 to queue "KUPC$C_1_20231113165917_0"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 294 

Once the sequence SYS.AQ$_KUPC$DATAPUMP_QUETAB_1_N exceeds 10000, the name of a rule set then exceeds 30 characters, which should not be a problem in 19c. 

The issue in this case was caused due to compatible setting to a lower version, in which the name of a rule set cannot exceed 30 characters. 

alter system set compatible=’19.0.0’ scope=spfile;

After changing the compatible parameter to “19.0.0” issue was resolved. 

Comments

Post a Comment