AM Console - Child objects / Found objects / List of objects - moving computers with computer sets ends with error "Violation of primary key constraint PK__ftComma..."

This article is about product releases

ALVAO Asset Management 10.4 and higher

Symptoms

Error appears in these windows /tabs:

Child objects tab
Found objects window
List of objects window

If you select some computers and also their computer sets, then use command Move, then use Move computers including Computer sets option, an error will occur:
COM Error: Violation of primary key constraint 'PK__ftCommaL__xxxxx'. Cannot insert duplicate key in object 'dbo.@ret'. The duplicate key values is (yyy).

Cause

The cause is a bug in ALVAO products.

Solution

Fixed in release 11.1.1096 - ALVAO 11.1 (Q2 2023)

Workaround

If you want to move computers with computer sets, select only computers or only computer sets, not both.

Issue number

T132439ALVAO

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