Migration has been running longer than the Estimated Migration Runtime

03/26/2020 24 11606

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)