DRA AD collector is already running

  • Document ID:7771712
  • Creation Date:18-Aug-2009
  • Modified Date:05-Apr-2013
    • Micro Focus Products:
      Directory and Resource Administrator

Environment

NetIQ Directory and Resource Administrator 8.5.x
NetIQ Directory and Resource Administrator 8.6.x
Microsoft SQL Server 2005
Microsoft SQL Server 2008
Microsoft SQL Server 2008 R2

Situation

When the DRA Reporting Services data collector job attempts to start, it will check the table called Running_Jobs (Within the SQL database named DRAReporting). If there is already an entry in the table for the current job type, the collector will not start again. This table will normally be cleared out once the collector is able to successfully complete, or fully terminate. If it is not clear, and the job attempts to start again, the DRA Core Service will write an event to the Windows Application Event Log. The event ID will be 7018.

 

Resolution

Following are the steps to follow when following error event will occur.
  1. Logon to SQL Management Studio as an account with full SQL Sysadmin Rights
  2. Connect to the Database Engine for the SQL Instance hosting the DRA Reporting Database
  3. Run the following query:
    1. Use DRAReporting
    2. Select * from Running_Jobs
  4. The output of the above query will contain a value in the column “Collector_Info”. This value will match the domain name of a DRA Managed Domain. You will need to copy this value into the Windows Clipboard. After the value is copied, run the following single line query:
  5. Exec DRA_MoveToJobHistory <Job_ID>,"<Collector_Info>",0,0,3,null
  6. The value for <Job_ID> will be:
    1. 1 = AD Collector
    2. 2 = DRA Collector
    3. 4 = AD Resource Collector
  7. The value for <Collector_Info> will come from the previous SQL Query
  8.  Once the row(s) related to the failing collector are cleared from the Running_Jobs Table, re-Schedule the Collector to run again at a time in the future.

Cause

This is caused by an interruption in the DRA service due to a number of circumstances.

Additional Information

Clearing the running jobs table should only be done if the DRA Core Service generates the event ID 7018, specifically detailing the job that is still running. When the collector jobs are functioning correctly, the running jobs table will be cleared as a part of the job running process.

Formerly known as NETIQKB71712