Pages

Tuesday, February 1, 2022

impdp error: ORA-39346: data loss in character set

==============
impdp Error ORA-39346: data loss in character set 
==============
ORA-06512: at "SYS.KUPW$WORKER", line 26274
ORA-06512: at "SYS.KUPW$WORKER", line 25771
ORA-39346: data loss in character set conversion for object TABLE_STATISTICS:"MSTR_REPO"."META_DSSMDOBJTRNS"
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]

Stack trace:

Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39346: data loss in character set conversion for object TABLE_STATISTICS:"MSTR_REPO"."META_DSSMDOBJTRNS"
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 12623
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 26274
ORA-06512: at "SYS.KUPW$WORKER", line 25771
----- PL/SQL Call Stack -----
object line object
handle number name
0xab33b800 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0xab33b800 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0xab33b800 26338 package body SYS.KUPW$WORKER.PUT_DDLS
0xab33b800 5281 package body SYS.KUPW$WORKER.LOAD_METADATA
0xab33b800 13791 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0xab33b800 2439 package body SYS.KUPW$WORKER.MAIN
0x6a894f18 2 anonymous block
KUPW: l_cur = 63365
KUPW: l_pos = 63396
KUPW: length of l_return=63501
KUPW: l_cur = 63397
KUPW: l_pos = 0
KUPW: l_cur*=63397
KUPW: dbms_lob.getlength(p_clob) - l_cur +1=35284
KUPW: dbms_lob.getlength(l_return)+1=63502
KUPW:
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 26274
ORA-06512: at "SYS.KUPW$WORKER", line 25771
ORA-39346: data loss in character set conversion for object TABLE_STATISTICS:"MSTR_REPO"."META_DSSMDOBJTRNS"
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-01403: no data found

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 12623
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 26274
ORA-06512: at "SYS.KUPW$WORKER", line 25771
----- PL/SQL Call Stack -----
object line object
handle number name
0xab33b800 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0xab33b800 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0xab33b800 26338 package body SYS.KUPW$WORKER.PUT_DDLS
0xab33b800 5281 package body SYS.KUPW$WORKER.LOAD_METADATA
0xab33b800 13791 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0xab33b800 2439 package body SYS.KUPW$WORKER.MAIN
0x6a894f18 2 anonymous block
KUPW: l_cur = 63365
KUPW: l_pos = 63396
KUPW: length of l_return=63501
KUPW: l_cur = 63397
KUPW: l_pos = 0
KUPW: l_cur*=63397
KUPW: dbms_lob.getlength(p_clob) - l_cur +1=35284
KUPW: dbms_lob.getlength(l_return)+1=63502
KUPW:
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 26274
ORA-06512: at "SYS.KUPW$WORKER", line 25771
Job "SYSTEM"."SYS_IMPORT_SCHEMA_03" stopped due to fatal error at Tue Feb 1 14:58:43 2022 elapsed 0 00:01:57


As a workaround:
impdp without importing stats
impdp system/passwd@igt DUMPFILE=${DUMPFILE} DIRECTORY=IG_EXP_DIR LOGFILE=${schema}_${LOGFILE} REMAP_TABLESPACE=TEMP2:TEMPORARY SCHEMAS=${schema} REMAP_SCHEMA=${schema}:${schema} TABLE_EXISTS_ACTION=TRUNCATE EXCLUDE=TABLE_STATISTICS

No comments:

Post a Comment