Upgrade to DX UIM 23.4.0 failed at 7% during step: sqlserver_discovery_server_create.sql

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

You are upgrading DX UIM to 23.4.0 and encounter a failure when the installer reaches 7% during the step where it is running the script "sqlserver_discovery_server_create.sql".

"An error occurred during installation. Click the View Log button for more information. Afterward, click the Cancel button to cancel the installation."

The installation log shows the following error:

2025-08-09 13:39:11,440 ERROR impl.UIMServerDBSchemaController:run:180 [Thread-64]  - NimException caught
(503) , com.microsoft.sqlserver.jdbc.SQLServerException: The index 'idx_CMNIMBUSPROBE_probename' is dependent on column 'pkg_version'.: The index 'idx_CMNIMBUSPROBE_probename' is dependent on column 'pkg_version'.
 

 

Environment

DX UIM 20.4.x -> upgrading to 23.4.0

Cause

incorrect indexes on tables left over from prior version(s) of DX UIM

Resolution

1. 1. Log in to the SQL Server (e.g. using Microsoft SQL Management Studio) and execute the following queries:
      DROP TABLE CM_NIMBUS_PACKAGE;
      DROP TABLE CM_NIMBUS_PROBE;
   2. Run the installer again

 

Additional Information

These two tables and their contents will be rebuilt by the discovery_server probe after the installation is complete, so there is no data loss incurred when dropping these tables.