stichl.at tech at work

25Feb/150

vCenter refuses to delete empty cluster object

Today I wanted to remove an old cluster object in a vCenter server, but got this error followed by a vSphere Client disconnect.

A general system error occurred: Error(VdbODBCError) (-1) "ODBC error: (23000) - [Microsoft]
[SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK_VPX_COMP_DAS_VM_REF_VPX_COM". The conflict occurred in database "vCenter", table "dbo.VPX_COMPUTE_RESOURCE_DAS_VM", column 'COMP_RES_ID'." is returned when executing SQL statement "DELETE FROM VPX_ENTITY WITH (ROWLOCK) WHERE ID =?"

 

To resolve this issue you need to access the vCenter database using SQL.

First find out the ID of the entity which you are trying to delete:

SELECT ID FROM VPX_ENTITY WHERE NAME="2delete"

After that you may delete the references in the table mentioned in the error message:

DELETE FROM dbo.VPX_COMPUTE_RESOURCE_DAS_VM WHERE COMP_RES_ID = 123

After that you can delete the cluster object in the vSphere Client normally 🙂

Filed under: Linux, Tech, Windows Leave comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.