The AsyncOperationBase Table: What are all those records anyway?

There have been several KB articles and updates published to help control the size of the AsyncOperationBase table, which can cause your CRM database to grow very large, very quickly. (See here and here.) But just what are all those records anyway?

I pulled the following lists together from the SDK and technet in order to put this info in one place, where it’s a little more user-friendly (at least for me!).

First, the list of AsyncOperationTypes:

Value	Field	Description
1	Event	Specifies a system event.
2	BulkEmail	Specifies a bulk e-mail operation.
3	Parse	Specifies an import file parse operation.
4	Transform	Specifies an operation to transform parse data.
5	Import	Specifies an import operation.
6	ActivityPropagation	Specifies a campaign activity propagation operation.
7	PublishDuplicateRule	Specifies an operation to publish a duplicate detection rule.
8	BulkDetectDuplicates	Specifies a bulk duplicate detection operation.
9	CollectSqmData	Specifies an operation to collect SQM data.
10	Workflow	Specifies a workflow operation.
11	QuickCampaign	Specifies a quick campaign operation.
12	PersistMatchCode	Specifies an operation to update the matchcode.
13	BulkDelete	Specifies a bulk delete operation.
14	DeletionService	Specifies a Deletion Service operation.
15	IndexManagement	Specifies an index management operation.
16	CollectOrgStats	Specifies an operation to collect an organization's statistics.
17	ImportingFile	Specifies an import subprocess operation.
18	CalculateOrgStorageSize	Specifies an operation to calculate an organization's storage size.
19	CollectOrgDBStats	Specifies an operation to collect an organization's database statistics.
20	CollectOrgSizeStats	Specifies an operation to collection an organization's size statistics.
21	DatabaseTuning	Specifies an operation for database tuning.
22	CalculateOrgMaxStorageSize	Specifies an operation to calculate an organization's maximum storage size.
23	BulkDeleteChild	Specifies a bulk delete subprocess operation.
24	UpdateStatisticIntervals	Specifies an operation to update statistic intervals.
25	FullTextCatalogIndex	Specifies an operation to generate an organization full text catalog index.
26	DatabaseLogBackup
27	UpdateContractStates	Specifies an operation to update contract states.
28	ShrinkDatabase
29	ShrinkLogFile
30	ReindexAll	Specifies an index management operation.
31	StorageLimitNotification
32	CleanupInactiveWorkflowAssemblies
38	ImportSampleData

Next, here’s a list of the different state/statuscodes that each of these operation types can be in:

State	Status	Numeric status value
Ready	WaitingForResources	0
Suspended	Waiting	10
Locked	InProgress	20
Locked	Pausing	21
Locked	Canceling	22
Completed	Succeeded	30
Completed	Failed	31
Completed	Canceled	32

Hope this is useful to you! Have fun with it.

Update Rollup 7 - With Major Improvements to Outlook Client

In a rare feat of cross-organizational synergy, Microsoft is releasing Update Rollup 7 for CRM on the same day as Window 7 is officially released!

UR7 contains support for Windows 7 and recent releases on the server side, but the big news is the major improvements for the Outlook client.

More information about this imminent release is at the CRM team blog.

Dynamics Salary Survey

A recruiting firm in the UK asked if I would post this on my blog and ask my readers to participate in their annual survey of salaries for people in the Microsoft Dynamics world. I'm posting this because I think it's exciting that Microsoft has been able to build an eco-system around their Dynamics products, and, for those of us who make a living in this ecosystem, this kind of research should help define the value of our contributions to our respective employers and see what standards are emerging for our chosen careers. Please take a moment to consider completing the survey:

Nigel Frank International would like to invite you to complete what is to be our
annual survey of Microsoft Dynamics salaries worldwide.

The survey will only take a couple of minutes to complete and your response and any personal details will be kept strictly confidential. The survey is available in the following languages for your convenience; English, German, French, Dutch, Danish, Spanish, Italian, Norwegian, and Finnish.

As a thank-you for your contribution we will send you a PDF report of the results once they have been compiled. This will give you an insight into the salaries, opinions and demographics of your Microsoft Dynamics counterparts worldwide.

Please find a link to the Microsoft Dynamics Salary Survey 2009 below:

http://www.surveymonkey.com/s.aspx?sm=oyKnQyB3GWcw3xwDjIiSOQ_3d_3d

Your response will be greatly appreciated and will help to give everyone in the
Microsoft Dynamics community a greater understanding of their profession.

Configuring Internet Facing Deployment for Microsoft CRM 4.0

After running the tool to configure the CRM website for an Internet Facing Deployment (see the articles here and here) we got the old familiar Runtime Error: Server error in / Application. We turned on remote errors and saw the underlying error message was even less helpful: "Object reference not set to an instance of an object."

After some digging, it turns out there was a registry key on the CRM server that incorrectly identified the identifier of the CRM website in IIS.

The 'website' registry key at \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM had a value of '/LM/W3SVC/1' and it should have been '/LM/W3SVC/5'

You can see the identifier for the CRM website in this screen capture from IIS:




All we had to do is navigate to the registry key and change the value to reflect the identifier that we saw in IIS.

Update Rollup 6 for MS CRM 4.0 Released

Whew! Those guys on the Sustained Engineering team at Microsoft keep cranking them out. Seems like we've just finished deploying UR5 on all our implementations. Now, they've released Update Rollup 6. From the article, it looks to contain just a very small number of fixes. Download it at: https://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=79f90982-c039-41c2-af8e-3119ecf27790#filelist