MSCRM Campaign Activities Will Not Distribute and Become Stuck "In Progress"

Issue: When distributing a Campaign Activity for a Marketing List (or Lists) that total 5000 records or more, the Activity becomes stuck in an "In Progress" state.  The activities aren't created, but they don't fail either.  They're just...stuck.  

Cause: The high number of Contact, Account, and/or Lead records.  5000 is the number to use, though it's not exact. It is a good rule of thumb though.  Note that is also the total amount no matter the type. (Contact, Account, or Lead)

Solution:
1. Click Start, click Run, type regedit in the Open box, and then click OK
2. Back-up your Registry by saving it to a secure location
3. Locate and then select the following registry subkey:  HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
4. On the Edit menu, point to New, and then click DWORD Value
5. Type TurnOffFetchThrottling, and then press ENTER
6. Right-click TurnOffFetchThrottling, and then click Modify
7. Type a number other than 0 in the Value data box, and then click OK
8. Restart the CRM machine
9. Open the Campaign Activity in question and redistribute the Campaign Activity and the individual activities should be created.

Extremely Important Note: This can potentially cause performance issues. If it does, undo the steps above (or simply change the TurnOffFetchThrottling value to 0) and restart the CRM server again.  Then make sure you're not distributing Campaign Activities for Marketing Lists of 5000 records or more.  Instead, accomplish the same task by using multiple Marketing Lists made up of a lesser number of records.

Comments

[lau]

Hi, I have tried this solution with no result. When you write the the dword should have a value other than zero, what do you mean by that? Could it be any given number or is there a best practice that is recommended to follow?

We're not exactly experiencing the same issue, since im convinced that its not the number of accounts/contacts that is the problem.

Could this be because of a corrupt role?

Sincerely
Lau

[Ruston Eads]

Lau,

What is the exact problem you're experiencing? This one is specific to the number of Accounts/Contacts/Leads in the Campaign Activity.

As for using any number exept 0, I typically use 1. 0 disables the registry setting whereas any value greater than 0 allows it to work.

Thanks for the reply.
Ruston Eads

[Janne]

Hi,

I have an related issue. When I create a Quick Campaign for a marketing list (I am the Owner of the Contacts. And I have SysAdmin priviledge), the activities won't even get into "In progress" state. They remain "Pending" and won't show up on any Activities list.

Any ideas?

Thanks,
--
janne

[Ruston Eads]

Janne,

Thanks for the note. Have you installed Update Rollup 1? (http://support.microsoft.com/?kbid=952858) If not, please do so and try again. There were issues with CRM v4 early last year where System Jobs became hung based on an async service issue. Try that and see if you get anywhere.

[Janne]

Ruston,

Async service was indeed down and restarting it and running iisreset did the job. Thanks alot for your reply!
--
janne