Asyncoperationbase table – operationtype, status code and state code

The asyncoperationbase table stores details of system jobs (including workflows). The following table details some of the different job types that are stored in the table.

operationtypeDescription
1System Event
9Collect SQM data
10*Workflow Operation
12Update Match Code
25Generate Full Text Catalog
27Update Contract States

Note: For entries where the operationtype is 10, there are also related entries in the workflowlogbase table (join on the asyncoperationid field). The CRM SDK lists additional operationtypes.

State Code Status Code 
3Completed30Succeded
  31Failed
  32Canceled
2Locked20In Progress
  21Pausing
  22Canceling
1Suspended10Waiting
0Ready0Waiting for Resources

Automatic deletion of entries from this table can be enabled if Update Rollup 3 is installed. Refer to:

http://support.microsoft.com/kb/957871/ for removing workflow expansion tasks
http://support.microsoft.com/kb/968755/ for removing completed workflow entries

This article http://support.microsoft.com/kb/968520 describes how to manually remove entries from the asyncoperationbase table.

Leave a Comment

Your email address will not be published.