Clear SQLite Agent Queue
When the Agent can't communicate with the Enterprise Manager, Agent events queue up in the Agent's local SQLite database until the Enterprise Manager is available to accept events. The Clear SQLite Agent Queue option dumps the queue, and all pending events are lost.
These events are permanently deleted and aren't processed by the Enterprise Manager on reconnection. This option is 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 flashing blue link to bring back the focus to the wizard.
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. Ensure any error messages are taken care of 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. Ensure any error messages are taken care of before the next attempt.
- Completed – Indicates that the task is completed
Step 6 – When the task is successfully completed, click Finish to close the window.
The SQLite Agent queue is automatically cleared.