R12 migration fails with the error "Cannot continue Migration Process".

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

Migration from R11.2 to R12 fails with the error "Cannot continue Migration Process".

Following errors(example) appear in migration_r12.log file: Wed Feb 11 15:35:08 2009: >> STDERR: Error in dbcallback. event:4 err:15

Wed Feb 11 15:35:08 2009: >> STDERR: Error fetching data:15
Wed Feb 11 15:35:08 2009: >> STDERR: Error in dbcallback. event:4 err:15
Wed Feb 11 15:35:08 2009: >> STDERR: Error fetching data:15
Wed Feb 11 15:35:08 2009: >> STDERR: Access_Type_v2
Wed Feb 11 15:35:08 2009: >> STDERR: rows:0
Wed Feb 11 15:35:08 2009: >> STDERR: errors:1

Solution:

This error occurs if there are any duplicate records in the database. To identify the duplicate records, run the appropriate script to clean any duplicate records on your database:

(Oracle) Run OracleCheckr12UniqueIndexes.sql, located in $NX_ROOT/samples/views/Oracle/
(SQL Server) Run SQLCheckr12UniqueIndexes.sql, located in $NX_ROOT/samples/views/SQLServer/

After identifying the duplicates, rename the value to ensure that there are no duplicate records. You can manually start the migration using the following command:

Windows:

$NX_ROOT\bin\migrate_to_r12.vbs

Linux/UNIX:

$NX_ROOT\bin\migrate_to_r12.sh

Now you should be able to complete the migration successfully.

Environment

Release:
Component: ARGIS