Migration has been running longer than the Estimated Migration Runtime
03/26/2020 24 People found this article helpful 42,455 Views
Upgraded to GMS 8.1 v2 (database engine from MySQL to PostgresSQL). Migration has been running longer than the Estimated Migration Runtime.
The migration is actually done, however the status has not been updated in SGMSDB to reflect this
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:
SELECT * FROM sgms_config WHERE paramName like '%MR%';
7.Update the sgms_config table in SGMSDB database.
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)