Sql server time out on mscrm 2011 online plugin running RRS feed

  • Question

  • Dear ALL;

    i have a plugin which running on update of a field which actually getting all the account (currently i have 200 accounts) and putting it into another system using that system websrevice everything works fine when i have few accounts but if the numbers of accounts increasing then getting the sql server time out error . please help 

    Wednesday, June 26, 2013 8:09 AM

All replies

  • Hi,

    If plugin executes more than 2 minutes it will give timeout exception. Because of the maximum time for plugin is 2min.

    Instead of plugin you can write Custom workflow. After Rollup12 installation, custom workflow also support for online crm.



    Wednesday, June 26, 2013 8:53 AM
  • i can not use custom workflow is there anyway we can increase it on online
    Wednesday, June 26, 2013 9:19 AM
  • it is online
    Wednesday, June 26, 2013 9:30 AM
  • There is no way to increase this limit in Crm Online. I can't see any technical reason why you couldn't use a workflow, and this seems like your best option

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

    • Proposed as answer by Philippe LEAL Tuesday, July 2, 2013 1:26 PM
    Wednesday, June 26, 2013 12:39 PM
  • Yes, there is no way to increase the plugin execution time.


    Sravan J

    • Edited by sravan J Wednesday, June 26, 2013 2:52 PM modification
    Wednesday, June 26, 2013 2:49 PM
  • Hi Sravan;

    i have implemented the custom workflow activity now the i am doing it with custom workflow activity but i am still getting the error

    "The plug-in execution failed because the operation has timed-out at the Sandbox Client"

    Tuesday, July 2, 2013 11:28 AM
  • Hi Anwar,

    I think you are using queryexpression for retrieving records. Instead of queryexpression try with FetchXml Response. FetchXml response is faster than queryexpression.


    Sravan J.

    Thursday, July 4, 2013 12:40 PM
  • There's very little performance difference between QueryExpression and FetchXml, so I doubt this would make a difference. I expect most of the time is taken by the calls to the external system.

    I think you only solution would be to make fewer calls to the external system within the plugin / workflow activity, which probably means you'd have to create a way to only send a few records at a time, and, if there are remaing records to be sent, invoke a change that would cause the workflow activity to fire again

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

    Thursday, July 4, 2013 12:47 PM