I had an issue where a Bulk Delete job I had created was never executing and the status simply read “waiting for resources”. I checked the Microsoft CRM Asynchronous Process Service and it was not started. When I started it, I received an error:
“The Microsoft CRM Asynchronous Processing Service service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.”
The service account was fine, so I checked the MS CRM logs for the service. It was showing an error occurred in a method named “GetServerIdFromDatabase”. I ran a SQL trace and discovered that the “NAME” column in table “SERVER” had the wrong value. At one point the server was renamed, and apparently either a step was missed or it was done the wrong way – MS has a support article on moving CRM installations here: http://support.microsoft.com/kb/952934.
All I had to do was update the SERVER.NAME column with the correct value and the bulk delete job processed just fine. Hopefully I won’t run into any other settings that may have been missed when things got moved, but thankfully there are logs and SQL traces!
