Alvao Service - an error "The column 'XXX' was specified multiple times for 'po'" is displayed in the log

This article is about product releases

ALVAO Asset Management 11.1 and higher

Symptoms

- an error "The column 'XXX' was specified multiple times for 'po'" is displayed in the log
- one of the licenses in the License registry have option "Assign automatically" turned on, and in the filter of the license is an one object property defined multiple times, for example:

[Host computer]=N'SERVER1' OR [Host computer]=N'SERVER2'

Cause

The cause is a bug in ALVAO products.

Solution

Fixed in release 11.1.1464 - 11.1/FIX4 (2023-08-03)

Workaround

Rewrite the filter condition for automatic license assignment so that the property names are not repeated, for example:
Instead of:

[Host computer]=N'SERVER1' OR [Host computer]=N'SERVER2'

Use:

[Host computer] IN (N'SERVER1', N'SERVER2')

Issue number

T145126ALVAO

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