Full Text Search and Sharepoint

Hello
I have a problem with Full Text Search and Sharepoint.
From my understanding Sharepoint basically uses SQL's full text search
right.
But recently, sharepoint search stopped working. It's not returning any
results at all.
So I researched about it and found out that I should check the full text
index of Sharepoint Database
I did and found out that item count is 0 and size is 0MB so I tried
rebuilding the catalog but
I get this Error 7608
An unknown full-text failure (8007007e) occurred in function EnumCatalogs on
fullt-text catalog.
So I did further research and tried creating a full-text catalog for a
database i just created for testing purposes.
But still the same error when I tried to build a full text catalog.
then I found Nick Porter's suggestion via google:
http://spaces.msn.com/members/nickpo...ew&_c=blogpart
and found out that I need to reinstall SP3a/SP3.
and so I did, however, during the first few steps (after checking the
licensing agreement)
I get asked for which user I want to use (Windows Account/sa?) so first I
tried using the windows account (it's an admin domain account - which was
used when SP3 was initially installed) then it would say Validating
User...and it took a very looooong time for the installer to do that. It
took an hour just to validate the user to the point that it seemed like the
system had hung up already. But of course I waited because I just couldnt
cancel the installation...only to get an Access Denied Error. So the
installation aborts by itself and nope the installation did not even reach
the copying installation files point -- just until validating user. Then one
service account I use for Sharepoint gets locked out. The sharepoint service
account is different from this sql doman admin account.
Then when I tried to open the Enterprise Manager, it takes a really long
time to open the database folder then it hangs.
So our tech support admin recommended that I restart the server. Then
everything was working well again (thank goodness) except for the full text
search. It still gives me the error and I don't want to risk trying it again
until I find out what went wrong to the reinstallation procedure of SP3a.
Any ideas how I can solve my full text search problem?
Thank you.
Did you review this kb article?
http://support.microsoft.com/default...b;en-us;295772
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Abi Sabado" <abisabado@.gmail.com> wrote in message
news:Oh3x3bZnFHA.3900@.TK2MSFTNGP09.phx.gbl...
> Hello
> I have a problem with Full Text Search and Sharepoint.
> From my understanding Sharepoint basically uses SQL's full text search
> right.
> But recently, sharepoint search stopped working. It's not returning any
> results at all.
> So I researched about it and found out that I should check the full text
> index of Sharepoint Database
> I did and found out that item count is 0 and size is 0MB so I tried
> rebuilding the catalog but
> I get this Error 7608
> An unknown full-text failure (8007007e) occurred in function EnumCatalogs
> on fullt-text catalog.
> So I did further research and tried creating a full-text catalog for a
> database i just created for testing purposes.
> But still the same error when I tried to build a full text catalog.
> then I found Nick Porter's suggestion via google:
> http://spaces.msn.com/members/nickpo...ew&_c=blogpart
> and found out that I need to reinstall SP3a/SP3.
> and so I did, however, during the first few steps (after checking the
> licensing agreement)
> I get asked for which user I want to use (Windows Account/sa?) so first I
> tried using the windows account (it's an admin domain account - which was
> used when SP3 was initially installed) then it would say Validating
> User...and it took a very looooong time for the installer to do that. It
> took an hour just to validate the user to the point that it seemed like
> the system had hung up already. But of course I waited because I just
> couldnt cancel the installation...only to get an Access Denied Error. So
> the installation aborts by itself and nope the installation did not even
> reach the copying installation files point -- just until validating user.
> Then one service account I use for Sharepoint gets locked out. The
> sharepoint service account is different from this sql doman admin account.
> Then when I tried to open the Enterprise Manager, it takes a really long
> time to open the database folder then it hangs.
> So our tech support admin recommended that I restart the server. Then
> everything was working well again (thank goodness) except for the full
> text search. It still gives me the error and I don't want to risk trying
> it again until I find out what went wrong to the reinstallation procedure
> of SP3a.
> Any ideas how I can solve my full text search problem?
> Thank you.
>
>
|||Hi Hillary,
Thank you for your reply, I just checked out the article and verified my
settings, and nothing worked.
Although there was one file that was mentioned in the article that's called
mssadm.exe
which i tried to search and found two of them in the my computer, one under
the Sharepoint Portal Bin Folder
and one in the MSSearch folder...so maybe there's a conflict? but am not
really sure...what do you think?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eYPyWdanFHA.4028@.TK2MSFTNGP10.phx.gbl...
> Did you review this kb article?
> http://support.microsoft.com/default...b;en-us;295772
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Abi Sabado" <abisabado@.gmail.com> wrote in message
> news:Oh3x3bZnFHA.3900@.TK2MSFTNGP09.phx.gbl...
>

full outer join

hello
i know that this post is not related to asp.net forum but if anyone can help me.
i have made three sql tables called table1,table2 and table3.
each one contains primary field called employeeid
table1 contains in addition to the primary a field callled field1.
table2 contains in addition to the primary a field callled field2.
table3 contains in addition to the primary a field callled field3.
the first time table1 contains one record
employeeid field1
---- --
1353 abc
the second table contains no data
the third table contains also one record
employeeid field3
---- --
1353 def
i have made a query :
select field1,field2,field3 from table1
full outer join table2 on table1.employeeid=table2.employeeid
full outer join table3 on table2.employeeid=table3.employeeid
the result is :
field1 field2 field3
abc null null
null null def
when i delete the record from the first table and put it in the second empty table:
the result :
field1 field2 field3
null abc def
i need to understand the results ?
i know that the outer join will get the rows from the both tables,but the results how can i get i don't understand
thank you for the help

The results you are getting is because OUTER JOIN defaults mathematically to a NULL so you need to use the ISNULL function with your replacement value. And I cannot remember now but OUTER JOIN have fixed table placement in the query to get expected results. BTW strange things happening with OUTER JOIN is normal. Hope this helps.

FTS not always case insensitive

Hello

I have a couple of questions about case-sensitivity. Mostly it seems to work, that mean the FTS is not case sensitive. With the following strings, FTS seems not to get the right records. I'm running sql server 2005, noise-words files are empty

I've inserted two rows with the following strings

First Row : b&c

Second Row : B&C

When running a query with contains (field1, 'b&c') or contains (field1, 'B&C'), I only get the first row. The only chance to get the second row is to run the query with contains (field1, ' "B&C" '), but FTS doesn't return the first row...

Any idea how to get both rows without enumerating all the possibilities ? Accent-sensitivity doesn't change the behaviour, tried both.

With normal words, i.e cake, microsoft, it seems to run well.

Thanks for support

Hello

I have another problem, which is probably caused by the german word breaker.

Say you have the word "Krüger", first letter is capital, you can search with a contain-clause "krüger", "Krüger" and also "Krueger", but a search for "krueger" with the first letter not a capital, while the word has a first letter as capital doesn't retrieve the row.

Umlaut processing by the word breaker is case-sensitive.

|||

Hello

Found a solution, uppercase the search conditions will retrieve the data :-)

Thought would probably interest anyone...

Regards