ActiveXperts Knowledge Base Article 7740300

Q7740300 - The Cleanup function of the Statistical Database doesn’t seem to be working properly. The procedure does not delete all old data. How can I investigate what the problem is?

The engine executes a query to delete old data. Apparently, something goes wrong with the query. To make it visible which query is being executed and what the result is, do the following:

• Stop the ActiveXperts Network Monitor Engine service
• Open the registry editor (REGEDIT.EXE)
• Assign a valid filename to
      HKEY_LOCAL_MACHINE\SOFTWARE\ActiveXperts\Network Monitor\Server\Trace\ThreadMQLogging
  For instance:
      C:\Temp\activexperts.log (make sure that C:\Temp\ does exist)
• Start de ActiveXperts Network Monitor Engine service

Now, open the 'Statistics Configuration' tool from the 'Tools->Statistics' menu, and click on the 'force immediate cleanup' link in the bottom right corner, and wait for a little while for the cleanup procedure to start.

View the log file. It has two DELETE operations: one for the ReportData and one for the GraphData. The queries look like:

DELETE FROM ReportData where TimeSecs<1759273200
DELETE FROM GraphData  where TimeSecs<1759273200

Try to perform these manually in SQL Management Studio and see if you get an error. For instance, there can be a permissions problem.
The numeric value in the query is the number of seconds elapsed after 1/1/1970. Use activexperts.com/support/network-monitor/epochtime to display the verbose string value of the numeric epoch value.

Don't forget to disable the logging again via the registry editor by assigning an empty value to the above-mentioned registry key and restarting the service

---

If you cannot find an answer to your question(s) in our Knowledge Base, or if you need additional information or assistance, please contact our Customer Support using our Contact Support Form