Software products library: Some products have incorrect vendors

This article is about product releases

ALVAO Asset Management 10.0 and higher

Symptoms

- Some SW library product have incorrect vendors.
- There are some own companies created by the user (not from the library).

Cause

The cause is a bug in ALVAO products.

Solution

Fix planned for release ALVAO 26.4 Patch (Q4 2026)

Workaround

Run the following SQL script on the Alvao database:

update p
set p.lintProducerCompanyId=cc.intCompanyId
from tblProduct p
	join tblCompany c on c.intCompanyId=p.lintProducerCompanyId and c.txtCertifiedBy is null
	join tblCompany cc on cc.intCompanyUID=c.intCompanyUID and cc.txtCertifiedBy='__ALC__'
where p.txtCertifiedBy='__ALC__'

Issue number

T206773ALVAO

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