Workflows are not being triggered

[Jakub Grufik]

rabii regarding this "
TRY TO OPTIMISE YOUR WORKFLOWS AND AVOID HAVING MANY ON THE SYSTEM." what exactly do you mean by MANY? we have 79 workflows atm in the system (approx 60 active)

[Jakub Grufik]

1) even if none of them is mentioned in error logs?
2) do I have to delete them or put them to inactive could be enough?

[rabii]

can you try to delete the scheduled workflows and recreate them at one of them and check if it will work or not.

[Jakub Grufik]

I went through all the workflows listed in this log and none of them seems to be complicated or broken, those are pretty much super simple workflows and all of them are working fine (all of them are trigger type: After record saved (created or updated)), I also optimised the one mentioned above (634febc53a633eb6e) but our scheduled workflows still do not work) Clueless about what to do now.

[rabii]

Yeah i assume some workflows are causing issues, first can you check your sequential workflow setting is correct, then you need to go through the list below from the log of all workflows (by id) to see why they are producing errors in the log.

[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow [afterRecordUpdated] for entity [Lead, 63565702e39edffc9]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow rule [6145e84336c7dfc03]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Condition result [] for workflow rule [6145e84336c7dfc03]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow rule [6145e84336c7dfc03]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow rule [616e9dbe702bef832]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Condition result [] for workflow rule [616e9dbe702bef832]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow rule [616e9dbe702bef832]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow rule [616eaab7e8ed60db5]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Condition result [] for workflow rule [616eaab7e8ed60db5]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow rule [616eaab7e8ed60db5]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow rule [616eab74d58816120]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Condition result [] for workflow rule [616eab74d58816120]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow rule [616eab74d58816120]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow [afterRecordUpdated] for Entity [Lead, 63565702e39edffc9]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow [afterRecordSaved] for entity [Lead, 63565702e39edffc9]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow rule [60d3ca7041d1c336c]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Condition result [] for workflow rule [60d3ca7041d1c336c]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow rule [60d3ca7041d1c336c]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow rule [63183f762c455fecb]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Condition result [] for workflow rule [63183f762c455fecb]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow rule [63183f762c455fecb]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow rule [63282847c01769659]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Condition result [] for workflow rule [63282847c01769659]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow rule [63282847c01769659]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow rule [634fc27cbd0b5b2e9]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Condition result [] for workflow rule [634fc27cbd0b5b2e9]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow rule [634fc27cbd0b5b2e9]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Start workflow rule [634febc53a633eb6e]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: Condition result [] for workflow rule [634febc53a633eb6e]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow rule [634febc53a633eb6e]. [] []
[2022-11-16 07:06:42] DEBUG: WorkflowManager: End workflow [afterRecordSaved] for Entity [Lead, 63565702e39edffc9]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow [afterRecordUpdated] for entity [Lead, 63565702e39edffc9]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow rule [6145e84336c7dfc03]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Condition result [] for workflow rule [6145e84336c7dfc03]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow rule [6145e84336c7dfc03]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow rule [616e9dbe702bef832]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Condition result [] for workflow rule [616e9dbe702bef832]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow rule [616e9dbe702bef832]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow rule [616eaab7e8ed60db5]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Condition result [] for workflow rule [616eaab7e8ed60db5]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow rule [616eaab7e8ed60db5]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow rule [616eab74d58816120]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Condition result [] for workflow rule [616eab74d58816120]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow rule [616eab74d58816120]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow [afterRecordUpdated] for Entity [Lead, 63565702e39edffc9]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow [afterRecordSaved] for entity [Lead, 63565702e39edffc9]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow rule [60d3ca7041d1c336c]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Condition result [] for workflow rule [60d3ca7041d1c336c]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow rule [60d3ca7041d1c336c]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow rule [63183f762c455fecb]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Condition result [] for workflow rule [63183f762c455fecb]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow rule [63183f762c455fecb]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow rule [63282847c01769659]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Condition result [] for workflow rule [63282847c01769659]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow rule [63282847c01769659]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow rule [634fc27cbd0b5b2e9]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Condition result [] for workflow rule [634fc27cbd0b5b2e9]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow rule [634fc27cbd0b5b2e9]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Start workflow rule [634febc53a633eb6e]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: Condition result [] for workflow rule [634febc53a633eb6e]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow rule [634febc53a633eb6e]. [] []
[2022-11-16 07:07:36] DEBUG: WorkflowManager: End workflow [afterRecordSaved] for Entity [Lead, 63565702e39edffc9]. [] []​

TRY TO OPTIMISE YOUR WORKFLOWS AND AVOID HAVING MANY ON THE SYSTEM.

[Jakub Grufik]

this workflow is triggered on save it is not scheduled. Could it be that wrong action in this workflow made all scheduled workflows not working? Is it even possible?

I tried to adjust the action a bit, now it is much more optimized, but I am not sure if action in "save" workflow could cause "scheduled" workflows to stop working.

[Jakub Grufik]

Ah OK I think I found the workflow with ID 634febc53a633eb6e ('6e' was missing there), I am going to check the action and hopefuly I will find the bug thanks a lot for the suggestion and for your time as well! Appreciate it

[Jakub Grufik]

I have todays error log with debug mode ON, maybe there will be more information somewhere? https://easyupload.io/68r9no

[Jakub Grufik]

Hey rabii thanks a lot for the investigation.

Could you please help me on how to find a workflow which runs action with id 634febc53a633eb? I am not sure where to check id of an action

edit: at the moment none of the scheduled workflows is working

[rabii]

Hey Jakub Grufik

I think there is an issue in your workflow runAction looks at this line in the log below:

Espo\Core\Formula\Evaluator->process('upozorneniLeadu...', Object(Espo\Modules\Crm\Entities\Lead), Object(stdClass)) #15 /data/7/5/7575340d-2d72-4955-9959-98ec6389749c/crmsys.sk/sub/esmero/application/Espo/Modules/Advanced/Core/Workflow/Actions/UpdateEntity.php(35): Espo\Core\Formula\Manager->run('upozorneniLeadu...', Object(Espo\Modules\Crm\Entities\Lead), Object(stdClass)) #16 /data/7/5/7575340d-2d72-4955-9959-98ec6389749c/crmsys.sk/sub/esmero/application/Espo/Modules/Advanced/Core/Workflow/Actions/Base.php(225): Espo\Modules\Advanced\Core\Workflow\Actions\UpdateEntity->run(Object(Espo\Modules\Crm\Entities\Lead), Object(stdClass)) #17 /data/7/5/7575340d-2d72-4955-9959-98ec6389749c/crmsys.sk/sub/esmero/application/Espo/Modules/Advanced/Core/Workflow/ActionManager.php(72): Espo\Modules\Advanced\Core\Workflow\Actions\Base->process(Object(Espo\Modules\Crm\Entities\Lead), Object(stdClass), NULL, Object(stdClass)) #18 /data/7/5/7575340d-2d72-4955-9959-98ec6389749c/crmsys.sk/sub/esmero/application/Espo/Modules/Advanced/Core/Workflow/ActionManager.php(43): Espo\Modules\Advanced\Core\Workflow\ActionManager->runAction(Object(stdClass), '634febc53a633eb...', Object(stdClass)) #19 /data/7/5/7575340d-2d72-4955-9959-98ec6389749c/crmsys.sk/sub/esmero/application/Espo/Modules/Advanced/Core/WorkflowManager.php(196): Espo\Modules\Advanced\Core\Workflow\ActionManager->runActions(Array) #20 /data/7/5/7575340d-2d72-4955-9959-98ec6389749c/crmsys.sk/sub/esmero/application/Espo/Modules/Advanced/Hooks/Common/Workflow.php(48): ... [] []

is all your workflows not working at the moment? can you check which run action with this id (634febc53a633eb) and fix it i believe one of your workflows has issue in Action section and it is not allowing the job to be processed. check out other workflows and see if something needs changing, this is definitely an issue with one of your workflow.

[Jakub Grufik]

rabii hello man, right now I turned on debug mode for logs so I can send you another logs in a few hours if you would be so kind and you will check it, please. I really need to resolve it asao because a lot of our workflows do not work at the moment and they are not working for 8 days already

[Jakub Grufik]

it is attached in the previous reply above https://easyupload.io/m/134510

[rabii]

Can you go to the CRM directory and check the data/logs this is where you will find the error logs of the CRM. see attached screenshot

[Jakub Grufik]

I found the cron.php file on our server. It does not contain the line mentioned in Administration->Scheduled Jobs

[B]* * * * * cd /data/7/5/7575340d-2d72-4955-9959-98ec6389749c/crmsys.sk/sub/esmero; /usr/php74/bin/php -f cron.php > /dev/null 2>&1[/B]​

But I was not the one who was implementing this system in our company so I have no clue if I am checking the correct file or not and if everything was set correctly at the beginning

[Jakub Grufik]

rabii here is the screen of logs for the job that seems to be triggered every 5 mins but is not running scheduled workflows as it should(probably).

Here are logs for last week(scheduled workflows stopped working on 8th Nov) https://easyupload.io/m/134510

Thanks a lot for your time!