Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Recursive daily workflow randomly *missing* an execution

  • 1.  Recursive daily workflow randomly *missing* an execution

    SILVER CONTRIBUTOR
    Posted 22 days ago
    This is a weird one that I'm hoping the CRMUG wizards have seen before. This is all for CRM 8.2 on-premise.

    I've got a recursive workflow that runs daily to update three date-only fields. After it runs, it has a wait condition for 1 day before calling itself again on the same record. This is a screenshot of the workflow detail from one successful execution.



    But the weird thing is that CRM will randomly miss a day. See the execution history from one of the records and note the red lines where it skipped a day.

    There are no failed instances of the workflow, and nothing else I can see that would cause this. What's also strange is that this same workflow is running on multiple records, and they all miss days, but they miss *different* days. That makes me think this is not some server or CRM level issue, per se, but something specific in the way the workflow execute.

    Anybody seen something like this before? I know workflows, especially recursive ones, are going out of vogue in the world of Flow and Powerapps, but it's what we've got to work with.



    ------------------------------
    Mike Cutlip
    RAMCO
    www.RAMCOAMS.com
    Durham, NC
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Recursive daily workflow randomly *missing* an execution

    TOP CONTRIBUTOR
    Posted 22 days ago
    We have seen problems with this kind of implementation and opted for using scheduled jobs in SQL to trigger time sensitive tasks like that.

    ------------------------------
    If this answered your question, please click on the arrow button next to Reply Inline and choose 'Make Best Answer.'
    Thanks.
    Nelson Johnson, Solution Architect
    BroadPoint, Inc., Bethesda MD
    Link with me! https://www.linkedin.com/in/nelsonjohnson/
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Recursive daily workflow randomly *missing* an execution

    SILVER CONTRIBUTOR
    Posted 21 days ago
    Thanks, Nelson. We may have to go that route if we can't figure this out. We're hoping, of course, to keep this accessible to the end users so we don't have to constantly administer it for them. Will see how it goes.

    ------------------------------
    Mike Cutlip
    RAMCO
    www.RAMCOAMS.com
    Durham, NC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Recursive daily workflow randomly *missing* an execution

    GOLD CONTRIBUTOR
    Posted 22 days ago
    Mike I can't speak to the intermittent nature of the workflow, but you are right that power automate would be a better option than a recursive workflow. If you don't have plans to move from ground to cloud you should look into the on-premise data gateway so that you can still take advantage of the latest platform updates:

    https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem

    Thanks.

    ------------------------------
    Doug Apicella
    Solution Architect
    Hitachi Solutions
    SC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Recursive daily workflow randomly *missing* an execution

    SILVER CONTRIBUTOR
    Posted 21 days ago
    Hi Doug, we did some research last year for the on-prem gateway but it didn't work for the way we're hosting our customers. We've got about 160 CRMs spread across different batches of VMs, and we do that so we don't have to maintain patching on 160 different host machines. The gateway, from what we saw at the time, is based on distinct SQL server installs. So we could install it, but on the other end we wouldn't be able to partition the access for the different customers; all customers with databases in a SQL server would have access to all the other DBs. Maybe that's changed with a newer version of the gateway? Either way, it would be a pretty long-term project for us. We're hoping that MS comes out with some better licensing models for CRM Online, so it's cost effective for our users with giant DBs and heavy API traffic, before making that leap.

    ------------------------------
    Mike Cutlip
    RAMCO
    www.RAMCOAMS.com
    Durham, NC
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role