Symptom
The upgrade from SP20 to SP21 fails with the following SQL Script error:
"IF NOT EXISTS ( SELECT * FROM A_V_DB_OBJECTS WHERE OBJECT_NAME = 'FK_A_CLIENT_INVENTORY_DATA_A_CLIENT' AND PARENT_OBJECT = 'A_CLIENT_INVENTORY_DATA' AND OBJECT_TYPE = 'FK' )
BEGIN
ALTER TABLE A_CLIENT_INVENTORY_DATA ADD CONSTRAINT FK_A_CLIENT_INVENTORY_DATA_A_CLIENT
FOREIGN KEY (ClientUID) REFERENCES A_CLIENT(ClientUID) ON DELETE CASCADE
END
GO
Msg 547, Level 16, State 0, Line 3
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_A_CLIENT_INVENTORY_DATA_A_CLIENT". The conflict occurred in database "AfariaPMRT", table "dbo.A_CLIENT", column 'ClientUID'."
Read more...
Environment
Afaria Server 7.0 SP20
Product
Keywords
upgrade; update; afaria; server; sql; script; error; fail , KBA , MOB-AFA , Afaria , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.