Overview

GFI EventsManager database (DB) operations job has been running for hours and never finishes.

This article provides the steps on how to resolve this issue when a DB operations job hangs and never completes.

Environment

• GFI EventsManager
• All Supported Environments
  
  

Root Cause

The application will hang when it tries to perform a Database Operation on logs that do not exist or are empty.

Resolution

Edit the current DB operations job and uncheck maintenance of logs that are not in use.  Follow the steps below:

1. Open the GFI EventsManager console.
2. Go to Configuration > Options > Database Operations.
3. Right-click on the first Database Operations Job and go to Properties.
4. Click on the Data tab.
5. Uncheck all of the logs that you are not using (W3C, Syslog, SNMP (Simple Network Management Protocol), SQL, Oracle, etc.). If you are only collecting Windows events, only Windows events should be checked.
6. Click Apply and OK.