Skip Navigation LinksALVAO 11.2Admin guideTroubleshootingKnown issues Skip Navigation Links.


Skip Navigation LinksALVAO 11.2 / Admin guide / Troubleshooting / Known issues

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

Attachments

Issue number

T163134ALVAO

 

Did not find what you were looking for? Ask our technical support team.