SAP Knowledge Base Article - Preview

2437180 - Ugrade Afaria Server to SP21 failed with SQL Script Error

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

SAP Afaria 7.0

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.