Jump to content
Welcome to our new Citrix community!
  • 0

Unable to remove a "dead" PVS


dirk kotte

Question

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

Link to comment

3 answers to this question

Recommended Posts

  • 0

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

 

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...