Main Menu
  • COMPANY
    • Boundless Cybersecurity
    • Press Releases
    • News
    • Awards
    • Leadership
    • Press Kit
    • Careers
  • PROMOTIONS
    • SonicWall Promotions
    • Customer Loyalty Program
  • MANAGED SERVICES
    • Managed Security Services
    • Security as a Service
    • Professional Services
SonicWall
  • Products
    • Network Security
      • Next Generation FirewallNext-generation firewall for SMB, Enterprise, and Government
      • Security ServicesComprehensive security for your network security solution
      • Network Security ManagerModern Security Management for today’s security landscape
    • Advanced Threat Protection
      • Capture ATPMulti-engine advanced threat detection
      • Capture Security applianceAdvanced Threat Protection for modern threat landscape
    • Access Security
      • Cloud Edge Secure AccessDeploy Zero-Trust Security in minutes
      • Secure Mobile AccessRemote, best-in-class, secure access
      • Wireless Access PointsEasy to manage, fast and secure Wi-FI
      • SwitchesHigh-speed network switching for business connectivity
    • Email Security
      • Email SecurityProtect against today’s advanced email threats
    • Cloud Security
      • Cloud App SecurityVisibility and security for Cloud Apps
      • Cloud Firewall (NSv)Next-generation firewall capabilities in the cloud
    • Endpoint Security
      • Capture ClientStop advanced threats and rollback the damage caused by malware
      • Content Filtering ClientControl access to unwanted and unsecure web content
    • Product Widgets
      • Product Menu Right Image
      • Capture Cloud Platform
        Capture Cloud Platform

        A security ecosystem to harness the power of the cloud

    • Button Widgets
      • Products A-Z
        all products A–Z FREE TRIALS
  • Solutions
    • Industries
      • Distributed Enterprises
      • Retail & Hospitality
      • K-12 Education
      • Higher Education
      • State & Local
      • Federal
      • Healthcare
      • Financial Services
      • Carriers
    • Use Cases
      • Secure SD-Branch
      • Zero Trust Security
      • Secure SD-WAN
      • Office 365 Security
      • SaaS Security
      • Secure WiFi
    • Solutions Widgets
      • Solutions Content Widgets
        Federal

        Protect Federal Agencies and Networks with scalable, purpose-built cybersecurity solutions

      • Solutions Image Widgets
  • Partners
    • SonicWall Partners
      • Partners Overview
      • Find a Partner
      • Authorized Distributors
      • Technology Partners
    • Partner Resources
      • Become a Partner
      • SonicWall University
      • Training & Certification
    • Partner Widgets
      • Custom HTML : Partners Content WIdgets
        Partner Portal

        Access to deal registration, MDF, sales and marketing tools, training and more

      • Partners Image Widgets
  • Support
    • Support
      • Support Portal
      • Knowledge Base
      • Technical Documentation
      • Community
      • Video Tutorials
      • Product Life Cycle Tables
      • Partner Enabled Services
      • Contact Support
    • Resources
      • Resource Center
      • Free Trials
      • Blog
      • SonicWall University
      • MySonicWall
    • Capture Labs
      • Capture Labs
      • Security Center
      • Security News
      • PSIRT
      • Application Catalog
    • Support Widget
      • Custom HTML : Support Content WIdgets
        Support Portal

        Find answers to your questions by searching across our knowledge base, community, technical documentation and video tutorials

      • Support Image Widgets
  • COMPANY
    • Boundless Cybersecurity
    • Press Releases
    • News
    • Awards
    • Leadership
    • Press Kit
    • Careers
  • PROMOTIONS
    • SonicWall Promotions
    • Customer Loyalty Program
  • MANAGED SERVICES
    • Managed Security Services
    • Security as a Service
    • Professional Services
  • Contact Sales
  • English English English en
  • BLOG
  • CONTACT SALES
  • FREE TRIALS
  • English English English en
