Failed MCS template migration: OneStepMigrator : Exception Cannot insert duplicate key in object 'dbo.SSRV2ConfigValue'

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

You are trying to migrate a MCS Template to the lated version, but not all templates are migrated. 

An example, could be executing one_step_migration, the CPU monitor and setup cdm are not able to migrate to 7.22

Template packages are showing errors like: 

 Error occured while migrating. Refer logs and retry

MCS log is saying:

Feb 10 09:13:54:459 [ProbeTemplatesPackageMigrator-0, mon_config_service] ProbeTemplatesPackageDao.handleAddedForEachTemplate:893:    Exception occuring when inserting data in to ssrv2congivalue table PreparedStatementCallback; SQL [INSERT INTO SSRV2ConfigValue (field, cfgkey,value,profile,variable) VALUES (?, ?, ?, ?, ?)]; Violation of UNIQUE KEY constraint 'UC_FIELD_PROFILE'. Cannot insert duplicate key in object 'dbo.SSRV2ConfigValue'. The duplicate key value is (1856, 553545).

Feb 10 09:13:54:460 [ProbeTemplatesPackageMigrator-0, mon_config_service] ProbeTemplatesPackageController.handleAddedFields:569:    OneStepMigrator : Exception while handling removed fields PreparedStatementCallback; SQL [INSERT INTO SSRV2ConfigValue (field, cfgkey,value,profile,variable) VALUES (?, ?, ?, ?, ?)]; Violation of UNIQUE KEY constraint 'UC_FIELD_PROFILE'. Cannot insert duplicate key in object 'dbo.SSRV2ConfigValue'. The duplicate key value is (1856, 553545).

Environment

• DX UIM 23.4.7 (CU7) and earlier
• Fix available only for CU6

 

Cause

one_step_migrator may fail in some scenarios and generate these exceptions 

Resolution

• The Issue is resolved and fix will be officially included in DX UIM 23.4.8 (CU8)
  
  
  
• If running into this issue while having DX UIM 23.4.6 (CU6), so mon_config_service 23.4.6 run the following steps to resolve this issue:
  
  
  • Steps:  
    

    1. Download the patch attached to the case and deploy to the primary hub where mcs is

    mcs-23.4.6.1.zip
    File Size : 69 MB
    Created On : 25-February-2026 10:57:19
     

    
    2. run the following query:  
    
    

    update SSRV2ProbeTemplatesPackage set status='loaded' where probe_name='cdm' and probe_template_pkg_version='7.22';
    
    

    --note: this query supposed the stuck Teamplate Package is CDM Version 7.22. Adjust the query according to the failed template if any.
    
     

    3. Execute one_step_migrator for CDM

    
     - Select mon_config_service and run CTRL+P

     - Select one_step_migrator 

     - probe_name: cdm

     - template_package_verson: 7.22
    
    
    
    

• If running DX UIM 23.4.7 (CU7) or 23.4.4 (CU4) or earlier, Open a support case with Broadcom to request a specific patch.