Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Completed workflows are now disappearing in Microsoft Dynamics CRM - managing the size of the AsyncOperationBase Table

Post Author: Joe D365 |

In one of the recently released update rollups a new registry is now available for reducing the size of the asyncoperationbase and workflowlog tables.

Setting AsyncRemoveCompletedWorkflows to a value of dword 1 will cause all successfully completed workflows to be immediate deleted after they are run. This can be beneficial, but only to a very large crm implementation or an implementation where workflows are very heavily used.

    Another open that has been around for a while in reducing the size of this table is to set AsyncRemoveCompletedJobs a value of dword 1. This will cause only jobs that are not crm workflows to be removed from this table.

We recommend setting AsyncRemoveCompletedJobs but not AsyncRemoveCompletedWorkflows. If you are looking for help please consider PowerObjects in working with you for hosted XRM development – we are one of the leading providers of hosted Microsoft CRM and XRM hosting.

For more info:

AsyncRemoveCompletedJobs
http://support.microsoft.com/kb/957871

AsyncRemoveCompletedWorkflows
http://support.microsoft.com/kb/968755

 

Welcome to the #1 Dynamics CRM Partner in the World

Proud winner of the 2015 Microsoft Partner of the Year for Cloud Customer Relationship Management, PowerObjects is the preferred partner for implementing, supporting, and growing CRM solutions. Through unparalleled offerings of service, support, education, and add-ons, PowerObjects can help tailor custom solutions for your business.

How Can We Help You Today?

And as always, happy CRM'ing!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

One comment on “Completed workflows are now disappearing in Microsoft Dynamics CRM - managing the size of the AsyncOperationBase Table”

  1. Hi,

    I applied this technics after clearing the DB tables.

    But now every time I run a deletion operation on email activities the async job takes too much time and all the CRM freeze. Any ideas why?

    Thanks.

    P.S. great blog

PowerObjects Recommends