CRM 2013 data import fails with synchronous plugin

(0) Share

Report

Posted on by Community Member

Hello,

We are facing an issue while importing lead data using OOB data import.

We have asynchronous plugin registered on Create of lead (Post-Operation) and is working fine while data import.

Because of a change in business logic, we have made that plugin to Synchronous and since then data import is not working.

I have enabled trace and found below error message,

"Cannot insert duplicate key row in object 'dbo.EmailSearchBase' with unique index 'ndx_for_forward_update'"

Data import is asynchronous and does it mean synchronous plugins/workflows doesn't work in this context?

Any suggestion would help a lot.

Thanks,

Sai Krishna P

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report

Saikrishna,

Follow all the steps mentioned in the below Blog to see if this resolves your issue :

community.dynamics.com/.../mscrm-2011-error-during-creation-of-account-record-system-data-sqlclient-sqlexception-0x80131904-cannot-insert-duplicate-key-row-in-object-dbo-emailsearchbase-with-unique-index-ndx-for-forward-update

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Rajkumar,

Thanks for prompt response. I have followed the changes mentioned in the above blog but still unable to get rid of the issue.

Blog suggests to create new entity class instead of working on the context parameters.

But we have in our logic several update calls to other entities such as Campaign & Email activity. Do I need to change those update calls as well? [ Ex:- creating entity class for retrieved record which needs update? ]

Any other suggestions?

Thanks,

Sai Krishna

Was this reply helpful? Yes No
Verified answer

Rajkumar Rajaraman on at

Like (0)

Report

Try your first approach like create entity class for retrieve record....

Was this reply helpful? Yes No
Mahendar Pal 45,095 on at

Like (0)

Report

Hello,

At present it seems it is related to email so you can try to change where email update is done, otherwise better to change it in all the service calls, it should be very quick.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Thanks all.

I got the solution for the issue. It seems where ever we have got update calls in the logic, we need to create Entity class before update, if it is going to be Synchronous call.

May I know the technical reason behind the issue [Async vs Sync] , just to understand better..!!!

Thanks,

Sai Krishna P

Was this reply helpful? Yes No