- 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
- Network Security
- Solutions
- Solutions Widgets
- Solutions Image Widgets
- Solutions Widgets
- Partners
- Partner Widgets
- Partners Image Widgets
- Partner Widgets
- Support
- Support Widget
- Support Image Widgets
- Support Widget
- 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
- Network Security
- Solutions
- Solutions Widgets
- Solutions Image Widgets
- Solutions Widgets
- Partners
- Partner Widgets
- Partners Image Widgets
- Partner Widgets
- Support
- Support Widget
- Support Image Widgets
- Support Widget
Migration has been running longer than the Estimated Migration Runtime
03/26/2020 
24 People found this article helpful
42,455 Views
Description
Upgraded to GMS 8.1 v2 (database engine from MySQL to PostgresSQL). Migration has been running longer than the Estimated Migration Runtime.
Cause
The migration is actually done, however the status has not been updated in SGMSDB to reflect this
Resolution
How to check migration status?
1: Log into the appliance side (backend) of the GMS (http://IPaddress /appliance)
2: Go to System | Diagnostic
3: Go to the Log Field and select Stdappliance.log then click the Export button
4: Look inside of the log file for a log similar to the following:
[DatabaseUpdate/performPGUpdate()]: Finished report database migration successfully at 2016-06-23
If Migration has completed, please continue to Step 5.
If Migration is still in progress, please re-download this file at a later time and check again. Please call Technical Support if it has been 48 hours longer than the estimated time of Migration Completion and you do not see any migration successfully message.
5: Connect to the database.
6: Once logged into the Database run the following query:
USE sgmsdb;
SELECT * FROM sgms_config WHERE paramName like '%MR%';
7.Update the sgms_config table in SGMSDB database.
USE sgmsdb;
UPDATE sgms_config SET paramValue = 'DONE' WHERE paramName LIKE '%MRmigrationStatus';
8: Verify the change by running the following query:
SELECT * FROM sgms_config WHERE paramname like ' %MR%';
(Screenshot from HeidiSQL)
Related Articles
- Can we make changes to a firewall config acquired on NSM directly through the firewall?
- Perform Restart of firewall from NSM.
- Requirement is to push cfs settings from one firewall to a group of Firewalls in NSM.
YES
NO