I am getting the following error.

00000a94.00000fb4::2004/02/29-05:22:25.943 Microsoft Search Service
Instance <SQL Server Fulltext>: An error occurred in the configuration
monitor for instance <SQL Server Fulltext>: 800700b7 - Cannot create a
file when that file already exists.

It knocks MSS offline. I have cluster services configured not to
failover and to bring it back online but I want to get it fixed.

Google, microsoft and usenet searches come up empty.

W2k w/ sp3 and SQL2k with sp3+MS03-031

Any ideas?

Jason,
The error 800700b7 (Cannot create a file when that file already exists) is
somewhat unique and I'm not surprised you couldn't find this on Google, et
al.. ;-). However, troubleshooting for a related error - 80070002 - The
system cannot find the file specified. - in a SQL Server 2000 Clustered
environment *might* be helpful... Most likely for your error (800700b7), one
or more of these files exists on your failover server, but should not and
should be deleted or renamed. The issue is finding what file exists that
should be deleted...

Some of the changes which trigger these errors are:
==============================
1) Changing the FTDATA folder location.
2) Changing the SQL startup account.
3) Failover of the sql virtual server.

Reasons why these errors occur:
==================
These errors means that the data\config directory for the SQL server full
text application is not on disk at the location specified.
The mapping file is the first file it is trying to read, though, there is no
specific use for this file in SQL.
There are other files in this directory that are most likely missing and not
reported. such as noise files and the fulltext schema file.

Possible solutions &/or workarounds:
===================================
1) One workaround is to copy the FTDATA config directory
(\FTDATA\SQLServer\*.*) from another SQL instance,
and take the instance offline/online. (for error 800700b7 - compare the
files dir's)

NOTE: The FTDATA config (\FTDATA\SQLServer\Config) directory is under the
SQL install path, so it should be on the shared disk. Most likely it is the
registry key that has an incorrect value.

2) Using Regedt32, edit the following Register key and value:
HKLM\Software\Microsoft\Search\1.0\Gathering Manager\Applications\SQLServer
(REG_SZ) ApplicationPath
<ApplicationPath>\Config\gatherprm.txt

NOTE: After making this Registry change, you should failover. There are
additional files that MSSearch requires in this folder.
Additionally, you may have to grant the Cluster Service account explicit
Full Control to the above ApplicationPath's FTDATA folder.

If the above does not help, you may want to open a support case with
Microsoft SQL Server support.
Regards,
John


"Jason Massie" <jason.massie (AT) datareturn (DOT) com> wrote

one other item that helps fulltext in a cluster -

Change it's dependency to the SQL Agent - in a clean install - this stops all errors from occurring

Hi everyone, I am getting a similar error when trying to install SP3a on
the Windows 2000 Advanced server OS.
I am getting "An error occurred while creating virtual server resources
for clustering. Cannot create a file when that file already exists".

THis error is driving me crazy since I cannot make any sense out of it.
I am installing SP3a in our production environment and I need to get
this to work tonight. Any one out there with any suggestions I will
greatly appreciate it.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!