Bulk insert exception CMS_SearchTask

Looks like the Search Tasks are processed automatically as an async, which causes the deadlock.

I believe CMSProcessSearchTasksByScheduler=true should solve the issue, but wondered if there's a better solution?

Judith Randolph I'm not using SQL bulk insert I'm just using a threaded process calling _sKUInfoProvider.Set(skuResult.SKUInfo);

I'd check your search tasks to see how many tasks are in that table. What's happening is the insert is triggering an indexing task to process that page and add it to the index. You might want to disable the search index during your import, then enable it after and trigger a rebuild of that index.