Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more

  • State Not Answered
  • Replies replies
    3
  • Subscribers subscribers
    5
  • Views views
    428
  • Users 0 members are here
  • Locked Locked
Related
Options
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

SMG Monitor - empty time gadgets!

Diethmar Rimser
 

We were waiting for a more powerful statistics for SMG - now it has been published.

Well I know that there is almost no documentation and instructions to follow and that there will be videos to explain.

However I had an interesting experience. I have created some time based gadgets in my environment (there is another thread for data tables). But all my gadgets staid empty. I changed time frames, I even added another "Stats Module" engine - no success. Fortunately I have access to some other environments - one of them is upgraded too. I created some gadgets which immediately filled up with data. Rage

Why me? Why does my SMG not work in the same way? So I checked databases via phpPgAdmin.

My SMG is missing some tables for database SecureGatewayStats.

How do I get missing tables? I remember there was an issue with quarantine. In this case you had to delete quarantine database to get a working environment. So I dared to delete SecureGatewayStats. Finally I had to restart SMG!

Success! I see that my gadgets show graphs with values - I am happy again! Sweat smile

Use "Verified Answers" if your problem/issue has been solved!

  • 0  

    I have updated several environments now.

    Summary: in 3 SMG environments I had to delete SecureGatewayStats (and restart). I thought I found out why and when this issue happens. But I was wrong - I did not see a duplication reason.

    Use "Verified Answers" if your problem/issue has been solved!

  • 0   in reply to   

    Hi Diethmar - I got this from Josh "We’d need to have seen his system in a broken state to have any idea as to what happened here. Restarting the modules is required, so maybe he ran the update and just hadn’t restarted? Maybe that needs to be added to the online update notes. There are a couple of things that don’t entirely add up with that assessment though – if only smg-supervisor was restarted, then I could see it getting into that state, where the UI worked but stats data wasn’t being generated. That would be an unlikely ½ restarted system."  So if you would open a case the next time you have this come up, we would be able to get engineering involved.  - Pam

  • 0   in reply to   

    Too late, Pam Laughing

    Of course I did restart of modules, restart of postgresql and even restart of servers. However deleting SecureGatewayStats does not hurt because this database did not contain really useful information until update.

    Use "Verified Answers" if your problem/issue has been solved!

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.