Skip Navigation LinksALVAO 11.0Known Issues Skip Navigation Links.


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

 

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