Impdp ORA-39126 ORA-01403: no data found When performing a import that has characterset conversion

Last updated on MAY 28, 2018

Applies to:

Symptoms

On : 12.1.0.2 or 12.2.0.1 version,

When  running a Data Pump Import it stopped with the following errors


ERRORS
-----------------------
In procedure DETERMINE_FATAL_ERROR with ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 5202
ORA-06512: at "SYS.KUPW$WORKER", line 5045
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [OBJECT_GRANT:"EPAY_4_3"]
SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, orig_base_object_schema, base_object_name, orig_base_object_name, base_process_order, parent_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_path_seqno, object_type, object_type_path, object_int_oid, metadata_io,option_tag, objnum, xml_process_order FROM "SYS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 12098
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 5202
ORA-06512: at "SYS.KUPW$WORKER", line 5045
----- PL/SQL Call Stack -----
 object line object
 handle number name
0x6294f5b0 32239 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x6294f5b0 12119 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x6294f5b0 5315 package body SYS.KUPW$WORKER.LOAD_METADATA
0x6294f5b0 13108 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x6294f5b0 2311 package body SYS.KUPW$WORKER.MAIN
0x6ade23c8 2 anonymous block
This offset is: 1658234
next offset is: 1662060
Next bad offset is: 2388617
Look at next object, offset too large
l_object_row is: 15
Exiting search_data_loss with 2 errors
Data loss found in 2 objects
KUPF$FILE.CLOSE_CONTEXT
KUPF$FILE.CLOSE_CONTEXT
In procedure DETERMINE_FATAL_ERROR with ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 5202
ORA-06512: at "SYS.KUPW$WORKER", line 5045
Job "SYS"."SYS_IMPORT_FULL_01" stopped due to fatal error at Sat May 5 07:32:56 2018 elapsed 0 06:04:40

Cause