Environment
Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3 Migration
Novell ZENworks 11 Configuration Management Support Pack 1 - 11 SP1 Migration
Novell ZENworks 11 Configuration Management Support Pack 1 - 11 SP1 Migration
Situation
When attempting to migrate from ZAM 7.5 to ZCM the migration errors out and cannot continue.
ERROR:
9/20/2011 10:24:24 AM: Starting Migration Queue item: ADM-123-XP
9/20/2011 10:24:24 AM: Processing migration tasks: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
9/20/2011 10:26:30 AM: Step: InitializeInventoryAdfTable
9/20/2011 10:26:30 AM: Completed: InitializeInventoryAdfTable
9/20/2011 10:26:30 AM: Step: ProcessUserUdfs
9/20/2011 10:26:30 AM: Completed: ProcessUserUdfs
9/20/2011 10:26:30 AM: Step: ProcessWorkstationUdfs
9/20/2011 10:26:30 AM: Completed: ProcessWorkstationUdfs
9/20/2011 10:26:30 AM: Step: ProcessComponentUdfs
9/20/2011 10:26:30 AM: Completed: ProcessComponentUdfs
9/20/2011 10:26:30 AM: Step: ProcessProductUdfs
9/20/2011 10:26:30 AM: Completed: ProcessProductUdfs
9/20/2011 10:26:30 AM: Step: ClearTargetInventoryAdfValues
9/20/2011 10:26:30 AM: Completed: ClearTargetInventoryAdfValues
9/20/2011 10:26:30 AM: Step: ClearTargetInventoryAdfRows
9/20/2011 10:26:30 AM: Completed: ClearTargetInventoryAdfRows
9/20/2011 10:26:30 AM: Step: MigrateInventoryAdfs
9/20/2011 10:26:30 AM: MigrateInventoryAdfs, 80 Rows have been transformed or copied.
9/20/2011 10:26:30 AM: Completed: MigrateInventoryAdfs
9/20/2011 10:26:30 AM: Step: MigrateChoiceListItem
9/20/2011 10:26:30 AM: Error : Event Source : MigrateChoiceListItem, Error Code : -2147467259, Source : DTS Data Pump, Description : Error at Destination for Row number 13. Errors encountered so far in this task: 1.
9/20/2011 10:26:30 AM: MigrateChoiceListItem, 13 Rows have been transformed or copied.
9/20/2011 10:26:30 AM: Error : Event Source : MigrateChoiceListItem, Error Code : -2147220421, Source : Microsoft Data Transformation Services (DTS) Package, Description : The task reported failure on execution.
9/20/2011 10:26:30 AM: Completed: MigrateChoiceListItem
9/20/2011 10:26:31 AM: Error executing Migration Task: Package failed because Step 'MigrateChoiceListItem' failed.
9/20/2011 10:26:35 AM:
Step 'MigrateChoiceListItem' 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_CHOICELISTITEM_ADFOID". The conflict occurred in database "zenworks_GUC", table "dbo.NC_ADF", column 'ADFOID'.)
9/20/2011 10:26:35 AM: Finished Migration Queue item: ADM-123-XP
ERROR:
9/20/2011 10:24:24 AM: Starting Migration Queue item: ADM-123-XP
9/20/2011 10:24:24 AM: Processing migration tasks: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
9/20/2011 10:26:30 AM: Step: InitializeInventoryAdfTable
9/20/2011 10:26:30 AM: Completed: InitializeInventoryAdfTable
9/20/2011 10:26:30 AM: Step: ProcessUserUdfs
9/20/2011 10:26:30 AM: Completed: ProcessUserUdfs
9/20/2011 10:26:30 AM: Step: ProcessWorkstationUdfs
9/20/2011 10:26:30 AM: Completed: ProcessWorkstationUdfs
9/20/2011 10:26:30 AM: Step: ProcessComponentUdfs
9/20/2011 10:26:30 AM: Completed: ProcessComponentUdfs
9/20/2011 10:26:30 AM: Step: ProcessProductUdfs
9/20/2011 10:26:30 AM: Completed: ProcessProductUdfs
9/20/2011 10:26:30 AM: Step: ClearTargetInventoryAdfValues
9/20/2011 10:26:30 AM: Completed: ClearTargetInventoryAdfValues
9/20/2011 10:26:30 AM: Step: ClearTargetInventoryAdfRows
9/20/2011 10:26:30 AM: Completed: ClearTargetInventoryAdfRows
9/20/2011 10:26:30 AM: Step: MigrateInventoryAdfs
9/20/2011 10:26:30 AM: MigrateInventoryAdfs, 80 Rows have been transformed or copied.
9/20/2011 10:26:30 AM: Completed: MigrateInventoryAdfs
9/20/2011 10:26:30 AM: Step: MigrateChoiceListItem
9/20/2011 10:26:30 AM: Error : Event Source : MigrateChoiceListItem, Error Code : -2147467259, Source : DTS Data Pump, Description : Error at Destination for Row number 13. Errors encountered so far in this task: 1.
9/20/2011 10:26:30 AM: MigrateChoiceListItem, 13 Rows have been transformed or copied.
9/20/2011 10:26:30 AM: Error : Event Source : MigrateChoiceListItem, Error Code : -2147220421, Source : Microsoft Data Transformation Services (DTS) Package, Description : The task reported failure on execution.
9/20/2011 10:26:30 AM: Completed: MigrateChoiceListItem
9/20/2011 10:26:31 AM: Error executing Migration Task: Package failed because Step 'MigrateChoiceListItem' failed.
9/20/2011 10:26:35 AM:
Step 'MigrateChoiceListItem' 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_CHOICELISTITEM_ADFOID". The conflict occurred in database "zenworks_GUC", table "dbo.NC_ADF", column 'ADFOID'.)
9/20/2011 10:26:35 AM: Finished Migration Queue item: ADM-123-XP
Resolution
For ZCM 10.3: This is fixed in version 10.3.4 - see KB 7008244 "ZENworks Configuration Management 10.3.4 - update information and list of fixes" which can be found at https://www.novell.com/support
For ZCM 11: This is fixed in version 11.2 - see KB 7010044 "ZENworks Configuration Management 11.2 - update information and list of fixes" which can be found at https://www.novell.com/support
For ZCM 11: This is fixed in version 11.2 - see KB 7010044 "ZENworks Configuration Management 11.2 - update information and list of fixes" which can be found at https://www.novell.com/support