Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Problem with Case Entity Workflow with Status "Waiting" RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,


    I'm running CRM 4.0 with Rollup 19 applied on Windows 2008 64 Bit Enterprise Server with 64 Bit SQL 2005.

    I have created a simple work flow using a template with plain text.  The workflow itself checks   if Case Origin = Website and it should send an email from one user in CRM user database to another user. The workflow is set to Orgainistion, When Record is Created, and Child Work Flow.

    WHen a new case is created with Case Origin of Website  the workflow although triggered remains with a Status Reason of "Waiting"

    If I double click on the workflow from the Case the workflow displays an error messge of A SQL server error occurred. Try this action again, If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organisation's Microsoft Dynamics CRM Administrator

     

    Thanks Adam


    Thursday, December 1, 2011 9:29 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Adam,

     

    Can you make sure the users "To" and "From", both as valid email address

     

    Can you see any activity in CRM activities? after this workflow triggered

     

     

     

    Many Thanks -Bhautik Desai xRM Technologies
    Thursday, December 1, 2011 12:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Bhautik,

     

    Both users have valid email addresses.

    There is nothing in Activities.

     

    Thanks

    Adam

     

    Saturday, December 3, 2011 6:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Further to my last comments I have obtained the following information obtained from Systems Job --> Advanced Find and enabling Error Code and Message.
    Error Code:

    -2,147,204,784

    		 
    Workflow paused due to error: 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.Execute(Request Request)  at Microsoft.Crm.Asynchronous.SdkTypeProxyCrmServiceWrapper.Execute(Object request)  at Microsoft.Crm.Workflow.Services.SendEmailFromTemplateActivityService.Execute(ActivityExecutionContext executionContext, SendEmailFromTemplateActivity emailActivity)  at Microsoft.Crm.Workflow.Activities.SendEmailFromTemplateActivity.Execute(ActivityExecutionContext executionContext)  at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(T activity, ActivityExecutionContext executionContext)  at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(Activity activity, ActivityExecutionContext executionContext)  at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)  at System.Workflow.Runtime.Scheduler.Run()

    Thanks Adam
    Sunday, December 4, 2011 8:47 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

     

    Just to find out the problem, can you do following step and let me know what happend?

     

    (1) In CRM goto Activity under My Work

    (2)create new email manually from the activity

    (3) set the same address as workflow email in To and From

    (4) if it gives any error then go to next step

    (5) in email "From field" you keep your address

     

    let see what happend

     

    It looks to me you dont have permisstion to email impersonate... (in From email)

     

     

     

     

    Many Thanks -Bhautik Desai xRM Technologies
    Monday, December 5, 2011 9:53 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Bhautik,

     

    I was able to send email from Activiites in CRM using the send address used in the Workflow.

     

    Thanks 

    Tuesday, December 6, 2011 1:14 AM