Hi,

Im trying to migrate from ZAM 7.5 IR8 (Win203std. and MS SQL 2005 Express SP1) to a newly installed ZCM 10.3.1 (Win2008 std. R2 and and MS SQL 2005 Express SP3).

But after successfully having migrated "Inventory Data", the migrations halts in migrating the Asset Management data with following error:

Code:
02-11-2010 12.34.49: Step: ProductStandards
02-11-2010 12.34.49: Error : Event Source : ProductStandards, Error Code : -2147467259, Source : DTS Data Pump, Description : Error at Destination for Row number 847. Errors encountered so far in this task: 1.
02-11-2010 12.34.49: ProductStandards, 847 Rows have been transformed or copied.
02-11-2010 12.34.49: Error : Event Source : ProductStandards, Error Code : -2147220421, Source : Microsoft Data Transformation Services (DTS) Package, Description : The task reported failure on execution.
02-11-2010 12.34.49: Completed: ProductStandards
02-11-2010 12.34.50: Error executing Migration Task: Package failed because Step 'ProductStandards' failed.
02-11-2010 12.34.50: 
Step 'ProductStandards' failed, error: -2147220421 The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80004005): The statement has been terminated.) (Microsoft OLE DB Provider for SQL Server (80004005): The INSERT statement conflicted with the FOREIGN KEY constraint "fk_LC_ProductStanda_ProductOID". The conflict occurred in database "zenworks_ASSET", table "dbo.LC_TallyProduct", column 'ZUID'.)

02-11-2010 12.34.50: Finished Migration Queue item: All Asset Management Data
I'm not really sure why step "ProductStandards" fails, but I guess the explanation lies in:
The INSERT statement conflicted with the FOREIGN KEY constraint "fk_LC_ProductStanda_ProductOID". The conflict occurred in database "zenworks_ASSET", table "dbo.LC_TallyProduct", column 'ZUID'.)


I'm able to restore both source and destination databases, but trying again dosen't exactly much - no surprise I guess ;)

Can anyone point me in direction of a solution to this?

Cheers,
Henrik Holm Nielsen
Copenhagen, Denmark