Environment
Situation
Error: "DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_MCVersLang_Object'." The conflict occurred in the QDB database, MCVersLang table, MCMachineObjID column.
Resolution
Using SQL Query Analyzer, run the following query to search for any objects in MCVersLang table that do not have matching records in the Object table:
Select MCMachineObjID from MCVersLang where MCMachineObjID IN (select ObjID from Object where status&0x08000000 <> 0)
If any records are returned, delete them with the following statement:
DELETE MCVersLang where MCMachineObjID IN (select ObjID from Object where status&0x08000000 <> 0)
CAUTION: This SQL Query directly accesses your database and updates/deletes data. If the query is performed incorrectly it can cause irreparable harm to the database and may result in loss of data. If you are unfamiliar with SQL or how to run a SQL Query please contact NetIQ Technical Support directly.