NetIQ SQL job 'PurgeData' fails. (NETIQKB49374)

  • 7749374
  • 02-Feb-2007
  • 17-Nov-2010


NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ AppManager Repository


NetIQ SQL job 'PurgeData' fails.

Error: 'There is already an object named 'PADtemp1_PK' in the database. [SQLSTATE 42S01] (Error 2714) Could not create constraint. See previous errors. [SQLSTATE 42000] (Error 1750). The step succeeded.'

Error: 'PurgeAllData: failed to set actual del count of #tmp1',18,-1.'


Keep each repository in a dedicated SQL Server instance and stagger the start times of all PurgeData jobs with a window of 30 minutes between successive runs.


The PurgeDataAll job fails due to contention because the table gets populated and modified during runtime. When multiple repositories are in the same SQL Server instance, the failure occurs more often.

Additional Information

Formerly known as NETIQKB49374