Migration has been running longer than the Estimated Migration Runtime

03/26/2020 25 People found this article helpful 194,956 Views

Download

Print

Share

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

Description

Cause

The migration is actually done, however the status has not been updated in SGMSDB to reflect this

Resolution

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

• Specific syslog IDs are not seen in Analytics reports
• Upgrading to Analytics 2.5.0.4
• How to upgrade firmware for a group of firewalls in NSM

Categories

• Management and Reporting > Analyzer
• Management and Reporting > GMS