A killed AD collector job still shows as "Running" in the DRA heartbeat UI (NETIQKB72572)

  • 7772572
  • 02-Sep-2010
  • 23-Jul-2014

Environment

Directory & Resource Administrator 8.5.x
Directory & Resource Administrator 8.6.x
Directory & Resource Administrator 8.7.x

Situation

When the AD Collector job runs, one of the final steps performed is updating it's status in the Running_Jobs table. The job will update its status as failed or complete depending on the outcome of the job. The DRA Scheduler task will check the Running_jobs table before initiating the DRA AD Collector job. If there is already an entry in the running_jobs table for the AD Collector job, the scheduler will fail to start the AD collector; and write an event to the Windows Application Event log on the DRA Server configured to run the AD Collector job.

Resolution

When the AD Collector job fails to update the Running_Jobs table, you will need to manually up the the table. The steps below will require access to SQL Management Studio in the context of the DRA Reporting SQL Server Access account. The SQL Queries listed will need to be executed against the DRAReporting Database.
 
1.  Locate the name of the job that is remaining in the running_jobs table.
The Job Name (which matches the domain name) will be listed in the Windows Event
2.  Run the following SQL Query:
    • Delete * from Running_jobs where collector_info = '<Exact CaSe sensitive name of the AD Collector Job>'
    • If there is only 1 Managed Domain, or only 1 Active AD Collector job use Delete * from running_jobs
3.  Once the job information has been cleared from the running_jobs table, restart the NetIQ DRA Core Service on the Primary DRA Server.
 
4.  After the Core Service is restarted, reschedule the AD Collector to run again.

Cause

This issue can occur when the DRA AD Collector job is interrupted before it can update its status in SQL.

Additional Information

Formerly known as NETIQKB72572

The only data being deleted with the SQL queries is data related to the status of a specific AD Collector job. When performing any data changes to a SQL Database, its often best to ensure there is a backup of the database.

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