I've got a strange problem with full text index.
This problem only occurs on one application. This application is an inventory database for cell phones.
When entering "Sony" into the full text search bar it returns only 5 of about 100 possible hits with "Sony Ericsson" (with and without blank). One hit has a blank the other 4 haven't. I tried fuzzy search, word variants and wildcards to no avail. Database properties tell me that the index is current. This behaviour happened with this database on all tested clients. At least one was 7.0.2 (user) and one was 8.5.3 (admin - I don't know why)
-> corrupt view index
Now come the strange things:
I tried to delete the Index from database properties and from Admin client -> nothing happens . Not even an error message (enabled debug_ftv_index, but still).
load updall -X does nothing not even an error.
I can delete the index on file system, though (and afterward with the adminclient so that it is not recreated). Then the search works fine (without index that is). When I create the index again the search does not work, again (?!).
I tried a fixup from server console and it tells me: "This function is not supported on this operating system" although it is a Windows Server 2008 R2 and it works for other applications.
I tried creating a new replica on another server, but replica creation just fails without any kind of error message - just does not do it... although replication works for other applications. Even if I create the replica by just copying the file on filesystem *Autsch* to the other server, replication does not work as if it just were not there (yes, yes, consistency checks and so - all done without error).
Is it just me or is this database completely "kaputt"? How can I repair it? (no, backup is not an option, because it is not clear since when the problem exists)
Thank you for any thought,
Problem with corrupt Full text inde... (Manuel Nientit 3.May.13)
Feedback number WEBB97CHLA created by Manuel Nientit on 05/03/2013
. . Have you (Barry Shapiro 3.May.13)
. . . . Not yet (Manuel Nientit 6.May.13)