NetIQ AppManager 7.0.x
NetIQ QDB Daily job
NetIQ AppManager Repository
The scheduled SQL Server Agent NetIQ Daily QDB Job fails with one of the the following job errors:
Executed as user: dbo. DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_JobObject_Job'. The conflict occurred in database 'QDB', table 'JobObject', column 'JobID'. [SQLSTATE 23000] (Error 547)
The statement has been terminated. [SQLSTATE 01000] (Error 3621).
NOTE: The step was retried the requested number of times (2) without succeeding. The step failed.
Open Microsoft SQL Query Analyzer, login as sa, press Ctrl-U, and select the Appmanager database (default QDB)
Next, cut and past the following query(s) into your query analyzer window:
To manually execute the NetIQ Daily QDB Task:
- Open SQL Server Query Analyzer.
- Select the Repository (QDB).
- Type the following SQL query:
- Execute the SQL query by using F5 or the green arrow.
If there are any errors after running this query, please send this information to Netiq Technical Support.