Re: SQL cluster search problems - this may help
From: Philip Colmer (pcolmer_at_newsgroups.nospam)
Date: 08/10/04
- Next message: Bob: "new to SPS, how to change the page layout"
- Previous message: Chris Deanes: "Simple description of Area Templates"
- In reply to: Mike Walsh: "Re: SQL cluster search problems - this may help"
- Next in thread: Mike Walsh: "Re: SQL cluster search problems - this may help"
- Reply: Mike Walsh: "Re: SQL cluster search problems - this may help"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Aug 2004 15:34:30 +0100
Mike
Given that the problem was caused by DLL differences in an SQL installation,
it seems likely to me that this problem can affect both Portal and
standalone WSS users.
I don't expect it to affect Portal users only because the problem isn't
caused by the installation of SPS or, indeed, WSS itself but by the
installation of SQL Server.
Although I don't have a standalone installation of WSS, it was my
understanding that WSS in both forms (standalone and as part of SPS) uses
SQL's fulltext capability to perform searches. If I was mistaken in that, I
apologise for the cross-posting. If I am correct, though, then I believe I
did the right thing.
--Philip
"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:eR3Pk2rfEHA.2908@TK2MSFTNGP10.phx.gbl...
> Could you spell out in words I can understand whether this solution
> applies
> **only** to Portal Server 2003 users (in which case I don't understand why
> it was also posted to the WSS newsgroup) or **also** to standalone WSS
> users
> (in which case I do understand ...)
>
> My impression from your text is that it only applies to SPS 2003 but as
> you
> posted it to the WSS newsgroup too, I am wondering if that impression was
> wrong.
>
> Mike Walsh, Helsinki, Finland
> WSS FAQ at http://wss.collutions.com
> Please reply to the newsgroup
>
> "Philip Colmer" <pcolmer@newsgroups.nospam> wrote in message
> news:O0jmcqrfEHA.1092@TK2MSFTNGP11.phx.gbl...
>> There have been occasional postings from people who have had problems
>> with
>> performing searches within WSS sites when their databases are running on
>> a
>> SQL cluster. For some people, if they have been using SPS, they have
>> found
>> that the searches work at the portal level but not at the site.
>>
>> It is important to understand that WSS searches are conducted using the
>> fulltext indexing capability of SQL Server, whereas the portal search
>> capability works in a very different manner.
>>
>> I too have had the problem outlined above and, with the assistance of
>> Microsoft PSS, got to the bottom of the problem. I am sharing this
> solution
>> with everyone in case it helps. Your mileage may vary - your symptoms may
>> not match exactly and so the solution I'm going to give may not solve
>> your
>> problem.
>>
>> The steps we went through were:
>>
>> * Check that Microsoft Search service is installed. This is listed in the
>> Services control panel applet. If it isn't listed, it hasn't been
> installed.
>> It was already installed on both of my nodes.
>>
>> * Check the output from SELECT
>> fulltextserviceproperty('IsFulltextInstalled'). If you get "1" back, SQL
>> believes that the service is up and running properly. If you get "0", it
>> isn't. In my case, it was working when I migrated the cluster service
> group
>> over to node A, but it didn't work when it was on node B. For reasons I
>> won't go into, I was using node B by default.
>>
>> The next steps were to try to spot the differences between the two nodes.
> I
>> was asked to check the following:
>>
>> 1) Make sure the below registry are the same between two nodes:
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search
>> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH
>>
>> 2) Make sure the DLLs are with the same version in the below folders:
>> \Program Files\Common Files\System\MSSearch
>> \Program Files\Microsoft SQL Server\80\COM
>> \Program Files\Microsoft SQL Server\MSSQL\Binn
>>
>> 3) Register the below DLLs:
>> \Program Files\Microsoft SQL Server\MSSQL\Binn\SQLFTQRY.dll
>> \WINNT\CLUSTER\GATHERCL.DLL
>> \Program Files\Common Files\System\MSSearch\Bin\*.DLL
>>
>> Step (1) may reveal some differences if you've got service groups that
>> are
>> one node but not all of them. This was so in my case, but the majority of
>> the registry keys were identical.
>>
>> Step (2) is a bit daunting because of the number of DLLs involved. It may
>> help to remember that if you change the window display to "Details", you
> can
>> then customise the columns to include the file version, thus making it
> easy
>> to compare.
>>
>> I did find some DLL differences:
>>
>> C:\Program Files\Microsoft SQL Server\MSSQL\Binn
>> sqlftqry.dll - 2000.80.760.0 (was 2000.80.194.0)
>> ssmsgnet.dll - 2000.80.382.0 (was 2000.80.194.0)
>>
>> C:\Program Files\Microsoft SQL Server\80\COM
>> cnv6x70.dll - 2000.80.760.0 (was 2000.80.194.0)
>> sqlfth75.dll - 2000.80.760.0 (was 2000.80.194.0)
>>
>> I copied those over and then went through step (3). This is done with
>> regsvr32. For some of them, I got an error - DllRegister Server entry
> point
>> was not found - but PSS said this was OK.
>>
>> After all that, I move the service group from node B to node A (the
> working
>> node) and then back again. I then used the SQL query and confirmed that
>> it
>> was returning "1" to indicate that fulltext was working.
>>
>> Finally, I went into SharePoint, turned off full text indexing and then
>> turned it back on again. After waiting for a short while, I performed a
>> search in a WSS site and it worked!
>>
>> I hope the above helps some of you. I would reiterate that your mileage
> may
>> vary. If you have got Software Assurance with either your SQL Server
> licence
>> or your SharePoint Portal Server licence, you may be able to take
> advantage
>> of online support through the Software Assurance benefit. This is what I
> did
>> and I'd like to thank PSS for their help with the above problem.
>>
>> --Philip
>>
>>
>
>
- Next message: Bob: "new to SPS, how to change the page layout"
- Previous message: Chris Deanes: "Simple description of Area Templates"
- In reply to: Mike Walsh: "Re: SQL cluster search problems - this may help"
- Next in thread: Mike Walsh: "Re: SQL cluster search problems - this may help"
- Reply: Mike Walsh: "Re: SQL cluster search problems - this may help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
