|
Home > Archive > SQL Server Full-Text Search > April 2005 > Re: Full-text indexing stars populating...never finishes...no erro
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Full-text indexing stars populating...never finishes...no erro
|
|
| Hilary Cotter 2005-04-07, 8:02 pm |
| When you run profiler does it reveal anything? Anything from the application
name PKM?
Hilary
"Trevor" wrote:
> Blast! The title should say Full-text indexing STARTS
> populating...never finishes...no errors
>
> A side note as I was doing more searching....this is a standalone box.
> No clustering.
>
> -Trevor
>
>
| |
| Hilary Cotter 2005-04-07, 8:02 pm |
| No, I would advise you to try the following:
1) run this script and then reboot.
cd "C:\Program Files\Common Files\System\MSSearc
h\Bin\"
%windir%\system32\Re
gsvr32 lcdetect.dll
%windir%\system32\Re
gsvr32 mssadmin.dll
%windir%\system32\Re
gsvr32 mssmmcsi.dll
%windir%\system32\Re
gsvr32 mssws.dll
%windir%\system32\Re
gsvr32 offfilt.dll
%windir%\system32\Re
gsvr32 %WINDIR%\System32\at
hprxy.dll
%windir%\system32\Re
gsvr32 ftsqlpar.dll
%windir%\system32\Re
gsvr32 msscntrs.dll
%windir%\system32\Re
gsvr32 mssmsg.dll
%windir%\system32\Re
gsvr32 mssmulpi.dll
%windir%\system32\Re
gsvr32 mssph.dll
%windir%\system32\Re
gsvr32 mssrch.dll
%windir%\system32\Re
gsvr32 msstools.dll
%windir%\system32\Re
gsvr32 objcreat.dll
%windir%\system32\Re
gsvr32 propdefs.dll
%windir%\system32\Re
gsvr32 srchadm.dll
%windir%\system32\Re
gsvr32 srchidx.dll
%windir%\system32\Re
gsvr32 tquery.dll
%windir%\system32\Re
gsvr32 query.dll
%windir%\system32\Re
gsvr32 %WINDIR%\Cluster\gat
hercl.dll
%windir%\system32\Re
gsvr32 nlhtml.dll
cd "C:\Program Files\Common Files\System\MSSearc
h\common\"
%windir%\system32\Re
gsvr32 mssitlb.dll
%windir%\system32\Re
gsvr32 %windir%\System32\at
hprxy.dll
2) if this fails I would try to remove and reinstall MSSearch as per
these instructions
http://support.microsoft.com/defaul...kb;en-us;827449
Trevor wrote:
> No, Nothing from PKM. Everything is from app name MS SQLEM
>
> Here's what I'm seeing from profiler...
>
> 1) select count(o.ftcatid) from dbo.sysobjects o,
> dbo.sysfulltextcatalogs f where o.ftcatid=f.ftcatid and f.name =
> N'STcomments'
> 2) select FulltextCatalogPrope
rty(N'STcomments', N'PopulateStatus')
> 3) exec sp_fulltext_catalog N'STcomments', N'start_full'
> 4) select FulltextCatalogPrope
rty(N'STcomments', N'PopulateStatus')
>
> And then nothing after that.
>
> Any ideas on what this might be?
>
| |
| Hilary Cotter 2005-04-10, 9:23 am |
| It should have been
e:\x86\FullText\ftse
tup.exe COM-SQLSERVER COM-Domain\sa_SQL 1 0 0 0 >
C:\MyFTSetup.log
Getting back to where you should be can be difficult. Try to remove it
again and reinstall it, or re-running the above command.
You might want to contact MS PSS about this one.
--
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
|
|
|
|
|