Unable to remove a "dead" PVS

[dirk kotte]

Hi all,

i try to delete a no longer existing (dead) PVS-Server.

Within console/site/servers I right-click to the "down" marked server and select DELETE.

I run into the following error: 

A database constraint caused an Add or Update to be stopped.

details: The DELETE statement conflicted with the REFERENCE constraint "FK_CeipData_Server". The conflict occurred in database "ProvisioningServices", table "dbo.CeipData", column 'serverId'.
The statement has been terminated.

 

How to delete the old server ?

 

Thanks, Dirk

[Carl Fallis]

I believe you have an entry in the PVS database in the CeipData table and it has to be clear for  the server to work properly.  You can delete the entries in this table and then try to delete the server. 

[dirk kotte]

Ok, thanks.

But I'm not familiar with SQL database content.
How to delete exactly these data? 

[Carl Fallis]

Sorry for the late response

 

Symptoms

Full Error - The DELETE statement conflicted with the REFERENCE constraint "FK_CeipData_Server". The conflict occurred in database "ProvisioningServicesLTRSR", table "dbo.CeipData", column 'serverId'. The statement has been terminated.Solution

Please follow the solution only after taking a backup of database, confirming that the error matches accurately .

Nullify the serverid Entry from Database by running below command on SQL Server:

 

UPDATE [ProvisioningServices].[dbo].[CeipData]

SET [serverid] = NULL

 

The DELETE statement conflicted with the REFERENCE constraint "FK_CeipData_Server
Problem Cause: The DELETE statement conflicted with the REFERENCE constraint

 

You should have some one that takes care of your SQL server and knows how to run these SQL commands