System Copy- Import Error

[sultan516]

Hi,

We are facing issue with System Copy during the Import Phase with Package SAPDFACT and SAPAPPL0_1

We have uninstalled the application system in the target system and all Table space have been cleaned up prior executing the import phase.

Below is the error with Package SAPDFACT. It seems the column is not created.

"A1EEIMP 008 Task failed with error: (DB2) (SQL error -205)

A1EEIMP 008 Error message returned by DbSl:

A1EEIMP 008 (DB2) SQL error = -205

A1EEIMP 008 (DB2) [IBM][CLI Driver][DB2] SID_0CALDAY IS NOT A COLUMN OF TABLE SAPQM1A./BI0/E0CCMVRKF

A2EETSK 007 Finished create for object "/BI0/E0CCMVRKF~0" of type "primary index" with error in 0.02 sec #20220710001949"

Below is the error with Package SAPAPPL0_1.

"A2 ETSK 000 Starting import for object "/IWFND/I_MED_SRH" of type "table" #20220709235751

A1 EDMP 003 Export data is unsorted.

A1EEIMP 008 Task failed with error: (IMP) DbSlExeModify failed in insert for table '/IWFND/I_MED_SRH' with #26

A1EEIMP 008 (IMP) SQL error = -803

A1EEIMP 008 (IMP) AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE AN INDEX CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS.

A3 ETSK 017 Throughput: 0.08 MB in 1 chunks, 503.04 rows/sec, 0.16 MB/sec

A2EETSK 007 Finished import for object "/IWFND/I_MED_SRH" of type "table" with error in 0.49 sec #20220709235752"

Pls advise how to fix above errors.

[mamartins]

If you are doing a System Refresh with a Homegeneous Copy, you don't need to unninstall the Application Server.

Please check the System Copy manuals from SAP HELP Portal: System Copy Guides - Software Provisioning Manager 1.0 | SAP Help Portal

[S_Sriram]

Hi Syed

Are you using the latest SWPM SP22 and above?

Regards

SS