I get this error on MOSS 2007 Search Crawl logs:
The parameter is incorrect. (Cannot use the Business Data Catalog from outside an Office Server context without explicitly setting the Shared Resource Provider by Name on the Business Data Catalog Sql Session Provider)
..when crawling BDC data sources, in this case is just pointing to a standard SQL Server 2008 database table, using SSO auth.
Meanwhile normal SharePoint sites content sources are crawled alongside this successfully. I discovered a strange workaround that if I create a completely new separate Shared services provider web application, and try to recrawl the BDC content source (from the seemingly broken SSP), it then works. But then weeks later, the error recurs.
This error is displayed for every existing item in the content source and the index is not updated. It does however retain the old updated items in the index.
This has been going on for a few months on 3 separate environments (System Test-hosted separately, UAT and PROD) for the same client. And it has to be I must have done something wrong with the setup/configuration, but deleting the BDC content source and re-creating it more than twice so far has not helped.
Has anyone else encountered anything like this before? I can't seem to find anyone with a similar issue anywhere.