Mittwoch, 16. Februar 2011

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.
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 CodeStatus Code
2Locked20In Progress
Automatic deletion of entries from this table can be enabled if Update Rollup 3 is installed. Refer to:
- for removing workflow expansion tasks
- for removing completed workflow entries
This article describes how to manually remove entries from the asyncoperationbase table.

Twitter Delicious Facebook Digg Stumbleupon Favorites More

Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Free Samples By Mail