question

MIM avatar image
MIM asked

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...
sql-server-2008-r2clustererror-messagefull-textrepair
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Is there any further information in the SQL Server log files?
0 Likes 0 ·

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
Check the path to the Full Text Data folders that are configured in the registry.
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MIM avatar image MIM commented ·
No further info in sqlserver logs. Sorry to be dense, how do I check the ft path in the registry?
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
According to Google, you need to open your favourite Registry editor (regedit), and browse / navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\\Setup\FullTextDefaultPath where "instance id" is the, erm, name of your SQL Server instance that you're interested in.
0 Likes 0 ·
MIM avatar image MIM commented ·
Thanks Thomas, FullTextDefaultPath recorded in registry matches location recorded in Database Properties..Files..Path and observed location of ndf file on server.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.