Daily Executive Report some entry missing after Update 9.4.04-5

Same UTM version here (3 different environments actually). All have the VPN and network usage information and as far as I recall also every other information that was also there before.

What do you see for the missing items in Reporting in WebAdmin?  Are you missing just the data or also the graphs?

Cheers - Bob

The Graphs are there, but the data is missing.

Cheers

Andy

Andy, are you saying that the graphs show and continue to be populated in Reporting, but, for example, nothing is visible on the 'Bandwidth Usage' tab?

Cheers - Bob

Bob, thats correct there an example:

That's from the Executive Report.  I'm asking about graphs in 'Protokolle & Berichte >> Netzwerknutzung' and content on the 'Bandbreitnutzung' tab.  I suspect that your PostgreSQL databases are broken, but before telling you to re-initialize them, I'd like confirmation of my suspicions.

Cheers - Bob

Hi Bob,

Sorry, yes tap "Bandbreitnutzung" is empty.

Cheers

Andy 

OK, it does sound like your PostGreSQL data bases have been hosed, so the fact that the following erases all existing data in them shouldn't be a problem. As root at the command line:

/etc/init.d/postgresql92 rebuild

This is a rare occurrence - probably one in a thousand upgrades.  Andy got the brass ring!

Cheers - Bob

Hi Bob,

sorry for the late request, rebulid run without error but unortunately the Bandwidth Usage' tab stay empty.

to solve the Problem, i have reinstall the Appliance over the Weekend, now is everything working.

thanks for your Help

Andy

You did the right thing, Andy.  The rebuild usually works, but sometimes a re-imaging is the only solution.

Cheers - Bob