Full Text Index changes a Text field to number field on local replica's

HCL Domino Domino Forum
1

We seem to have a strange issue when creating local replica’s of our dB’s. We have a field called projectno which is text. When we create a local replica, and then create a new full index on it, we can no longer look for [projectno] = “1758”, since it thinks it is a number, we get the query is not understandable.

We have deleted the index and re-created it several times. This does not happen on all machines, just some of them.

Anybody run into this, and if so, what was your solution.

Cheers,

John

2

Subject: Full Text Index changes a Text field to number field on local replica’s

Hi,

if you look at this particular document in your local replica, what is the property of your field?

Text or number?

You have deleted the index. Form where? The OS or via the Index Tab?

Delete it from the OS and recreate it.

JYR

3

Subject: RE: Full Text Index changes a Text field to number field on local replica’s

Thanks for the reply,

It is a text field when looking at the properties.

Will try to delete from the os, and re-create the index. Will post again.

John

4

Subject: RE: Full Text Index changes a Text field to number field on local replica’s

You can’t just look at one document. When you create the full-text index originally, it processes all the documents. The first time it sees an item with a given name, it associates that datatype with that item name. So if you have even one document with the wrong datatype, it can affect the indexing for all your documents (if you’re unlucky). You’ll have to write an agent to correct the docs with the wrong value.

5

Subject: RE: Full Text Index changes a Text field to number field on local replica’s

Andre,

As it turns out, that is what the problem was. Somehow some old forms had the field as a number.

We’ll fix the documents, replicate and then delete and recreate the index to see if that fixes everything for our users who have the local copies.

Thanks, John

6

Subject: RE: Full Text Index changes a Text field to number field on local replica’s

Well we deleted the ft folder, and still it comes up numeric. In any case, the developer had said that all the fields are text, but I will right an agent just to confirm.

BTW Andre, that is what I had said, although I was not positive.

As always I write my results back here,

Cheers John