Sometimes you just get stuck on a problem. This should be simple, but for some reason I just can't get this working....
I've got a portal with subsites. Searching works just fine at the portal level, but nothing is found if the search is done at the subsite level. Portal level searches will find documents in libraries in the subsites. Subsite level searches find nothing.
As I research this, as I understand it, the subsite searches should be using SQL Full Text catalogs. However, on the SQL Server there are no Full-Text Catalogs for any database..... ????
Does anyone know how to create these catalogs, and/or how to get SPS to search the subsites. Looking at the logs generated by the search crawler, all the content IS being crawled. I just can't get a search done at the subsite
level to actually find anything....
And yes, I've tried unchecking/checking the “Configure Full-Text Search“ checkbox.... several times to no avail.
Come on blog community, show me your stuff!
Any help is appreciated.
Thanks!
------- Update Feb 13th --------------
While I haven't corrected the problem yet, I have narrowed it down using SQL Profiler.... It seems when engaging the full text search from the WSS admin pages, the proc that creates the full text search catalog is failing. Sharepoint conveniently does not report this error, nor does it make any entry in any log I can find about it.... At any rate, by stepping through the proc I was able to determine the exact line that is failing and the sql error message that is generated. It appears that while the Full Text Search service is installed and running, any attempt to use it or create a catalog results in an obsure dll error.... Error 7619: Execution of a full-text operation failed. Error loading type library/DLL.
So, it seems something is wrong with my FTS installation. Since SQL doesn't allow you to uninstall a single component like FTS, I'm going to attempt to reinstall SP3 in hopes the bad dll is included in that package. If that doesn't work, I'll probably attempt to reinstall the SQL installation itself....
I'll post an update later.....