hhn Absent Member.
Absent Member.
1778 views

ZAM 7.5 to ZCM 10.3.1 migration error

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:

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
Labels (2)
0 Likes
2 Replies
nathan_cook Absent Member.
Absent Member.

Re: ZAM 7.5 to ZCM 10.3.1 migration error

Update to the latest IR release (IR23 think) then try it. It could also be that the migration doesn't work from the express versions of SQL, to another Express version of SQL...

I had a similar issue but it was more to do with the versions of the DB than anything else. I ended up manually exporting and then importing all records across.
0 Likes
hhn Absent Member.
Absent Member.

Re: ZAM 7.5 to ZCM 10.3.1 migration error

Thanx for your suggestions,

However, before I got to try any of them, the customer decided to drop all data in the old ZAM 7.5 and therefore abort the migration. Instead they wish to build up everything from scratch.

But thanx for your suggestions - really appreciate them!

Cheers,
Henrik 😉

hhn;2040263 wrote:
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:

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.