Article ID: SWH-KB-nID-000035007
INTERNAL
Problem
The Schindler Elevator Integration fails to install and displays an error containing the following:
Error 26204. Error -2147217873: failed to execute SQL string, error detail: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint “FK_SAtoSAS_SchindlerClearance_Clearance”. The conflict occurred in database “ACVSCore”, table “Access.Clearance”, column ‘ObjectID’., SQL key: DB.DBInstallation SQL string: IF NOT EXISTS (SELECT NAME FROM sys.foreign_keys WHERE NAME= ‘FK_SAtoSAS_SchindlerClearance_Clearance’)
Solution
Determine if there are Schindler Clearances that do not have a corresponding clearance in the Access.Clearance database by running the following SQL command:
SELECT * FROM dbo.SchindlerClearance where ClearanceID NOT IN (select ObjectID from Access.Clearance)
If any rows are returned by that query, create a backup of the ACVSCore database, then run the following SQL command:
DELETE FROM dbo.SchindlerClearance where ClearanceID NOT IN (select ObjectID from Access.Clearance);
The Schindler Elevator Integration should be able to install successfully now.
CCURE9000_SWH-KB-nID-000035007_It_en.pdf