Overview
This article solves the problem in running reports where the report is returning with no data.
Symptoms:
- Creating report is taking too much time to execute the query
- 1-day report is taking 5+ mins and still doesn't finish fetching data
- EventsBrowser is showing "0" events for all the events
Solution
The tremendous size of the database has caused the Events Browser to hang while fetching events.
To solve the current problem:
-
- Create a new Database or change the path in File Storage to an existing DB (that has a smaller size) so that events can be stored there.
- Once your events start being stored there, point Events Browser to show events from the new database by clicking Switch Database.
- To ensure that the Database does not grow too large again:
Set up Database Rotation so that the old events from the current in-use database will be moved to another database. Refer to this manual for more details regarding the Rotation options.
- Create a new Database or change the path in File Storage to an existing DB (that has a smaller size) so that events can be stored there.
Testing
The reports should start providing data
If the issue is still present, submit a request to GFI support to investigate the case, including EventsManager Troubleshooter Logs. Please make sure to attempt running a report while the debugger is running.