CRM system jobs are in wait status

Friday, May 04, 2012 5:09 PM

Hi All;

The system workflow jobs in CRM are in wait condition

Restarted Asyn server but didnt help

Any idea what must have gone wrong

in advanced find i got the following as error message on system jobs

Unhandled Exception: System.Web.Services.Protocols.SoapException: Server was unable to process request. Detail: <detail><error> <code>0x80044150</code> <description>Generic SQL error.</description> <type>Platform</type> </error></detail> at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.Crm.SdkTypeProxy.CrmService.RetrieveMultiple(QueryBase query) at Microsoft.Crm.Asynchronous.SdkTypeProxyCrmServiceWrapper.RetrieveMultiple(QueryBase query) at Microsoft.Crm.Workflow.WorkflowExpansionPlugin.GetWorkflows(ICrmService crmService, String messageName, String primaryEntityName) at Microsoft.Crm.Workflow.WorkflowExpansionPlugin.GetWorkflows(ICrmService crmServiceSystem, IPluginExecutionContext context) at Microsoft.Crm.Workflow.WorkflowExpansionPlugin.Execute(IPluginExecutionContext context) at Microsoft.Crm.Asynchronous.EventOperation.InternalExecute(AsyncEvent asyncEvent) at Microsoft.Crm.Asynchronous.AsyncOperationCommand.Execute(AsyncEvent asyncEvent) at Microsoft.Crm.Asynchronous.AsyncHostHandler.Handle(AsyncEvent asyncEvent) at Microsoft.Crm.Asynchronous.QueueManager.PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)

Any Help much appreciated

Thanks

Pradnya

Pradnya07

Edited by Simran08 Friday, May 04, 2012 10:14 PM

All Replies

Saturday, May 05, 2012 1:46 AM

0

Appears the workflow execution failed because of connection issues with crm. Did you create a custom workflow assembly?

Sam
Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com

If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"
- Reply
- Quote
Saturday, May 05, 2012 8:55 PM

0

Hello Simran08:

First thing first. Check whether the CRM async service is running fine on server. Then if some custom plug-in is involved in this workflow, check whether it is working fine or it is throwing some exception. At the last you can also verify whether the SOAP/ REST services are working fine for your organization. If you have any confusion in performing any of the above task, do let me know.
Enjoy...:)
Saurabh Gupta, MS CRM 2011 Software Development Engineer
- Reply
- Quote
Monday, May 07, 2012 12:28 PM

0

Hi Sam;

i dont know as many of my colleagues are working oin CRM

How should i check

Thanks for your reply
Pradnya07
- Reply
- Quote
Monday, May 07, 2012 12:30 PM

0

Hi Saurabh;

Thanks for your reply

Asyn service is working fine

How do i check for custom plug in or the SOAP rest services

Thanks

Pradnya
Pradnya07
- Reply
- Quote
Tuesday, May 08, 2012 11:43 AM

0

Hi All;

I just found that my workflows are actuaaly working but they show status reason as waiting in the system jobs

Can you please help regarding the same

Thanks

P
Pradnya07
- Reply
- Quote
Saturday, May 19, 2012 6:27 PM

0

Hello Simran08:

For checking whether custom plug-in is working fine, you better debug the plug-in.

For checking SOAP/ REST services, go to Setting--> Customizations --> Developer Resources. There you will find SOAP and REST services.

Click on both the links and output should come as service methods and XML form of data respectively.

Saurabh Gupta, MS CRM 2011 Software Development Engineer
- Reply
- Quote
Monday, May 21, 2012 1:28 AM

0

Can you paste a copy of your workflow designer here for review? Do you have any wait conditions included in your workflow?

Sam
Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com

If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"
- Reply
- Quote