search cancel

SQL server Error while upgrading from 20.3.3 to 20.4

book

Article ID: 254194

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

While we are upgrading from 20.3.3 to 20.4. we got the below error.

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.ocMetricNamedView' and the index name 'UNQ_VIEW_ACCOUNT_IDX1'. The duplicate key value is (Metric View 1 - p1aptcnesx003.ddnet1.net, -1, administrator, 6772, <NULL>, Private).
 at com.microso

 

Environment

Release : 20.3.3

Cause

-SQL Server 2012 is not supported on UIM 20.4

Resolution

-UIM 20.4 failed due to 2012 SQL server incompatibility. 

Client must be on one of the following MS SQL Server version: 2014, 2016, 2017, 2019