x

How to resolve ss2008r2 errors 30064 and 17063?

Message text 30064, (severity 17): "SQL Server failed to set security information on the full-text FilterData directory in the FTData folder. Full-text indexing of some types of documents may fail until this issue is resolved. You will need to repair the SQL Server installation." And "Error: 50000 Severity: 16 State: 1 Error 4860, Level 16, State 1, Procedure -, Line 1, Message: Cannot bulk load." etc. Can find no answer anywhere. DB is installed on clustered instance running on windows server 2008 r2 os. Fulltext catalogue is installed on shared drive with system dbs; datestamp shows updated; Active Full Text Catalogue report shows status Available. No user complaints received...
more ▼

asked Sep 18, 2012 at 11:30 AM in Default

MIM gravatar image

MIM
10 1 1 1

Is there any further information in the SQL Server log files?
Sep 18, 2012 at 11:46 AM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
Check the path to the Full Text Data folders that are configured in the registry.
more ▼

answered Sep 18, 2012 at 11:48 AM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

No further info in sqlserver logs. Sorry to be dense, how do I check the ft path in the registry?
Sep 18, 2012 at 01:01 PM MIM

According to Google, you need to open your favourite Registry editor (regedit), and browse / navigate to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance id>\Setup\FullTextDefaultPath
where "instance id" is the, erm, name of your SQL Server instance that you're interested in.
Sep 18, 2012 at 03:05 PM ThomasRushton ♦
Thanks Thomas, FullTextDefaultPath recorded in registry matches location recorded in Database Properties..Files..Path and observed location of ndf file on server.
Sep 18, 2012 at 03:23 PM MIM
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x593
x93
x75
x46
x4

asked: Sep 18, 2012 at 11:30 AM

Seen: 1837 times

Last Updated: Sep 18, 2012 at 04:21 PM