Did you know: Easy way to troubleshoot Asynchronous failures using [Advanced Find]

MSCRM 4.0 uses a lot of System Jobs to drive many features such as Workflows, Import Data,Duplicate Detections, Campaign Activities distribution, Send Bulk E-Mail and more... These jobs are processed by the Asynchronous Service and it can happen that the service fails to process these jobs. Jobs can fail or get stuck in waiting state.

Quick step: Add Error Code and Message Column in Advanced find and Filter the System Jobs which are showing error Code.

Detailed steps:
Here are a few steps you can try to get more information about the System Jobs failures reasons:
• Log into Microsoft Dynamics CRM.
• Go to Settings \ System Jobs, click Advanced Find button, click Save As to save your custom query, name it “Problematic System Jobs” for instance and click OK.
• Click Edit Columns, Add Columns and select Error Code and Message. Click OK. These two columns will be helpful for troubleshooting.
• Get back to Advanced Find screen. Click on Show Details. Select the Error Code field and select Contains Data criteria. [Filter on the System Jobs which are showing errors]
• Click on Save Button.

Now when you select this view in Settings \ System Jobs, you can see the Error Code and Error stack in Message Column which states the reason of the failure.

The failure is likely to be that the Asynchronous Service cannot contact the CRM Web Services because of a bad configuration. Error Code : -2,147,204,346

Isn't it easy !!! Happy Troubleshooting.

Please refer the following articles for more information:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;947423

http://support.microsoft.com/default.aspx?scid=kb;EN-US;950416

http://support.microsoft.com/default.aspx?scid=kb;EN-US;950542