https://community.sap.com/t5/devops-and-system-administration-forum/system-copy-import-error/m-p/12604368#M2058 <P>Hi,</P> <P>We are facing issue with System Copy during the Import Phase with Package SAPDFACT and SAPAPPL0_1</P> <P>We have uninstalled the application system in the target system and all Table space have been cleaned up prior executing the import phase.</P> <P>Below is the error with Package SAPDFACT. It seems the column is not created. </P> <P><STRONG>"A1EEIMP 008 Task failed with error: (DB2) (SQL error -205)</STRONG></P> <P><STRONG>A1EEIMP 008 Error message returned by DbSl:</STRONG></P> <P><STRONG>A1EEIMP 008 (DB2) SQL error = -205</STRONG></P> <P><STRONG>A1EEIMP 008 (DB2) [IBM][CLI Driver][DB2] SID_0CALDAY IS NOT A COLUMN OF TABLE SAPQM1A./BI0/E0CCMVRKF</STRONG></P> <P><STRONG>A2EETSK 007 Finished create for object "/BI0/E0CCMVRKF~0" of type "primary index" with error in 0.02 sec #20220710001949"</STRONG></P> <P>Below is the error with Package SAPAPPL0_1. </P> <P><STRONG>"A2 ETSK 000 Starting import for object "/IWFND/I_MED_SRH" of type "table" #20220709235751</STRONG></P> <P><STRONG>A1 EDMP 003 Export data is unsorted.</STRONG></P> <P><STRONG>A1EEIMP 008 Task failed with error: (IMP) DbSlExeModify failed in insert for table '/IWFND/I_MED_SRH' with #26</STRONG></P> <P><STRONG>A1EEIMP 008 (IMP) SQL error = -803</STRONG></P> <P><STRONG>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.</STRONG></P> <P><STRONG>A3 ETSK 017 Throughput: 0.08 MB in 1 chunks, 503.04 rows/sec, 0.16 MB/sec</STRONG></P> <P><STRONG>A2EETSK 007 Finished import for object "/IWFND/I_MED_SRH" of type "table" with error in 0.49 sec #20220709235752"</STRONG></P> <P>Pls advise how to fix above errors.</P> Sat, 09 Jul 2022 23:16:56 GMT sultan516 2022-07-09T23:16:56Z https://community.sap.com/t5/devops-and-system-administration-forum/system-copy-import-error/m-p/12604368#M2058 <P>Hi,</P> <P>We are facing issue with System Copy during the Import Phase with Package SAPDFACT and SAPAPPL0_1</P> <P>We have uninstalled the application system in the target system and all Table space have been cleaned up prior executing the import phase.</P> <P>Below is the error with Package SAPDFACT. It seems the column is not created. </P> <P><STRONG>"A1EEIMP 008 Task failed with error: (DB2) (SQL error -205)</STRONG></P> <P><STRONG>A1EEIMP 008 Error message returned by DbSl:</STRONG></P> <P><STRONG>A1EEIMP 008 (DB2) SQL error = -205</STRONG></P> <P><STRONG>A1EEIMP 008 (DB2) [IBM][CLI Driver][DB2] SID_0CALDAY IS NOT A COLUMN OF TABLE SAPQM1A./BI0/E0CCMVRKF</STRONG></P> <P><STRONG>A2EETSK 007 Finished create for object "/BI0/E0CCMVRKF~0" of type "primary index" with error in 0.02 sec #20220710001949"</STRONG></P> <P>Below is the error with Package SAPAPPL0_1. </P> <P><STRONG>"A2 ETSK 000 Starting import for object "/IWFND/I_MED_SRH" of type "table" #20220709235751</STRONG></P> <P><STRONG>A1 EDMP 003 Export data is unsorted.</STRONG></P> <P><STRONG>A1EEIMP 008 Task failed with error: (IMP) DbSlExeModify failed in insert for table '/IWFND/I_MED_SRH' with #26</STRONG></P> <P><STRONG>A1EEIMP 008 (IMP) SQL error = -803</STRONG></P> <P><STRONG>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.</STRONG></P> <P><STRONG>A3 ETSK 017 Throughput: 0.08 MB in 1 chunks, 503.04 rows/sec, 0.16 MB/sec</STRONG></P> <P><STRONG>A2EETSK 007 Finished import for object "/IWFND/I_MED_SRH" of type "table" with error in 0.49 sec #20220709235752"</STRONG></P> <P>Pls advise how to fix above errors.</P> Sat, 09 Jul 2022 23:16:56 GMT https://community.sap.com/t5/devops-and-system-administration-forum/system-copy-import-error/m-p/12604368#M2058 sultan516 2022-07-09T23:16:56Z https://community.sap.com/t5/devops-and-system-administration-forum/system-copy-import-error/m-p/12604369#M2059 <P>If you are doing a System Refresh with a Homegeneous Copy, you don't need to unninstall the Application Server.<BR /><BR />Please check the System Copy manuals from SAP HELP Portal: <A href="https://help.sap.com/docs/SOFTWARE_PROVISIONING_MANAGER/30839dda13b2485889466316ce5b39e9/14678bf6e9a04f4f9dc3a1620e96c0b7.html?locale=en-US">System Copy Guides - Software Provisioning Manager 1.0 | SAP Help Portal</A></P> Wed, 10 Aug 2022 09:04:26 GMT https://community.sap.com/t5/devops-and-system-administration-forum/system-copy-import-error/m-p/12604369#M2059 mamartins 2022-08-10T09:04:26Z https://community.sap.com/t5/devops-and-system-administration-forum/system-copy-import-error/m-p/12604370#M2060 <P>Hi Syed</P><P>Are you using the latest SWPM SP22 and above?</P><P>Regards</P><P>SS</P> Wed, 10 Aug 2022 09:11:17 GMT https://community.sap.com/t5/devops-and-system-administration-forum/system-copy-import-error/m-p/12604370#M2060 S_Sriram 2022-08-10T09:11:17Z