Can't modify Next Scheduled Email Time in GMS due to "optimization is in progress"
03/26/2020
1,038 People found this article helpful
209,942 Views
Description
Can't modify Next Scheduled Email Time in GMS due to "optimization is in progress"
Resolution
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.
Related Articles
Categories
Was This Article Helpful?
YES
NO