CRM system jobs are in wait status

04 Mayıs 2012 Cuma 17:09

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

Düzenleyen Simran08 04 Mayıs 2012 Cuma 22:14

Tüm Yanıtlar

05 Mayıs 2012 Cumartesi 01:46

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"
- Yanıt
- Alıntı
05 Mayıs 2012 Cumartesi 20:55

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
- Yanıt
- Alıntı
07 Mayıs 2012 Pazartesi 12:28

0

Hi Sam;

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

How should i check

Thanks for your reply
Pradnya07
- Yanıt
- Alıntı
07 Mayıs 2012 Pazartesi 12:30

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
- Yanıt
- Alıntı
08 Mayıs 2012 Salı 11:43

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
- Yanıt
- Alıntı
19 Mayıs 2012 Cumartesi 18:27

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
- Yanıt
- Alıntı
21 Mayıs 2012 Pazartesi 01:28

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"
- Yanıt
- Alıntı