Can't modify Next Scheduled Email Time in GMS due to "optimization is in progress"

Can't modify Next Scheduled Email Time in GMS due to "optimization is in progress"

 

Issue:

The issue is that "Next Scheduled Email/Archive Time" can't be changed and it comes with the error that Optimization is in progress.



Procedure:

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 requires Microsoft .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:

SELECT * FROM sgms_config WHERE paramName IN ('vpngMaxOptimizationRuntime', 'vpngOptimizationTime');
+----------------------------+------------+---------------------+----------------+
| paramName | paramValue | last_updated | last_updatedby |
+----------------------------+------------+---------------------+----------------+
| vpngMaxOptimizationRuntime | 3 | 2013-06-06 13:42:41 | NULL |
| vpngOptimizationTime | 1 | 2013-06-06 13:43:19 | NULL |
+----------------------------+------------+---------------------+----------------+

Step 3. Now the "Next Scheduled Email Time" should be editable.