UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE job_queue SET name = 'Elasticsearch Queue Scheduler', date_modified = '2022-02-21 09:00:01', scheduler_id = 'ad477972-9212-11e7-9ed4-0688351d9823', execute_time = '2022-02-21 09:00:01', status = 'running', resolution = 'queued', message = NULL, target = 'class::\\Sugarcrm\\Sugarcrm\\Elasticsearch\\Queue\\Scheduler', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONb4bbd8fee9c4b5a2fdd4c04992816d65:2790', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'a812fc96-92f4-11ec-8280-06fdd77df510') AND (deleted = 0);
UPDATE job_queue SET name = 'Auto Update Target Lists', date_modified = '2022-02-21 09:00:01', scheduler_id = 'f3b7d086-d408-11e7-80bb-02e302de0eae', execute_time = '2022-02-21 09:00:01', status = 'done', resolution = 'success', message = NULL, target = 'function::autoUpdateTargetLists', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8fee9c4b4b2fdd4c049900reuat:11081', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'a846a4ec-92f4-11ec-a4bb-066d16b428de') AND (deleted = 0);
UPDATE job_queue SET name = 'Elasticsearch Queue Scheduler', date_modified = '2022-02-21 09:00:01', scheduler_id = '01294bac-914a-11e7-af2a-0688351d9823', execute_time = '2022-02-21 09:00:01', status = 'running', resolution = 'queued', message = NULL, target = 'class::\\Sugarcrm\\Sugarcrm\\Elasticsearch\\Queue\\Scheduler', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRON1be3a6f7422c542ab1900dev0mrm:11080', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'a7797526-92f4-11ec-b984-066d16b428de') AND (deleted = 0);
REPLACE INTO key_value_cache (id, value, date_expires) VALUES ('ab6069e8aa4b1a353224809185dd34d5', 'czoxOToiU1VHQVJfQ0FDSEVfTlVMTF9aWiI7', '2022-02-21 09:05:01') ON DUPLICATE KEY UPDATE value = 'czoxOToiU1VHQVJfQ0FDSEVfTlVMTF9aWiI7', date_expires = '2022-02-21 09:05:01';
UPDATE job_queue SET name = 'Run Nightly Mass Email Campaigns', date_modified = '2022-02-21 09:00:01', scheduler_id = '3941cfaf-37c7-5fea-568b-532308d912cb', execute_time = '2022-02-21 09:00:01', status = 'done', resolution = 'success', message = NULL, target = 'function::runMassEmailCampaign', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONb4bbd8fee9c4b5a2fdd4c04992816d68:2794', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'a80a40e2-92f4-11ec-b500-06fdd77df510') AND (deleted = 0);
UPDATE job_queue SET name = 'Elasticsearch Queue Scheduler', date_modified = '2022-02-21 09:00:01', scheduler_id = 'ad477972-9212-11e7-9ed4-0688351d9823', execute_time = '2022-02-21 09:00:01', status = 'running', resolution = 'queued', message = NULL, target = 'class::\\Sugarcrm\\Sugarcrm\\Elasticsearch\\Queue\\Scheduler', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONb4bbd8fee9c4b5a2fdd4c04992816d65:2795', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'a7ffc194-92f4-11ec-bb31-06fdd77df510') AND (deleted = 0);
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 09:00:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 09:00:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:2793', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'a7a81728-92f4-11ec-aa14-06fdd77df510') AND (deleted = 0);
REPLACE INTO key_value_cache (id, value, date_expires) VALUES ('ff027a81b8e272e9763a5b9a04746cf5', 'YToyNTp7czoxMzoibGljZW5zZV91c2VycyI7aToxMDA7czoxOToibGljZW5zZV9leHBpcmVfZGF0ZSI7czoxMDoiMjAyMy0wMi0wMiI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6IjMxNzBmMDY3ZDkyMmQ1N2M3ZDYxMTg5NTMyOWZmOTE0IjtzOjE4OiJsaWNlbnNlX251bV9saWNfb2MiO2k6MDtzOjI0OiJsaWNlbnNlX251bV9wb3J0YWxfdXNlcnMiO2k6NTA7czoyMjoibGljZW5zZV92YWxpZGF0aW9uX2tleSI7czo0Mjg6IllUbzRPbnR6T2pFeE9pSnNhV05sYm5ObFgydGxlU0k3Y3pvek1qb2lNekUzTUdZd05qZGtPVEl5WkRVM1l6ZGtOakV4T0RrMU16STVabVk1TVRRaU8zTTZNVGs2SW14cFkyVnVjMlZmWlhod2FYSmxYMlJoZEdVaU8zTTZNVEE2SWpJd01qTXRNREl0TURJaU8zTTZNVE02SW14cFkyVnVjMlZmZFhObGNuTWlPMms2TVRBd08zTTZNVGc2SW14cFkyVnVjMlZmYm5WdFgyeHBZMTl2WXlJN2FUb3dPM002TWpRNklteHBZMlZ1YzJWZmJuVnRYM0J2Y25SaGJGOTFjMlZ5Y3lJN2FUbzFNRHR6T2pFNE9pSmxibVp2Y21ObFgzVnpaWEpmYkdsdGFYUWlPMms2TUR0ek9qSTFPaUpsYm1admNtTmxYM0J2Y25SaGJGOTFjMlZ5WDJ4cGJXbDBJanR6T2pFNklqRWlPM002TVRrNklteHBZMlZ1YzJWZmRtdGZaVzVrWDJSaGRHVWlPM002TVRBNklqSXdNakl0TURVdE1Ua2lPMzA9IjtzOjE5OiJsaWNlbnNlX3ZrX2VuZF9kYXRlIjtzOjEwOiIyMDIyLTA1LTE5IjtzOjMxOiJsaWNlbnNlX2xhc3RfdmFsaWRhdGlvbl9zdWNjZXNzIjtzOjE5OiIyMDIyLTAyLTE4IDE3OjQ4OjAyIjtzOjI1OiJsaWNlbnNlX3ZhbGlkYXRpb25fbm90aWNlIjtzOjA6IiI7czozMzoibGljZW5zZV9lbmZvcmNlX3BvcnRhbF91c2VyX2xpbWl0IjtpOjE7czoyNjoibGljZW5zZV9lbmZvcmNlX3VzZXJfbGltaXQiO2k6MDtzOjE3OiJsaWNlbnNlX21zZ19hZG1pbiI7czowOiIiO3M6MTU6ImxpY2Vuc2VfbXNnX2FsbCI7czowOiIiO3M6MjM6ImxpY2Vuc2VfbGFzdF92YWxpZGF0aW9uIjtzOjc6InN1Y2Nlc3MiO3M6MjM6ImxpY2Vuc2VfbGF0ZXN0X3ZlcnNpb25zIjtzOjMzMjoiWVRveE9udHBPakE3WVRveU9udHpPamM2SW5abGNuTnBiMjRpTzNNNk5qb2lNVEV1TXk0d0lqdHpPakV4T2lKa1pYTmpjbWx3ZEdsdmJpSTdjem94TnpZNklsUm9aU0JzWVhSbGMzUWdkbVZ5YzJsdmJpQnZaaUJUZFdkaGNrTlNUU0JwY3lBeE1TNHpMakFnVUd4bFlYTmxJSFpwYzJsMElEeGhJR2h5WldZOUltaDBkSEJ6T2k4dmMzUnZjbVV1YzNWbllYSmpjbTB1WTI5dEwyUnZkMjVzYjJGa0lpQjBZWEpuWlhROUlsOXVaWGNpUG5OMGIzSmxMbk4xWjJGeVkzSnRMbU52YlM5a2IzZHViRzloWkR3dllUNGdkRzhnWVdOeGRXbHlaU0IwYUdVZ2JHRjBaWE4wSUhabGNuTnBiMjR1SWp0OWZRPT0iO3M6Mjg6ImxpY2Vuc2VfbGFzdF9jb25uZWN0aW9uX2ZhaWwiO3M6MTk6IjIwMTktMDQtMjIgMDU6MjM6NTUiO3M6NzoibGljZW5zZSI7YjoxO3M6MTM6Im1haWxfc2VuZHR5cGUiO3M6NDoiU01UUCI7czoxMzoibWFpbF9zbXRwdHlwZSI7czo1OiJvdGhlciI7czoxNToibWFpbF9zbXRwc2VydmVyIjtzOjM0OiJlbWFpbC1zbXRwLnVzLXdlc3QtMi5hbWF6b25hd3MuY29tIjtzOjEzOiJtYWlsX3NtdHBwb3J0IjtpOjU4NztzOjEzOiJtYWlsX3NtdHB1c2VyIjtzOjIwOiJBS0lBSkZDR0hHN0NXNTc2SUJFQSI7czoxMzoibWFpbF9zbXRwcGFzcyI7czo0NDoiQWpkMXpXZkFmRzRxZ2E4N1JGSndoNHVVTUlOY2tQbzhaaStxUVpGcklmOEgiO3M6MTc6Im1haWxfc210cGF1dGhfcmVxIjtpOjE7czoxMjoibWFpbF9zbXRwc3NsIjtpOjI7fQ==', '2022-02-21 09:05:02') ON DUPLICATE KEY UPDATE value = 'YToyNTp7czoxMzoibGljZW5zZV91c2VycyI7aToxMDA7czoxOToibGljZW5zZV9leHBpcmVfZGF0ZSI7czoxMDoiMjAyMy0wMi0wMiI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6IjMxNzBmMDY3ZDkyMmQ1N2M3ZDYxMTg5NTMyOWZmOTE0IjtzOjE4OiJsaWNlbnNlX251bV9saWNfb2MiO2k6MDtzOjI0OiJsaWNlbnNlX251bV9wb3J0YWxfdXNlcnMiO2k6NTA7czoyMjoibGljZW5zZV92YWxpZGF0aW9uX2tleSI7czo0Mjg6IllUbzRPbnR6T2pFeE9pSnNhV05sYm5ObFgydGxlU0k3Y3pvek1qb2lNekUzTUdZd05qZGtPVEl5WkRVM1l6ZGtOakV4T0RrMU16STVabVk1TVRRaU8zTTZNVGs2SW14cFkyVnVjMlZmWlhod2FYSmxYMlJoZEdVaU8zTTZNVEE2SWpJd01qTXRNREl0TURJaU8zTTZNVE02SW14cFkyVnVjMlZmZFhObGNuTWlPMms2TVRBd08zTTZNVGc2SW14cFkyVnVjMlZmYm5WdFgyeHBZMTl2WXlJN2FUb3dPM002TWpRNklteHBZMlZ1YzJWZmJuVnRYM0J2Y25SaGJGOTFjMlZ5Y3lJN2FUbzFNRHR6T2pFNE9pSmxibVp2Y21ObFgzVnpaWEpmYkdsdGFYUWlPMms2TUR0ek9qSTFPaUpsYm1admNtTmxYM0J2Y25SaGJGOTFjMlZ5WDJ4cGJXbDBJanR6T2pFNklqRWlPM002TVRrNklteHBZMlZ1YzJWZmRtdGZaVzVrWDJSaGRHVWlPM002TVRBNklqSXdNakl0TURVdE1Ua2lPMzA9IjtzOjE5OiJsaWNlbnNlX3ZrX2VuZF9kYXRlIjtzOjEwOiIyMDIyLTA1LTE5IjtzOjMxOiJsaWNlbnNlX2xhc3RfdmFsaWRhdGlvbl9zdWNjZXNzIjtzOjE5OiIyMDIyLTAyLTE4IDE3OjQ4OjAyIjtzOjI1OiJsaWNlbnNlX3ZhbGlkYXRpb25fbm90aWNlIjtzOjA6IiI7czozMzoibGljZW5zZV9lbmZvcmNlX3BvcnRhbF91c2VyX2xpbWl0IjtpOjE7czoyNjoibGljZW5zZV9lbmZvcmNlX3VzZXJfbGltaXQiO2k6MDtzOjE3OiJsaWNlbnNlX21zZ19hZG1pbiI7czowOiIiO3M6MTU6ImxpY2Vuc2VfbXNnX2FsbCI7czowOiIiO3M6MjM6ImxpY2Vuc2VfbGFzdF92YWxpZGF0aW9uIjtzOjc6InN1Y2Nlc3MiO3M6MjM6ImxpY2Vuc2VfbGF0ZXN0X3ZlcnNpb25zIjtzOjMzMjoiWVRveE9udHBPakE3WVRveU9udHpPamM2SW5abGNuTnBiMjRpTzNNNk5qb2lNVEV1TXk0d0lqdHpPakV4T2lKa1pYTmpjbWx3ZEdsdmJpSTdjem94TnpZNklsUm9aU0JzWVhSbGMzUWdkbVZ5YzJsdmJpQnZaaUJUZFdkaGNrTlNUU0JwY3lBeE1TNHpMakFnVUd4bFlYTmxJSFpwYzJsMElEeGhJR2h5WldZOUltaDBkSEJ6T2k4dmMzUnZjbVV1YzNWbllYSmpjbTB1WTI5dEwyUnZkMjVzYjJGa0lpQjBZWEpuWlhROUlsOXVaWGNpUG5OMGIzSmxMbk4xWjJGeVkzSnRMbU52YlM5a2IzZHViRzloWkR3dllUNGdkRzhnWVdOeGRXbHlaU0IwYUdVZ2JHRjBaWE4wSUhabGNuTnBiMjR1SWp0OWZRPT0iO3M6Mjg6ImxpY2Vuc2VfbGFzdF9jb25uZWN0aW9uX2ZhaWwiO3M6MTk6IjIwMTktMDQtMjIgMDU6MjM6NTUiO3M6NzoibGljZW5zZSI7YjoxO3M6MTM6Im1haWxfc2VuZHR5cGUiO3M6NDoiU01UUCI7czoxMzoibWFpbF9zbXRwdHlwZSI7czo1OiJvdGhlciI7czoxNToibWFpbF9zbXRwc2VydmVyIjtzOjM0OiJlbWFpbC1zbXRwLnVzLXdlc3QtMi5hbWF6b25hd3MuY29tIjtzOjEzOiJtYWlsX3NtdHBwb3J0IjtpOjU4NztzOjEzOiJtYWlsX3NtdHB1c2VyIjtzOjIwOiJBS0lBSkZDR0hHN0NXNTc2SUJFQSI7czoxMzoibWFpbF9zbXRwcGFzcyI7czo0NDoiQWpkMXpXZkFmRzRxZ2E4N1JGSndoNHVVTUlOY2tQbzhaaStxUVpGcklmOEgiO3M6MTc6Im1haWxfc210cGF1dGhfcmVxIjtpOjE7czoxMjoibWFpbF9zbXRwc3NsIjtpOjI7fQ==', date_expires = '2022-02-21 09:05:02';
REPLACE INTO key_value_cache (id, value, date_expires) VALUES ('782ff53d57f40abf207a41a3f79600b9', '[encoded data, 185344 characters]', '2022-02-21 09:05:01') ON DUPLICATE KEY UPDATE value = '[encoded data, 185344 characters]', date_expires = '2022-02-21 09:05:01';
DELETE FROM key_value_cache WHERE id = '0dcefec4b12cebecfc1938552324c88e';
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
REPLACE INTO key_value_cache (id, value, date_expires) VALUES ('102287d4486ead61c220ef8ea6598b20', 'czozOiJXZWIiOw==', '2022-02-21 09:05:02') ON DUPLICATE KEY UPDATE value = 'czozOiJXZWIiOw==', date_expires = '2022-02-21 09:05:02';
REPLACE INTO key_value_cache (id, value, date_expires) VALUES ('ff027a81b8e272e9763a5b9a04746cf5', '[encoded data, 17488 characters]', '2022-02-21 09:05:02') ON DUPLICATE KEY UPDATE value = '[encoded data, 17488 characters]', date_expires = '2022-02-21 09:05:02';
