NetIQ daily QDB task is failing with an error. (NETIQKB27626)

  • 7727626
  • 02-Feb-2007
  • 16-Dec-2015

Environment

NetIQ AppManager 7.0.x
NetIQ AppManager 8.0.x

Situation

NetIQ daily QDB task is failing with an error.
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.

Cause

One or more machines that have been removed from AppManager via the Operator Console still have records left over in the MCVersLang table of the AppManager Repository.

Additional Information

Formerly known as NETIQKB27626