Only 1 hour of data available

[elang]

I am working for a client who is running the free version of Scrutinizer 8.5. If they try to look at data older than an hour, they get a \"There is no data available\" error message. Below, it indicates there is > 24 hours of 1 min data, but no 5 min or 30 min data at all. I understand that data is dropped at midnight with the free version, but they should be able to look at this info, right?

[BenjaminM]

Can you send me an email and we can fix this?

benm@plixer.com

[jbattenhouse]

I am also having this problem. The 24 hour reporting was working and now is not. Is there something I can check on the server?

[pauld]

Hi jbattenhouse,

What version of Scrutinizer are you running?

Only being able to view 1 hours worth of data is a result of rollups being queued and not executed.

What you'll need to do is upgrade to Scrutinizer v8.6.1 to resolve this. Once you've upgraded, the queued rollups will begin to execute and it usually takes less than a day for everything to catch back up so you can view all your reports.

Thanks,
Paul

[jbattenhouse]

From what I understand, the version that I am on is the last free version that allows me to connect an unlimited amount of devices to the free version. If I upgrade, I am only allowed to connect a very limited amount of devices and I have quite a few devices configured on this.

[mtsreid2]

I'm running version 8.6.1 and I have the same problem.

Here is an output from the rollups;

mysql> select roll_state, count(*) from plixer.rollcall group by roll_state;
+------------+----------+
| roll_state | count(*) |
+------------+----------+
| available | 239005 |
| running | 2 |
| finished | 61757 |
+------------+----------+
3 rows in set (0.16 sec)

mysql> select roll_state, count(*) from plixer.rollcall group by roll_state;
+------------+----------+
| roll_state | count(*) |
+------------+----------+
| available | 238996 |
| running | 1 |
| finished | 61769 |
+------------+----------+
3 rows in set (0.16 sec)


Why is it only running 2 at a time. It looks like I'm miles behind and it never catches up and finishes the roll ups

please help ASAP

[dalet0]

Hello mtsreid2,

In the web interface, when you go to Admin->reports->Vitals, what are the following values?

Flows/s:
Exporters:
Active Interfaces:

If you own the product and you are interested in having our tech support engineers look into this, please give us a call at 207 324 8805 ext 4.

D

[pauld]

After talking with mtsreid2, this was determined to be a hardware bottleneck where too much NetFlow was being sent to the server and it couldn't keep up. After stopping NetFlow on a few high volume devices from being sent to Scrutinizer everything was able to catch back up.

Please make sure your Scrutinizer server meets our recommended hardware requirements: http://www.plixer.com/products/netflow- ... ements.php

Let me know if you have any questions.

Thanks,
Paul

[chaldz]

I am having this same issue now after my 30 day trial expired. I removed the licenses so that I'm in FREE mode, but all 24hr views show the following:

1m 2012-02-13 02:01 2012-02-14 10:00
5m No Data for Interval
30m No Data for Interval
2h No Data for Interval
12h 2012-01-21 06:00 2012-02-19 18:00
1d 2012-01-21 18:00 2012-03-20 19:00
1w 2011-06-01 19:00 2012-07-18 19:00

mysql> select roll_state, count(*) from plixer.rollcall group by roll_state;
+------------+----------+
| roll_state | count(*) |
+------------+----------+
| available | 13845 |
+------------+----------+
1 row in set (0.00 sec)

I am running version 8.5.0 due to device limitations in newer builds.

-Charles S

[scottr]

Hello,

Can you go to Windows services, and stop plixer_flow_collector and plixer_watcher. The restart plixer_watcher and then plixer_flow_collector.

Scott

[chaldz]

I restarted all services prior to my post and have now done just those two requested in the order you specified. Both times when stopping plixer_flow-collector, the service would just show "stopping" but never stopped. Both times I ended the process scrut_collector.exe in task manager.

After the services were started:

mysql> select roll_state, count(*) from plixer.rollcall group by roll_state;
+------------+----------+
| roll_state | count(*) |
+------------+----------+
| unknown | 400 |
| available | 4864 |
| running | 626 |
| finished | 10506 |
+------------+----------+
4 rows in set (0.03 sec)

5min later:

mysql> select roll_state, count(*) from plixer.rollcall group by roll_state;
+------------+----------+
| roll_state | count(*) |
+------------+----------+
| unknown | 720 |
| available | 213 |
| finished | 16913 |
+------------+----------+
3 rows in set (0.01 sec)

I checked a 24 hour report and its working fine now.

[dalet0]

Awesome!

Will you be upgrading to 9.0.0 anytime soon?

[chaldz]

Scrutinizer gives great insight into what is running on the network, however with our tight security in place we rarely use it so it's been hard to justify moving from the free version to the paid (we have 19 exporters). I imagine one of two things will happen, either we will upgrade our equipment and will need the new version of Scrutinizer to take advantage of new exported info or we will have a network issue where usage for Scrutinizer that will show it's value and need to our company.