6 Replies Latest reply on Aug 14, 2019 2:07 AM by EdStevens

    12c Data Pump Import Fails With ORA-39126: Worker Unexpected Fatal Error In KUPW$WORKER

    4035219

      Has anyone come across this error during an import. I found a bug with exports but not sure if its related to imports as well.

       

      https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=226287901367280&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&…

       

      Here is the error I got in specifics:

       

      . . imported
      "SYSADM"."PTGRANTTBL"                         
      0 KB       0 rows

      . . imported
      "SYSADM"."SQL_PROF_STGTAB"                    
      0 KB       0 rows

      ORA-39126: Worker unexpected fatal error in
      KUPW$WORKER.CHANGE_ARCHIVE_LOGGING
      [TABLE_DATA:"SYSADM"."PS_UC_R289_RPT_STG"]

      ORA-00942: table or view does not exist

       

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

      ORA-06512: at "SYS.KUPW$WORKER", line 11252

       

      ----- PL/SQL Call Stack -----

        object      line
      object

        handle    number  name

      0x2d40df628     27109  package body
      SYS.KUPW$WORKER

      0x2d40df628     11279  package body
      SYS.KUPW$WORKER

      0x2d40df628      7338  package
      body SYS.KUPW$WORKER

      0x2d40df628      5377  package
      body SYS.KUPW$WORKER

      0x2d40df628     12169  package body
      SYS.KUPW$WORKER

      0x2d40df628      2081  package
      body SYS.KUPW$WORKER

      0x2e5778e90       
      2  anonymous block

       

      In SET_DDL_TRANSFORM with index 3 and object type TABLE

      DBMS_METADATA.SET_TRANSFORM_PARAM

      DBMS_METADATA.SET_TRANSFORM_PARAM

      ORA-39126: Worker unexpected fatal error in
      KUPW$WORKER.CHANGE_ARCHIVE_LOGGING
      [TABLE_DATA:"SYSADM"."PS_XX_ACA_AET"]

      ORA-00942: table or view does not exist

       

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

      ORA-06512: at "SYS.KUPW$WORKER", line 11252

       

      ----- PL/SQL Call Stack -----

        object      line
      object

        handle    number  name

      0x2d40df628     27109  package body
      SYS.KUPW$WORKER

      0x2d40df628     11279  package body
      SYS.KUPW$WORKER

      0x2d40df628      7338  package
      body SYS.KUPW$WORKER

      0x2d40df628      5377  package
      body SYS.KUPW$WORKER

      0x2d40df628     12169  package body
      SYS.KUPW$WORKER

      0x2d40df628      2081  package
      body SYS.KUPW$WORKER

      0x2e5778e90       
      2  anonymous block

       

      In SET_DDL_TRANSFORM with index 3 and object type TABLE

      DBMS_METADATA.SET_TRANSFORM_PARAM

      DBMS_METADATA.SET_TRANSFORM_PARAM

      Job "SYS"."SYS_IMPORT_SCHEMA_02" stopped
      due to fatal error at Mon Aug 5 12:53:31 2019 elapsed 0 02:18:23

       

      ==

      syntax used :

       

      nohup impdp \"/ as sysdba\"  schemas=xxxx parallel=8 directory=export
      dumpfile=
      xxx.dmp
      logfile=xxx.log table_exists_action=skip transform=disable_archive_logging:y
      exclude=statistics &