Announcement

Collapse
No announcement yet.

Workflows are not being triggered

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    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.

    Comment


    • #17
      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

      Comment


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

        Comment


        • #19
          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

          Comment


          • Jakub Grufik
            Jakub Grufik commented
            Editing a comment
            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.

        • #20
          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.

          Comment


          • Jakub Grufik
            Jakub Grufik commented
            Editing a comment
            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
            rabii commented
            Editing a comment
            Just put them inactive and create a new scheduled workflow for testing purpose with some simple action just to see if it will work.

          • Jakub Grufik
            Jakub Grufik commented
            Editing a comment
            on it! thanks a lot for the suggestion

        • #21
          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)

          Comment


          • #22
            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

            Comment


            • #23
              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.

              Comment


              • #24
                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?

                Comment


                • Jakub Grufik
                  Jakub Grufik commented
                  Editing a comment
                  Hello sir,

                  we upgraded espo to v7.2.7 last weekend, but the problem was also in the previous version before upgrade(we upgraded with hope that it will fix the issue)
                  Advanced pack v2.11.4

                  I am going to check the action history now (the last working workflow that I found was 8th November, 10:13AM - its been scheduled to run every 10 mins)

                  I have not tried turn off all workflows because it would stop everything important that is working now (including generating new orders, assigning users etc.) so it would be huge blackout in our system.

                  I can try to put our system into maintenance mode during the weekend and try to turn off every single workflow, but I am not sure how to turn it on effectively afterward to make sure it won't stop working again. (we have approx 60 active workflows)

                • Jakub Grufik
                  Jakub Grufik commented
                  Editing a comment
                  this morning I turned on debug mode again so hopefully around lunch time there will be enough error logs and I will be able to find some anomalies.

                • Jakub Grufik
                  Jakub Grufik commented
                  Editing a comment
                  I have not found anything suspicious in the action history, the only thing we added is a new personal email account (amazon) which caused the system to generate duplicate emails (reported here https://forum.espocrm.com/forum/gene...ated-by-system) but so far I have not found anything that could make workflows stop working

              • #25
                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?

                Comment


                • Jakub Grufik
                  Jakub Grufik commented
                  Editing a comment
                  thanks a lot man! do you want me to send you fresh logs from today with debug mode on?

                • lazovic
                  lazovic commented
                  Editing a comment
                  Yes, of course, fresh logs will be needed for analysis.

                • Jakub Grufik
                  Jakub Grufik commented
                  Editing a comment
                  here is today log with debug mode https://easyupload.io/yqxbh0

              • #26
                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
                CEO & Founder of Eblasoft.
                Professional EspoCRM development & extensions.

                Comment


                • #27
                  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

                  Comment


                  • #28
                    eymen-elkum hello sir, email sent

                    Comment


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

                    Scheduled workflows still not working

                    Comment


                    • #30
                      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

                      Comment

                      Working...
                      X