NetIQ SQL job 'PurgeData' fails. (NETIQKB49374)

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

Environment

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

Situation

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.'

Resolution

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.

Cause

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

 


Feedback service temporarily unavailable. For content questions or problems, please contact Support.