Workflows are not being triggered

**rabii** · 11-16-2022, 08:35 AM

Hey Jakub Grufik

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

Code:

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** · 11-16-2022, 08:46 AM

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

**Jakub Grufik** · 11-16-2022, 09:00 AM

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

**Jakub Grufik** · 11-16-2022, 09:05 AM

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

**rabii** · 11-16-2022, 09:35 AM

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.

Code:

[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** · 11-16-2022, 11:53 AM

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** · 11-16-2022, 12:40 PM

tried to put all scheduled workflows to inactive and created new one with super simple action:

Code:

pocetLeaduAktualniKvartal = 0;
pocetPrilezitostiAktualniKvartal = 0;
pocetObhlidekUskutecnene = 0;
pocetUzavretychObchoduAktualniKvartal = 0;
obratZaKvartalNaObchodnika = 0;

With Scheduling */5 * * * * but it still does not work. nothing is being triggered

**Jakub Grufik** · 11-18-2022, 07:28 AM

Hello guys yuri rabii lazovic eymen-elkum

Sorry for tagging all of you, but I am really desperate. Our workflows do not work since the 8th of November and it is a big red flag for us. I tried everything to make it work. Unfortunately, without any success.

I have now access to code and to error logs so I am more than willing to provide every information needed. But I am really stuck at the moment and I do not know what to do to make it work. I tried to stop(put inactive) every single scheduled workflow and create a new one with a super simple action to try it out. But nothing is happening and none of the scheduled workflows is working. I tried also comment out the line in the code as suggested and it did not change anything.

I tried to go through logs to find some anomalies without success.

Is there by any chance some way to "hard reset" the cache for workflows or somehow restart the system or anything that could resolve this issue(I tried to rebuild php and clear cache like 5 times)? I really tried a lot of things and now I am just clueless about what else should I do.

I would be really happy if it could be resolved after 10 days, my boss is not very happy about it

If you are not supposed to be working on fixes like that, we can discuss some pricing for this service or I don't know how to approach this situation. I just need to make it work.

Thanks a lot in advance.

**lazovic** · 11-18-2022, 07:49 AM

Jakub Grufik,

Please tell me what versions of EspoCRM and Advanced Pack extension are you using?

Check the last time (at what time of day) at least one Scheduled Workflow was triggered. Then, look at the Action History (located in the Administration), what actions were taken?

Have you tried turning off absolutely all existing Workflows (not just Scheduled) and trying to run the most simplified Scheduled Workflow?

**Jakub Grufik** · 11-18-2022, 09:02 AM

lazovic Iam thinking, maybe the best way would be to copy the whole project to test-project, and in test, I can turn off everything and try to make it work without turning off everything in our real-project, what do you think?

**eymen-elkum** · 11-18-2022, 10:18 AM

Jakub Grufik if nothing succeeds with your current tries let me know, we will need a screen share with your computer for about 30 minutes to debug it, let me know on email eymen@eblasoft.com
We will share the result here for any future similar case

**Jakub Grufik** · 11-18-2022, 10:57 AM

eymen-elkum hello man, thanks a lot for the offer.

I am now trying to reach our guy who implemented espoCRM to explain me how to copy the real project to the test instance, I will try to fix the issue in the test instance then and if I wont be successful then we can schedule the videocall+teamviewer if its OK for you.

Thanks a lot one more time

**Jakub Grufik** · 11-24-2022, 07:34 AM

eymen-elkum hello sir, email sent

**Jakub Grufik** · 11-28-2022, 06:54 AM

hello guys, any news please? I was not able to figure it out on my own yet.

Scheduled workflows still not working

**Jakub Grufik** · 11-29-2022, 09:14 AM

eymen-elkum hey man, did you forget about our call? I was waiting the whole weekend. Tried to reach you via email.

Our management staff is not happy about not working system and are already considering switching to another CRM because of it.

We really tried to fix it on our own, but so far no luck. We just need to know if it's fixable or not and what options we have.

Thanks for help

Workflows are not being triggered

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment