Cannot call Update method in Child pipeline to update Dynamic Entity RRS feed

  • Question

  • Hi all,

    I have a situation and get stuck in there.

    When user assign an account to another user, I need to update all Description field of letters which belong to this account with new value. I create a plug-in and register it: child pipeline, pre-stage mode, Update message, primary entity is letter. In Plug-in code, I get entity in InputParameter of IPluginContext and cast to DynamicEntity. And then update Description field with new value. However, new value not effect after that. I try to create a Crmservice and call Update method in that to DynamicEntity above. Systeam throw Exception -  Server was unable to process request. <description>Generic SQL error.</description>

    Please help me out in this situation.

    Thank very much.
    Bao Doan
    Wednesday, July 22, 2009 10:02 AM


  • The 'Generic SQL error' is almost certainly a SQL locking problem, which is very common in plugins registered on the child pipeline. From your description of what you're trying to achieve, I suggest you use the register the plugin on the parent pipeline, and this should solve the problem

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Thursday, July 23, 2009 9:38 AM