NetIQ Daily QDB Scheduled SQL Job Fails (NETIQKB7385)

  • Document ID:7707385
  • Creation Date:02-Feb-2007
  • Modified Date:17-Nov-2010
    • Micro Focus Products:
      AppManager

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ QDB Daily job
NetIQ AppManager Repository

Situation

NetIQ Daily QDB Scheduled SQL Job Fails

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.

Resolution

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:

First, see what may exist in the JobObject table that needs to be cleaned up (if this returns 0 rows, then do not proceed):
 
    SELECT * from JobObject where JobID in (SELECT JobID FROM Job WHERE Status & 0x08000000 <> 0)
 
If rows exist, try cleaning them manually
 
    DELETE JobObject where JobID in (SELECT JobID FROM Job WHERE Status & 0x08000000 <> 0)
 
Now run the Daily task query again:
 
    exec dbo.task_daily
 
If this task continues to fail, please contact NetIQ Technical support. Please have the exact error message(s) available.

To  manually execute the NetIQ Daily QDB Task:

  1. Open SQL Server Query Analyzer.
  2. Select the Repository (QDB).
  3. Type the following SQL query:
     
          EXEC dbo.Task_Daily
  4. 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.

Additional Information

Formerly known as NETIQKB7385