Home

Results 1 to 3 of 3

Thread: ZAM 7.5 to ZCM 10.3.1 migration error

  1. #1

    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:

    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

  2. #2
    Join Date
    Mar 2008
    Location
    Wellington, New Zealand
    Posts
    129

    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.

  3. #3

    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 ;)

    Quote Originally Posted by hhn View Post
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •