Error when creating a CRM account from a WebService which trigger a plugin (on create account) in SYNCHRONUS mode (post-operation)
-
8 aprilie 2011 12:24
Version CRM 2011 :
Description : following error when creating a CRM account from a WebService which trigger a plugin (on create account) in SYNCHRONUS mode (post-operation)
>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #3D3CB7FD: System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.EmailSearchBase' with unique index 'ndx_for_forward_update'.
Is it a bug ??
Toate mesajele
-
8 aprilie 2011 15:21Moderator
This index is based on the ParentObjectId (in this case the accountid) and an ordinal number relating to the field containing the emailaddress.
The most likely cause would be if your plugin (or the code that creates the account) is passing a duplicate accountid, so that's the first thing I'd check.
Otherwise you can enable tracing or use SQL profiler to find the SQL that causes the error
Microsoft CRM MVP - http://mscrmuk.blogspot.com http://www.excitation.co.uk- Marcat ca răspuns de Andrii ButenkoMVP, Moderator 24 aprilie 2012 15:52
-
24 aprilie 2012 15:52Moderator
Hello Patrick,
Unfortunately it is too late but following thread answers your question - http://social.microsoft.com/Forums/en-IN/crmdevelopment/thread/52f85c0f-0cd2-4374-a0d6-b2b0644018a7
Microsoft CRM Freelancer
My blog (english)
Мой блог (русскоязычный)
- Marcat ca răspuns de Andrii ButenkoMVP, Moderator 24 aprilie 2012 15:52
