Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
MS Dynamics CRM Online : Generic SQL error when there are multiple custom workflow activities RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello

    I have two custom workflow activites created to format two specific types of fields (say field1 and field2).

    Both the custom workflow acitivies accept one input parameter which is required.

    The main workflows fires on create and on change of the values of the fields of contact entity.

    So Worklow1 fires against field1 and Worflow2 fires against field2.

    On create, when user enters value in both the fields, generic sql error is returned.

    On Update, the same scenario works properly (even when values of both the fields are changed).

     I tried to use both the custom workflow activities in the same workflow but still errors occurs 


    Thanks

    Krish

    Tuesday, November 22, 2016 11:36 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Are the workflows synchronous or asynchronous ? If they are synchronous then you could try running one or both asynchronously. The most likely cause of the error is a deadlock, and changing to asynchronous should resolve this.

    Are you running CRM OnPremise ? If so, if you enable tracing you should get more detail on the error.

    Also, it's worth checking your code to see if you can reduce the number of calls to the web service, and the fields referenced - e.g. do you do a Retrieve, when you could pass the data in a parameter instead ? If you do need a Retrieve or RetrieveMultiple, only return the columns you need, not AllColumns. And if you do an Update, only pass the fields that are changing 

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, November 23, 2016 11:48 AM
    Moderator