SEA 8.1.1.7 to SIA 8.2.2 upgrade issue in S_ASSET_POSTN table
Hi,
We are upgrading our Siebel application from SEA 8.1.1.7 (Call center) to SIA 8.2.2.
Our Upgrep step failed with error shown bellow
Insert into S_ASSET_POSTN (ROW_ID ,CREATED ,CREATED_BY ,LAST_UPD ,LAST_UPD_BY ,MODIFICATION_NUM ,CONFLICT_ID ,ASSET_ID ,POSITION_ID ) select ROW_ID ,CREATED ,CREATED_BY ,LAST_UPD ,LAST_UPD_BY ,MODIFICATION_NUM ,CONFLICT_ID ,ROW_ID ,'0-5220' from S_ASSET
DBCLog DBCLogError 1 0000000251520ce4:0 2013-03-26 18:52:39 SQL Warning, SQL State 23505, -803, [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 "4" constrains table "SIEBEL.S_ASSET_POSTN" from having duplicate values
We are upgrading our Siebel application from SEA 8.1.1.7 (Call center) to SIA 8.2.2.
Our Upgrep step failed with error shown bellow
Insert into S_ASSET_POSTN (ROW_ID ,CREATED ,CREATED_BY ,LAST_UPD ,LAST_UPD_BY ,MODIFICATION_NUM ,CONFLICT_ID ,ASSET_ID ,POSITION_ID ) select ROW_ID ,CREATED ,CREATED_BY ,LAST_UPD ,LAST_UPD_BY ,MODIFICATION_NUM ,CONFLICT_ID ,ROW_ID ,'0-5220' from S_ASSET
DBCLog DBCLogError 1 0000000251520ce4:0 2013-03-26 18:52:39 SQL Warning, SQL State 23505, -803, [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 "4" constrains table "SIEBEL.S_ASSET_POSTN" from having duplicate values
0