NetIQ CC Hourly Task fails: REFERENCE constraint 'FK_AccountInGroup_GroupID' (NETIQKB71686)

  • 7771686
  • 10-Aug-2009
  • 21-Apr-2011

Environment

NetIQ AppManager Control Center 7.0.x

Situation

NetIQ CC Hourly Task failes with error that contains: DELETE statement conflicted with the REFERENCE constraint "FK_AccountInGroup_GroupID"

Resolution

If you receive error similar to the one below, please contact NetIQ Technical Support for steps to correct this issue:

08/05/2009 20:00:00,NetIQ CC Hourly Task,Error,1,SMN-QDB1,NetIQ CC Hourly Task,Task Hourly,,Executed as user: NT AUTHORITY\SYSTEM. The DELETE statement conflicted with the REFERENCE constraint "FK_AccountInGroup_GroupID". The conflict occurred in database "NQCCDB"<c/> table "dbo.AccountInGroup"<c/> column 'GroupID'. [SQLSTATE 23000] (Error 547)  The statement has been terminated. [SQLSTATE 01000] (Error 3621).  The step failed.,00:00:00,16,3621,,,,0

 

Cause

This is due to a known issue with NetIQ AppManager Control Center 7.0.x

Additional Information

Formerly known as NETIQKB71686