Friday, February 19, 2016

SharePoint 2013 Search: Search Crawl Errors after SQL Server 2012 SP3 Applied

After we applied SQL Server 2012 SP3, we noticed that the search crawls (which are mainly against Line of Business Data) where producing errors. The error was:

The content processing pipeline failed to process the item. ( Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index; ; 

After trying many things such as resetting index, recreating the content source, etc., I finally resolved the issue.

I needed to go into the Business Data Connectivity Services service application and Upgrade the External Content Type profile pages:


After I performed the upgrade, the crawls successfully completed with no errors.