05:09
Dynamics Consulting München
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.
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.
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.
| operationtype | Description |
| 1 | System Event |
| 9 | Collect SQM data |
| 10* | Workflow Operation |
| 12 | Update Match Code |
| 25 | Generate Full Text Catalog |
| 27 | Update Contract States |
| State Code | Status Code | ||
| 3 | Completed | 30 | Succeded |
| 31 | Failed | ||
| 32 | Canceled | ||
| 2 | Locked | 20 | In Progress |
| 21 | Pausing | ||
| 22 | Canceling |
- 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.
Posted in: CRM 4.0 AsyncService
