Re: 2005 Full Text Error
- From: "John Kane" <jt-kane@xxxxxxxxxxx>
- Date: Tue, 8 Nov 2005 22:10:04 -0800
You're welcome, Simon,
Great news! Although, its a shame that you don't have the FTS log file as
that could of been helpful info for helping others troubleshoot similar
problems in the future with SQL Server 2005 as I'm very positive there will
be more such situations! <G>
Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:43E21A03-80DA-4AFA-B1E5-48B0BE52D2C7@xxxxxxxxxxxxxxxx
>I did have problems with the install. I couldn't install using the GUI,
> though it worked from the command line. I also installed FT seperatly
> (from
> command line) after the original install. I think the install problem was
> being casued by installing DTS (I'll explain later).
>
> Anyway, I unistalled both all 2005 components (again from command line as
> the GUI errored). Then reinstalled SQL, and FT & DTS is one go from
> command
> line, this failed - it was unable to start the scheduled task on the 2nd
> node
> because of a permissions error - though looking through the logs I could
> see
> setup.exe failed with a fatal exception.
>
> So I tried the install again with just SQL and FT from command line - it
> worked perfectly and FT appears to be fine now. I still can't install
> DTS -
> but I guess I'll just have to live without it.
>
> Unfortunatly I didn't keep the FT logs - I cleared all folders before
> reinstalling. I do however have all my install logs (there's a lot of
> them).
> But I think this will probably go down as "one of those things". After all
> the product was only released yesterday.
>
> Thanks for you help anyway.
>
> Simon
>
>
>
>
> "John Kane" wrote:
>
>> Simon,
>> An interesting error - "Property DefaultPath is not available for
>> FullTextService This property may not exist for this object, or may not
>> be
>> retrievable due to insufficient access rights". Could you post the file
>> or
>> text from the SQFT log file (SQLFT0000900005.LOG) where 9 is the dbid and
>> 5
>> the FTCatid under the \MSSQL.1\MSSQL\LOG directory where you have SQL
>> Server
>> 2005 installed? Did you have any problems installing SQL Server 2005?
>> This
>> may be an installation problem or something else, so perhaps, more info
>> will
>> be recorded in the SQLFT log file.
>>
>> Thanks,
>> John
>> --
>> SQL Full Text Search Blog
>> http://spaces.msn.com/members/jtkane/
>>
>>
>> "Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:065E5E9B-FC6E-4621-9CF8-10EB282BB633@xxxxxxxxxxxxxxxx
>> > I'm having problems creating a new Full Text index in 2005. My
>> > environment:
>> >
>> > Windows 2003 SP1 Ent Cluster (Active/Active)
>> > SQL 2000 SP4 on one side SQL 2005 on the other.
>> >
>> > When I go to create a new index using the GUI, as soon as I click on
>> > "new
>> > Full-Text Catalog..." I get this error:
>> >
>> > Property DefaultPath is not available for FullTextService
>> > '[LON-IMSSQL01\IMS]'. This property may not exist for this object, or
>> > may
>> > not
>> > be retrievable due to insufficient access rights.
>> > (Microsoft.SqlServer.Smo)
>> >
>> > But the screen does load and it does let me create the catalogue with
>> > no
>> > problems.
>> >
>> > Then I go to add a table and column. When I press OK I get this error:
>> >
>> > Full-text crawl manager has not been initialized. Any crawl started
>> > before
>> > the crawl manager was fully initialized will need to be restarted.
>> > Please
>> > restart SQL Server and retry the command. You should also check the
>> > error
>> > log
>> > to fix any failures that might have caused the crawl manager to fail.
>> > (Microsoft SQL Server, Error: 7644)
>> >
>> > Press OK to that error and the FT Cataloge screen closes and I get this
>> > error:
>> >
>> > Index was out of range. Must be non-negative and less than the size of
>> > the
>> > collection.
>> > Parameter name: index (mscorlib)
>> >
>> > If I go back into the catalogue screen The Eligilble colums box appears
>> > as
>> > a
>> > white box with a nice big red cross over it.
>> >
>> > There are no errors logged in the SQL event log or windows log. I have
>> > rebooted, restarted, failed over and re-installed full text using:
>> >
>> > start /wait D:\2005\servers\setup.exe /qb REINSTALL=SQL_FullText
>> > INSTANCENAME=IMS REINSTALLMODE=M
>> >
>> > But still I get the same problem. Can someone please help me!?!?
>> >
>> > Thanks
>> > Simon
>>
>>
>>
.
- References:
- Re: 2005 Full Text Error
- From: John Kane
- Re: 2005 Full Text Error
- From: Simon
- Re: 2005 Full Text Error
- Prev by Date: Re: hyphens change between w2K and w2K3 ?????
- Next by Date: Re: High CPU over extended time period
- Previous by thread: Re: 2005 Full Text Error
- Next by thread: High CPU over extended time period
- Index(es):
Relevant Pages
|
Loading
