This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Exec Report, Resource Usage empty

UTM 9.109-1 all of my resource graphs in the daily Executive Report are empty for almost 24 hours. The system has not been down, the report says it has been up for 23 days.

Adding to the mystery, when I look at any graph in Logging & Reporting they are all empty (Weekly & Monthly) seeming to start at 00:05 last night. At that point they all seem to pick up where they left off (IE. Storage is at 55%) But if I look at Network Usage - Bandwidth Usage I can get reporting for today, yesterday, last 7 days, etc.

The graphs look just like they would if I had done a fresh install or the system had been down for a long time.

This thread was automatically locked due to age.

Parents

0 BAlfson over 11 years ago
OK, there are two different things you can try at the command line.

First, try recreating the indexes of the Reporting databases:
psql -Ureporting -c"reindex database reporting;" reporting

If that gives no joy, try recreating the graphs (this is my best guess as to what will fix your problem, but be sure you're in the /var/log/reporting/rrd directory before you delete everything with the rm command):
cd /var/log/reporting/rrd
rm *
cd /etc/init.d
./syslogng restart
./rrdcache restart
cd /usr/local/bin/reporter
./system-reporter.pl

Any luck with either of those? If not, then my guess is that some glitch zapped the databases. You might want to go ahead and re-initialize the reporting database (deletes all data):
/etc/init.d/postgresql92 rebuild

Cheers - ob
Sophos UTM Community Moderator
Sophos Certified Architect - UTM
Sophos Certified Engineer - XG
Gold Solution Partner since 2005

MediaSoft, Inc. USA
Cancel
Vote Up 0 Vote Down

Cancel
0 Michael_A over 11 years ago in reply to BAlfson

Thanks, I will try this.

Just as an added note, exactly 7 days after I experienced this on my system, the same thing occurred to two of my production systems and I have contacted support about those.

Having this happen on Saturday midnight on all 3 systems is a bit beyond just odd.
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 Michael_A over 11 years ago in reply to BAlfson

Thanks, I will try this.

Just as an added note, exactly 7 days after I experienced this on my system, the same thing occurred to two of my production systems and I have contacted support about those.

Having this happen on Saturday midnight on all 3 systems is a bit beyond just odd.
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data

Exec Report, Resource Usage empty

Submitted a Tech Support Case lately from the Support Portal?