SonicWall
  • Products
    • Network Security
      • Next Generation FirewallNext-generation firewall for SMB, Enterprise, and Government
      • Security ServicesComprehensive security for your network security solution
      • Network Security ManagerModern Security Management for today’s security landscape
    • Advanced Threat Protection
      • Capture ATPMulti-engine advanced threat detection
      • Capture Security applianceAdvanced Threat Protection for modern threat landscape
    • Access Security
      • Cloud Edge Secure AccessDeploy Zero-Trust Security in minutes
      • Secure Mobile AccessRemote, best-in-class, secure access
      • Wireless Access PointsEasy to manage, fast and secure Wi-FI
      • SwitchesHigh-speed network switching for business connectivity
    • Email Security
      • Email SecurityProtect against today’s advanced email threats
    • Cloud Security
      • Cloud App SecurityVisibility and security for Cloud Apps
      • Cloud Firewall (NSv)Next-generation firewall capabilities in the cloud
    • Endpoint Security
      • Capture ClientStop advanced threats and rollback the damage caused by malware
      • Content Filtering ClientControl access to unwanted and unsecure web content
    • Product Widgets
      • Product Menu Right Image
      • Capture Cloud Platform
        Capture Cloud Platform

        A security ecosystem to harness the power of the cloud

    • Button Widgets
      • Products A-Z
        all products A–Z FREE TRIALS
  • Solutions
    • Industries
      • Distributed Enterprises
      • Retail & Hospitality
      • K-12 Education
      • Higher Education
      • State & Local
      • Federal
      • Healthcare
      • Financial Services
      • Carriers
    • Use Cases
      • Secure SD-Branch
      • Zero Trust Security
      • Secure SD-WAN
      • Office 365 Security
      • SaaS Security
      • Secure WiFi
    • Solutions Widgets
      • Solutions Content Widgets
        Federal

        Protect Federal Agencies and Networks with scalable, purpose-built cybersecurity solutions

      • Solutions Image Widgets
  • Partners
    • SonicWall Partners
      • Partners Overview
      • Find a Partner
      • Authorized Distributors
      • Technology Partners
    • Partner Resources
      • Become a Partner
      • SonicWall University
      • Training & Certification
    • Partner Widgets
      • Custom HTML : Partners Content WIdgets
        Partner Portal

        Access to deal registration, MDF, sales and marketing tools, training and more

      • Partners Image Widgets
  • Support
    • Support
      • Support Portal
      • Knowledge Base
      • Technical Documentation
      • Community
      • Video Tutorials
      • Product Life Cycle Tables
      • Partner Enabled Services
      • Contact Support
    • Resources
      • Resource Center
      • Free Trials
      • Blog
      • SonicWall University
      • MySonicWall
    • Capture Labs
      • Capture Labs
      • Security Center
      • Security News
      • PSIRT
      • Application Catalog
    • Support Widget
      • Custom HTML : Support Content WIdgets
        Support Portal

        Find answers to your questions by searching across our knowledge base, community, technical documentation and video tutorials

      • Support Image Widgets
  • COMPANY
    • Boundless Cybersecurity
    • Press Releases
    • News
    • Awards
    • Leadership
    • Press Kit
    • Careers
  • PROMOTIONS
    • SonicWall Promotions
    • Customer Loyalty Program
  • MANAGED SERVICES
    • Managed Security Services
    • Security as a Service
    • Professional Services
  • Contact Sales
  • Menu

GMS 8.1 FAQ on Reporting Database

