Software products library: After library update, all the software products are gone, set as "invalid"
This article is about product releases
ALVAO Asset Management 10.0 and higher
Symptoms
- The Alvao version is lower than 26.1.
- All entities from software library are gone, invisible, set asi "invalid".
The problem was caused by "broken" software library for old Alvao versions.
Cause
The cause is a bug in ALVAO products.
Solution
Fix planned for release ALVAO 27.1 (Q1 2027)
Workaround
1. Execute folowing SQL script on your Alvao database:
update tblCompany set dteTimeStamp={d'1990-01-01'}
update tblProduct set dteTimeStamp={d'1990-01-01'}
delete tblProductPack
update tblRegImage set dteTimeStamp={d'1990-01-01'}
update tblFileImage set dteTimeStamp={d'1990-01-01'}
update tblVersion set dteSwLib=null
delete tblSwLibUpdate
Note: this script "resets" the software library timestamps.
2. Restart the Alvao service so that the download of the new library begins immediately.
Steps to reproduce this behavior
Attachments
Issue number
T202798ALVAO