Workflows stopped working suddenly

I have created many workflows that run independent of the scheduler and they have been working but have found that periodically some of my workflows will suddenly stop working for no apparent reason.

I’ve cleared browser cache, run a quick repair and still workflows that stopped working will not run.

I’m running SuiteCRM 7.10.7, PHP 7.2 on Windows Server 2012 R2.

Only a handful of errors but don’t seem to be related.

SuiteCRM.log

Fri Jan 4 14:23:13 2019 [727076][1][FATAL] Query Failed: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , N’Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , N’Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , N’Users’ assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 where (reminders.popup = 1 AND (reminders.date_willexecute = -1 OR reminders.date_willexecute BETWEEN AND )) AND reminders.deleted=0::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword ‘AND’.
Fri Jan 4 14:25:21 2019 [727076][1][FATAL] Query Failed: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , N’Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , N’Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , N’Users’ assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 where (reminders.popup = 1 AND (reminders.date_willexecute = -1 OR reminders.date_willexecute BETWEEN AND )) AND reminders.deleted=0::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword ‘AND’.
Fri Jan 4 14:25:27 2019 [727076][1][FATAL] Query Failed:DECLARE @topCount INT SET @topCount = 1 SELECT TOP (@topCount) aos_invoices.id AS id FROM aos_invoices LEFT JOIN aos_quotes_aos_invoices_c ON aos_invoices.id=aos_quotes_aos_invoices_c.aos_quotes6b83nvoices_idb AND aos_quotes_aos_invoices_c.deleted=0

LEFT JOIN aos_quotes aos_quotes_aos_invoices ON aos_quotes_aos_invoices.id=aos_quotes_aos_invoices_c.aos_quotes77d9_quotes_ida AND aos_quotes_aos_invoices.deleted=0
LEFT JOIN aos_quotes_cstm aos_quotes_aos_invoices_cstm ON aos_quotes.id = aos_quotes_aos_invoices_cstm.id_c WHERE aos_quotes_aos_invoices_cstm.estimate_type_c = N’re_waterproofing’ AND aos_invoices.id = N’14cb95ae-b5fe-0c28-c205-5c1aa7cecf68’::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The multi-part identifier “aos_quotes.id” could not be bound.
Fri Jan 4 14:29:29 2019 [708880][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Fri Jan 4 14:30:32 2019 [708880][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Fri Jan 4 14:30:37 2019 [708880][1][FATAL] Query Failed: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , N’Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , N’Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , N’Users’ assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

PHP.ini

[04-Jan-2019 14:25:27 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:25:27 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:25:27 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:25:27 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:25:27 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:25:27 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:25:27 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:25:27 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:31:38 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:31:38 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:31:38 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:31:38 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:31:38 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:31:38 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:31:38 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:31:46 Europe/Dublin] PHP Notice: session_start(): ps_files_cleanup_dir: opendir(C:\Windows\temp) failed: No error (0) in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\include\MVC\SugarApplication.php on line 596
[04-Jan-2019 14:34:00 Europe/Dublin] PHP Warning: Declaration of SugarFieldTime::save(&$bean, &$inputData, &$field, &$def, $prefix = ‘’) should be compatible with SugarFieldBase::save(&$bean, $params, $field, $properties, $prefix = ‘’) in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\include\SugarFields\Fields\Time\SugarFieldTime.php on line 95
[04-Jan-2019 14:34:01 Europe/Dublin] PHP Warning: Declaration of SchedulersViewDetail::_getModuleTitleListParam() should be compatible with SugarView::_getModuleTitleListParam($browserTitle = false) in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Schedulers\views\view.detail.php on line 69
[04-Jan-2019 14:34:32 Europe/Dublin] PHP Warning: Declaration of SugarFieldTime::save(&$bean, &$inputData, &$field, &$def, $prefix = ‘’) should be compatible with SugarFieldBase::save(&$bean, $params, $field, $properties, $prefix = ‘’) in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\include\SugarFields\Fields\Time\SugarFieldTime.php on line 95
[04-Jan-2019 14:39:16 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:39:16 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:39:16 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:39:16 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:39:16 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:39:16 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96
[04-Jan-2019 14:39:16 Europe/Dublin] PHP Warning: A non-numeric value encountered in C:\inetpub\Dev\dev.roofdini.biscayneroofing.com\modules\Currencies\Currency.php on line 96

And I have checked the workflows’ process audit which shows that the workflow does run but the actions within the workflow are no longer being performed.

And I have tried checking the box for repeated runs as the condition is based off the field’s “any change”.

I can see some query failure errors in the suitecrm log you copied,

Query Failed: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , N’Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , N’Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , N’Users’ assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 where (reminders.popup = 1 AND (reminders.date_willexecute = -1 OR reminders.date_willexecute BETWEEN AND )) AND reminders.deleted=0::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword ‘AND’.
Fri Jan 4 14:25:21 2019 [727076][1][FATAL] Query Failed: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , N’Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , N’Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , N’Users’ assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 where (reminders.popup = 1 AND (reminders.date_willexecute = -1 OR reminders.date_willexecute BETWEEN AND )) AND reminders.deleted=0::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword ‘AND’.

These needs to be resolve first ,workflows are impacting due to these query failure errors.

Those errors have been since day one - before any configurations. How are these related to workflows?