03/26/2020 1,078 People found this article helpful 99,014 Views

    Download
    Print
    Share
    • LinkedIn
    • Twitter
    • Facebook
    • Email
    • Copy URL The link has been copied to clipboard

    Description

    This article is to assist in the decision-making, preparation, and execution of upgrading from GMS 8.0 to 8.1. 

    GMS 8.1 has the choice using the existing Reporting Database Rv1, or the option of migrating to a new Reporting Database, Rv2. The performance of Rv1 and Rv2 are comparable; however, future performance enhancements will be made on Rv2 rather than Rv1.  Rv1 will continue to be supported for approximately two years and customers should migrate to Rv2 within the supported timeframe. 

    Resolution

    What is Reporting Database Version 2?

    With Infobright version 4.8, the reporting database vendor has replaced the storage engine MySQL with Postgres. This is integrated into GMS 8.1 and all new customer or deployments as of Dec 23, 2015 will have access to only GMS 8.1 release. 

    How does this look in MySonicWall Download Center?

    Virtual Appliance

    Image

    • SW 8.1 GMS/Analyzer Rv2 VA 950GB – The Rv2 in the name of the link indicates it is Reporting Database Version 2. This binary is used for new installations of GMS 8.1
    • SW 8.1 GMS/Analyzer Rv2 VA Upgrade – The keyword Upgrade in the name of the link indicates upgrade. This binary is used for upgrading existing deployments of GMS 8.0 to GMS 8.1 Reporting Database Version 2
    • SW 8.1 GMS/Analyzer VA Upgrade – Since there is NO mention of reporting database version, this binary is the original reporting database introduced with GMS 7.0. This binary is used for upgrading existing deployments of GMS 8.0 and continue with Reporting Database Version 1

    Windows

    Image

    • The naming convention is the same for Windows binaries as well – Rv2 for Reporting Database Version 2
    • The same binary is used for Upgrade and Fresh installation as well

    Note: The Windows version of Original Reporting database allows for fresh installation of GMS/Analyzer. However, we do track the registrations on the backend for any violations of new installations of GMS/Analyzer running Reporting Database Version after Jan 1, 2016 in the backend and contact the customer for License violations.

     

    Migration

    1. For Both windows & Virtual appliance, before you upgrade the system to GMS 8.1 PG, visit http://<ip>:<port>/appliance/techSupport.html and update the section. Default is Yes.cid:image001.jpg@01D4074A.DBDEC0D0
    2. If you don’t select the report tables from the drop down, it will migrate all the report tables
    3. For fresh install, migration option section will be disabled
    4. If the user select No for migration

    What will happen to existing deployments as of GMS 8.0 and below?

    Existing GMS 8.0 will have 2 options available to them.

    Option 1: Upgrade to GMS 8.1 and continue with Reporting Database Version 1

    Option 2: Upgrade to GMS 8.1 Reporting Database Version 2

    Which file should I use to upgrade my GMS 8.0?

    You should first make a decision on whether to continue with Reporting Database Version 1 or upgrade to Reporting Database Version 2 introduced with GMS 8.1 release.

    • Option 1: Continue with Reporting Database Version 1

    For Virtual Appliance:     SW 8.1 GMS/Analyzer VA Upgrade

    For Windows:            SW 8.1 GMS/Analyzer Windows

    • Option 2: Upgrade to Reporting Database Version 2 (Rv2)

    For Virtual Appliance:     SW 8.1 GMS/Analyzer Rv2 VA Upgrade

    For Windows system:     SW 8.1 GMS/Analyzer Rv2 Windows

    How do I know which version of the Reporting Database the customer is running?

    Multiple locations:

    • UMH->Deployment->Services

    Reporting Database II for – Rv2

    Image

    Reporting Database

    Image

    • Application->Console->Help->About

    Reporting Database Version 2

    Report Database Version:  PostgreSQL 9.2.2 (IB_33928), shared on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-44), 64-bit

     

    Reporting Database – NO Reference at all

                                           Image

     

    Will the reporting data collected under previous versions migrated to Reporting Data Version 2?

    Yes. By DEFAULT, the data is migrated automatically after upgrade. However, the user has options to control the amount of data to be migrated and disk space requirement. This is clearly explained in the following 4 locations:

    • 8.1 Software Download: Alert is displayed outlining the Dependencies, Data Migration Dependencies for Upgrades from 8.0
    • 8.1 Release Notes
    • 8.0 SP1 Release Notes has instruction on the 8.1 upgrade in “Pre 8.1 Upgrade Preparation”
    • 8.0 Hotfix #167675 Release Notes has instruction on the 8.1 upgrade in “Pre 8.1 Upgrade Preparation”

    Are there any dependencies for GMS 8.1 upgrades?

    Yes.

    • 8.0 SP1
    • 8.0 Super Hot Fix 167675

    What happens if any of the dependencies are missed?

    There is NO loss to any data. However, the dependencies have some fixes that will help the Pre-Upgrade planning a bit easier.

    • With 8.0 SP1 + Hot Fix 167675 the /appliance/techSupport.html will have the following information:

    Pending – Screen shot of the image

    • With 8.0 SP1 the /appliance/techSupport.html will have the following information:

    Pending – Screen shot of the image

    • With 8.0 SP1 the /appliance/techSupport.html will have the following information:

    Pending – Screen shot of the image

    What is the Upgrade path to 8.1 Rv2?

    Preferred order of upgrade

    • 8.0 -> 8.0.1 -> 8.0 Super Hot fix 167675-> 8.1 Rv2
    • 8.0 -> 8.0.1 -> 8.1 Rv2
    • 8.0 -> 8.1 Rv2

    How do I know the status of the Reporting Data Migration from 8.0 to 8.1 Rv2?

    After the upgrade is done, login to the GMS > Firewall > Reports panel and if you see screen as below then data migration is still running. To get more details check the advance steps listed below.

    Image

    The message in the above screen does not necessarily imply that you have an issue with the ‘Reports Database’ service as the message could be due to data migration. Also the ‘Reports Database’ service on the agent will not be running until the migration process is completed.

    Note: Please check the migration logs first before restarting the service/s.

    Advanced Steps: Check the following logs for the status on the data migration and lookout for below log entries.

    IB-EMI-008e9     N     2016-03-07.13:37:36     GMSDev-IEE-PGSQL     0.0     sfm:12940     uf:0     et:0.00     nrq:0     cpu:0.0     execlog:"Creating table public.raw_201602"

    IB-EMI-008dc     N     2015-03-07.13:37:46     GMSDev-IEE-PGSQL   0.0     sfm:12940     uf:0     et:0.00     nrq:0     cpu:0.0     execlog:"Success!"

    Windows:

    Virtual Appliance:

    /var/lib/Infobright_pg/ib_data/ibmigator.log

    Windows:

    GMSVPinfobright_pgib_dataibmigrator.log

    In case of distributed deployment, you may be able to see such screen as below which points out that migration / upgrade is not yet completed on one of the GMS system. In that case, please check and verify the logs on the agent/s.

    Image

     

    What will happen if there is not enough space to run the data migration?

    Migration will stop if the system does not have enough disk space. StdAppliance log file will show the error message (existing code)

    Image

    Can I continue with Reporting Database Version 1?

    Yes.

    Existing customers who have GMS deployments UP and Running as of Dec 31, 2015 can choose to continue with Reporting Database Version 1. They also can add new agents to the existing deployments and also re-install the deployment. The key timeline is the Date of Registration of GMS 8.0 and below.

    Related Articles

    • How to backup and Restore an NSM On-Prem System?
    • How to upgrade SonicCore and NSM in closed network
    • On-Premises Analytics 2.5 - Reset Password

    Categories

    • Management and Reporting > GMS

    Not Finding Your Answers?

    ASK THE COMMUNITY

    Was This Article Helpful?

    YESNO

    Article Helpful Form

    Article Not Helpful Form

    Company
    • Careers
    • News
    • Leadership
    • Awards
    • Press Kit
    • Contact Us
    Popular resources
    • Communities
    • Blog
    • SonicWall Capture Labs

    Stay In Touch

    • By submitting this form, you agree to our Terms of Use and acknowledge our Privacy Statement. You can unsubscribe at any time from the Preference Center.
    • This field is for validation purposes and should be left unchanged.
    • Facebook
    • Twitter
    • Linkedin
    • Youtube
    • Instagram

    © 2022 SonicWall. All Rights Reserved.

    • Legal
    • Privacy
    • English
    Scroll to top
    Trace:cc0750a261fdf1eb77a7d3e0cb0c4ff9-90