HDTN-329952 - Error on DB upgrade from 22.1 to 23.1

Issue No: ST-3290
Created 2/6/2024 11:00:58 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 23.1
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-330647 - Restore DB: T1 - Woodford24T1 in IC2|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-330647]   *This issue relates to i21 Help Desk ticket:* [ HDTN-329952 - Create a new environment after copying 01, 02, 03 and update to 24.1.0205.133|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-329952]   Trying to Upgrade database from *22.1.0116.3023* to *23.1.0204.570*   Environment: *[https://woodfordoil.i21web.com/WoodfordTE24]*   *DB: T1 - Woodford24T1*   Target build: *24.1.0205.133*   !pastedImage_2_6_2024__23_57_28_260.png|height=285,width=1222!     * Error SQL72014: .Net SqlClient Data Provider: Msg 1505, Level 16, State 1, Line 1 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.tblICItemUOM' and the index name 'UQ_tblICItemUOM_strSCC14'. The duplicate key value is ().