Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ AppManager Repository
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.'
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