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>
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