New events are not appearing in Change Auditor (4218727)

No new events are appearing in Change Auditor, even after deliberate actions are taken that would normally trigger an event.

The following error may be seen in the ChangeAuditor.Service.exe.nptlog file:

"Too many events in Scheduler task queue: 1003 (maximum: 1000), cannot accept more"

Workaround 1:

Confirm that the Change Auditor database hasn't reached the maximum size, or that the disk it resides on hasn't run out of space.

Workaround 2:

If any recent changes were made to enable new auditing functionality, or if a new server was added for auditing, it is possible that it is contributing far more events than were expected.  Generally this happens with Change Auditor for Windows File Servers, Change Auditor for Netapp, Change Auditor for EMC, Change Auditor for Exchange, or Change Auditor for AD Queries.

If so, disable that new auditing, and allow the Coordinator to work through the backlog.  Re-evaluate the auditing configuration, and turn off the more chatty events.  After the Coordinator has worked through the backlog, the Agent Statistics page can be useful in identifying abnormal trends in the type of events that came through.

You can determine which events have the largest number of items in the database:

1. Start the CA Client
2. Select the Overviews tab
3. In the bottom left of the window you should see Top Agent Activity (this is the default filter). Click the blue filter icon to the left of the Top Agent Activity bar
4. Select Count of Events By | Event Class

Workaround 3:

Increase the SQL Timeout values using the steps in the following KB:

https://support.quest.com/change-auditor/kb/128042/-too-many-events-in-scheduler-task-queue-128042-

If the issue persists, please monitor the SQL server as a possible bottleneck.