Important note about SSL VPN compatibility for 20.0 MR1 with EoL SFOS versions and UTM9 OS. Learn more in the release notes.

Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 38 subscribers
  • Views 4119 views
  • Users 0 members are here
Options
Suggested
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

Missing Reports data

H Obe RS

The data was missing after 2019 March 20 until today

 

become

 

Here the capture from Diagnostic | Reports Graphs | Disk usage of the last two hours

The Max was 88% but

From Reports | Compliance | Events | System Events

show 90% and stop from 19th until today

From CLI

and the uptime is

There was power outage last month and can't be handle by UPS.

Here the screen shot from System Services | Log Settings

Local and iview has no data record, only Splunk that has data

The KB that guide me

https://community.sophos.com/kb/en-us/123209

https://community.sophos.com/kb/en-us/123205

From the picture above, is any one can help me to solved this issue? I need the report for monthly report

Thank You in advance



This thread was automatically locked due to age.
Parents
  • +1

    As per your cited Knowledgebase Article 123209, reporting stops when your disk utilization reaches over 80%. As per your image, report partition is at 87%. If it reaches 90%, it could cause the reportdb service to stop running. I suggest you manually purge your reports to decrease this size. Once that’s done, please check the service status of reportdb on the advanced shell using ‘service -S’

    If it is dead, please restart service (service reportdb:restart -ds nosync) and reboot your firewall.

    Karlos
    Community Support Engineer | Sophos Technical Support
    Knowledge Base  |  @SophosSupport  | Sign up for SMS Alerts
    If a post solves your question use the 'This helped me' link.
Reply
  • +1

    As per your cited Knowledgebase Article 123209, reporting stops when your disk utilization reaches over 80%. As per your image, report partition is at 87%. If it reaches 90%, it could cause the reportdb service to stop running. I suggest you manually purge your reports to decrease this size. Once that’s done, please check the service status of reportdb on the advanced shell using ‘service -S’

    If it is dead, please restart service (service reportdb:restart -ds nosync) and reboot your firewall.

    Karlos
    Community Support Engineer | Sophos Technical Support
    Knowledge Base  |  @SophosSupport  | Sign up for SMS Alerts
    If a post solves your question use the 'This helped me' link.
Children
  • 0 in reply to Karlos

    Thank you for the Answer, I did service Manual Purge for 5 month but from 88% only drop to 87% after waiting 6 hours, even tough the NMS never show hitting 90% with 5 minute check duration pooling, Max was 88% from November to this Maret,  but I don't know how the event said hit 90%, did to for service reportdb:restart -ds nosyncbut has no luck but after reboot, everything back normal (to do this reboot need waiting approval 6 hour hihihihi :)

     

    Thank you for the pointing the reboot

Unfiltered HTML