Invalid file name trying to create catelog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike B - 20 Jul 2004 16:55 GMT

I am trying to "Define full text indexing" on a table but
when it attempts to create the catelog, I get the
following error:

Execution of the full text operation failed. The
directory name is invalid.

Any ideas? I check to ensure the directory is correct.....

Mike B

Reply to this Message

Hilary Cotter - 20 Jul 2004 17:14 GMT

What is the path? Normally if the path is too long you get a very specific
error message stating that. Also are you trying to create your catalog on a
fixed disk?

Signature

Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html

> I am trying to "Define full text indexing" on a table but
> when it attempts to create the catelog, I get the
[quoted text clipped - 6 lines]
>
> Mike B

Reply to this Message

- 20 Jul 2004 17:54 GMT

>-----Original Message-----
>What is the path? Normally if the path is too long you get a very specific
[quoted text clipped - 13 lines]
>
>.

I was using the default path :

C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA

I also created a testing folder on C where the catelog
directory name would have been
C:\Tesging

Fixed disk, yes, right on the server c:

Mike B

Reply to this Message

John Kane - 22 Jul 2004 01:44 GMT

Mike,
What is the <value> for the following registry key on the server where this
problem exists?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<named_instance>\MSSQLServer
FullTextDefaultPath= <value>

Do you get the same error if you specify a specific path for your new FT
Catalog name <Cat_Address>?

There should be no invisible or un-printable characters in the above <value>
for FullTextDefaultPath. Could you use Regedit and delete the current string
and re-enter it? In the past I've had customer's who had un-printable
(un-viewable) characters in this Registry key value cause similar
problems...

Regards,
John

> >-----Original Message-----
> >What is the path? Normally if the path is too long you
[quoted text clipped - 29 lines]
>
> Mike B

Reply to this Message