Can't modify Next Scheduled Email Time in GMS due to "optimization is in progress"
03/26/2020 1038 11718
DESCRIPTION: Can't modify Next Scheduled Email Time in GMS due to "optimization is in progress"
The issue is that "Next Scheduled Email/Archive Time" can't be changed and it comes with the error that Optimization is in progress.
Step 1: Creating connection to the database.
A) Download MySQL Workbench and install it on a PC which is on the same subnet as the GMS/Analyzer. You can download it from:http://www.mysql.com/products/workbench/ (it requiresMicrosoft .NET Framework 4 and Microsoft Visual C++ 2010 Redistributable Package installed).
B) Open MySQL Workbench and set up new connection to your database - as "Hostname" use the IP address of your GMS/Analyzer.
C) Open the connection to the database.
Step 2. Changing Database records.
A) Type the command: use sgmsdb; and click on "execute".
B) Then use this command and check if it displays anything: SELECT * FROM sgms_config WHERE paramName IN ('vpngMaxOptimizationRuntime', 'vpngOptimizationTime');
C) If there is nothing there, use commands:
insert into sgms_config(paramNAme,paramValue) values ('vpngMaxOptimizationRuntime','2'); and insert into sgms_config(paramNAme,paramValue) values ('vpngOptimizationTime','1');
If results do display use the following commands:
update sgms_config set paramValue='2' where paramName='vpngMaxOptimizationRuntime'; update sgms_config set paramValue = '1' where paramName='vpngOptimizationTime';
D) The final results should be the same as the one below: