Alvao Service - an error "The DELETE statement conflicted with the REFERENCE constraint "FK_tblFile_FileImageId"" is displayed in the log
This article is about product releases
ALVAO Asset Management 10.0 and higher
Symptoms
- an error "The DELETE statement conflicted with the REFERENCE constraint "FK_tblFile_FileImageId"" is displayed in the log
Cause
The cause is a bug in ALVAO products.
Solution
Fixed in release 11.1.2098 - 11.1/SP1 FIX5 (2023-10-05)
Workaround
Run the following script on the database:
update f
set f.FileImageId=null
from tSwLibAddUnknown sau
join tblFileImage fi on fi.lintProductId=sau.liProductId
join tblFile f on f.FileImageId=fi.intFileImageId
update ru
set ru.lintRegImageId=null
from tSwLibAddUnknown sau
join tblRegImage ri on ri.lintProductId=sau.liProductId
join tblRegUninstall ru on ru.lintRegImageId=ri.intRegImageId
Steps to reproduce this behavior
Attachments
Issue number
T146681ALVAO