lucasalexander / alexanderdevelopment.processrunner

This is an open source Dynamics CRM solution for scheduling and executing recurring workflows

AlexanderDevelopment.ProcessRunner

This is an open source Dynamics CRM solution for scheduling and executing recurring workflows. It executes a FetchXML query to return a set of records and then start a workflow for each of those records without requiring any external processes or tools. This is a generalized approach to solving a class of problems that includes the following scenarios:

1. The birthday greetings problem: How can you, on a daily basis, send an e-mail to every contact with a birthday = today (where the date value for today is obviously different every day)?
2. The monthly update problem: How can you, on a monthly basis, generate an activity for every account with status reason = X (where it's important that the process only runs on a certain day of the month based on status reason values as of that exact date)?

For more information, see my "Updated solution for scheduling recurring Dynamics CRM workflows" blog post.

The original CRM 2011 version of this solution was first described described in my "Scheduling recurring Dynamics CRM workflows with FetchXML" blog post.

alexanderdevelopment.processrunner's Issues

Page Size doesnt change anything

Hello, I'm changing the Page size to limit the number of record by batch created.
We have more then 5000 records to update.

I'm getting a 2 min timeout error. Is the page size should overcome the 2 min timeout?

Also unable to use top =1000 in the fetch query because Page Size parameter is used.

On-Prem version?

Any chance you can publish compiled version for Dynamics 365 v9 on prem? Or offer a solution to how to get the package to import for on prem Dynamics 365? I'm getting the dreaded "The solution package you are importing was generated on Microsoft Dynamics 365 (online). You can't import it into on-premises or hosted version of Microsoft Dynamics 365".

This solution seems perfect for what I need to do, hoping to get it installed. Thanks in advance for any help.

Set the process to run monthly/annually

Hello Alexander,

Is there a way I can set the frequency of the Process to different values (monthly, bi-weekly or annually)?

Best regards,
Hayman

Error Preventing Plugin From Running

Hi Alexander!

First of all, thanks for such an awesome solution! I am having a bit of trouble getting it to run :) On my recurring workflow runner i get the following error:

An unexpected error occurred from ISV code. (ErrorType = ClientError) Unexpected exception from plug-in (Execute): AlexanderDevelopment.WorkflowScheduler.RunScheduledWorkflows: System.TimeoutException: Couldn’t complete execution of the custom activity AlexanderDevelopment.WorkflowScheduler.RunScheduledWorkflows plug-in within the 2-minute time limit.

Any suggestions? Thanks!

Recurring Process Triggering Work Flow More Than Once

A Recurring Process I setup to trigger a workflow on a daily basis is often triggering the workflow more than once. Basically, the Recurring Process finds all the contacts whose Next Home Anniversary is today. It triggers a workflow called ABPR: Home Anniversary that adds some other logic, calls a Child Workflow that sends the email and then updates Next Home Anniversary to next year. I have occasionally seen more than one email sent to the same Contact. I updated to your latest version and ran some tests with 2 test Contacts. Looking at the Process Sessions for ABPR: Home Anniversary, in the latest run it was triggered 3 times for each Contact. Attached is the screen shot of the Process Sessions. I will change the logic in ABPR: Home Anniversary to update the Next Home Anniversary prior to calling the child workflow. I hope that will minimize the impact on my clients but doesn't solve the root problem. This is a great solution that is very useful. I hope there is a correction that can be made.

Invalid Pointer Error

I am trying to run a recurring workflow every morning at 6am.

It should run against 1,200 records or so. But I fails after the first few instances of the workflow with that message:
Invalid Pointer
ValidateOpen - Encountered disposed CrmDbConnection when it should not be disposed

I have found some reference regarding this issue:
http://burnignorance.com/ms-crm-app-development-tips/invalid-pointer-error-in-custom-workflow-in-ms-crm/

I tried to play with the page size, going from 10 to 2,000, but nothing works.

Thanks for your help!