Clear SQLite Agent Queue
When the Agent is unable to communicate with the Enterprise Manager, Agent events queue up in the Agents local SQLite database until the Enterprise Manager is available to accept events. The Clear SQLite Agent Queue option dumps the queue and deletes all pending events.
To clear the SQLite Agent queue for an Agent:
This option permanently deletes these events, and the Enterprise Manager doesn't process them on reconnection. Use this option for diagnostic and troubleshooting purposes only.
Step 1 – Click Agents in the left pane to launch the Agents interface.
Step 2 – Right-click a server/Agent and select Clear SQLite Agent Queue on the menu.
Step 3 – On the Enter Credentials window, enter a username and password with sufficient rights to connect to the target machine and query information about shares. A local Administrator account on the target machine should have access to the system shares. Click OK after entering the credentials.
The wizard doesn't block access to the Administration Console and can be minimized while actions are in progress. If this wizard is hidden by clicking outside of the dialog box, a flashing blue link displays on the upper right corner of the interface with the action name displayed. Click the action link to bring the wizard back into focus.
Step 4 – On the Access Verification window, the system performs a prerequisites or verification check that can fail or succeed.
- Failed – Read the failure messages and close the window. Fix any error messages before the next attempt.
- Success – Click Next to begin clearing the SQLite Agent Queue
Closing the Administration Console while this action is in process causes problems with data collection.
Step 5 – The Clear Agent Queue window displays the task in progress and then its status as either:
- Failed – Read the failure messages and close the window. Fix any error messages before the next attempt.
- Completed – Indicates that the task completes
Step 6 – When you successfully complete the task, click Finish to close the window.
The system automatically clears the SQLite Agent queue.