Alvao database: Upgrade - Error SQL72014: Violation of UNIQUE KEY constraint 'UN_tLocalization_sTable_sAttribute_iRecordId_iLocaleId'. Cannot insert duplicate key in object 'dbo.tLocalization'.
This article is about product releases
ALVAO Asset Management, ALVAO Service Desk 11.2 and higher
Symptoms
ALVAO database cannot be upgraded. Upgrade ends up with the error like: "Error SQL72014: Framework Microsoft SqlClient Data Provider: Msg 2627, Level 14, State 1, Line 42 Violation of UNIQUE KEY constraint 'UN_tLocalization_sTable_sAttribute_iRecordId_iLocaleId'. Cannot insert duplicate key in object 'dbo.tLocalization'. The duplicate key value is (tblClass, ClassName, 5062, 1029)."
Cause
The cause is a bug in ALVAO products.
Solution
Fixed in release 11.2.3067 - 11.2/SP1 (2024-09-19)
Workaround
Run the SQL script from the Attachments section before upgrading ALVAO database. Read the instructions at the beginning of the script.
And also rename all custom object types whose names match any object type from the following section.
Steps to reproduce this behavior
There has to be at least one object type named like one of the following types and has at least one translation to another language.
Types:
- Azure App Service
- Azure SQL Database
- Azure SQL Server
- Azure Storage Account
- Azure subscription
- Cabinet
- Certificate
- Cell phone
- Computer/Azure VM
- Computer/laptop
- Computer/virtual machine
- Desk
- Chair
- Landline phone
- Network device
- Resource group
- Staging room
- Storage room
- Workstation
Issue number
T163134ALVAO