Skip to Content
0
Former Member
Jun 03, 2009 at 11:41 AM

Migration Error during import(Solution Manager)

177 Views

Hello All,

I am migrating my current system from oracle/IBM to DB2/IBM .The export was successfull.

Now during the import only one package has gone into error.

Following are the details:

In the "import_state.properties" file one package is in error

***********************************************

"SAPDFACT=-"

************************************************

In the SAPDFACT.TSK file the following Table has error

***********************************************************

"D /BI0/F0SMD_CA01 I err"

***********************************************************

In the SAPDFACT.LOG follwing is the error.

***************************************************************

(DB6) LOAD API is not used for table with small buffer

(DB6) Using ARRAY INSERT for table /BI0/F0SMD_CA01

(DB6) [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement

are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "SAPSOL./BI0/F0SMD_CA01" from having duplicate val

ues for the index key. SQLSTATE=01661

(IMP) ERROR: ExeFastload: rc = 2

(DB) INFO: disconnected from DB

*******************************************************************

Please suggest....