Free Up Storage Space : WorkflowLogBase and AsyncOperationBase

When WorkflowLogBase & AsyncOperationBase start growing up fast and sometimes unreasonably you should launch bulk deletion jobs as soon as possible, which means before things get complicated and total storage exceeds 100%, in that case you may be unable to run any process within the system due to degraded performances and only Microsoft Support can help you.

In a nutshell AsyncOperationBase & WorkflowLogBase tables contain records generated whenever a workflow is triggered in the organisation as well as Business Process Flow logs.

Cleaning-up WorkflowLogBase

First navigate to Advanced Settings –> Data Management –> Bulk Record Deletion.

Create a New Bulk Record Deletion and then click Next and define search criteria, choose Process Sessions entity and filter only records with Status=Completed.

You can Preview Records before moving to the next step (as you can see in the screenshot above).

In the next popup you can :

  • Name your Bulk Deletion Job (by default it’s Bulk Deletion – DateTime)
  • Choose whether you want to run your job immediately or later
  • If you want to run your job at a scheduled time, you can also set a recurrence to run it after every x days. I would recommend to run the job every 7 days for example.
  • The last checkbox allows you to receive a notification email once the job is finished, you can also pick another user to notify.

Cleaning-up AsyncOperationBase

Same applies to AsyncOperationBase, you only pick System Jobs in lieu of Process Sessions as you can see below.

One thought on “Free Up Storage Space : WorkflowLogBase and AsyncOperationBase

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s