I have a document showing twice in a view. The column A is showing to be different. When I go into the doc 1, that field is incorrect (Column A). The contents of the doc are exactly same for doc 1 and doc 2. Only difference is the column A are showing different values in the view.
The doc id values are exactly the same for both docs. If I try to delete one doc, it puts a cross against both docs.
Any ideas whats happened here?
Subject: Duplicate doc - same id
Does Column A have some sort of calculation that could be producing a multiple value and the view is set to show multiple values as seperate rows on the view?
Subject: RE: Duplicate doc - same id
No, clumn A is just picking up a standard text field called phone.
If I look at the field values in doc properties, the phone field contains ‘7878’ on both docs, whereas on the view one doc is showing ‘2345’ and the other ‘7878’.
But they appear to be one and the same doc.
Subject: RE: Duplicate doc - same id
So when you select (using the checkmark) on one both show the check mark?
When you look at the document properties do you just see 7878. IS there a replication conflict? Do you see a $Conflict field?
Subject: RE: Duplicate doc - same id
Yes, when I check one, both show checkmark.
In doc properties, the phone field is showing as 7878 on both docs. In the view, the column A which should display the phone field is displaying different values.
There is no $Conflict field on either field.
I suspect that the doc was edit at some stage which produced some kind of corruption in the view/doc. I have re-indexed the view but it has made no difference.
Subject: RE: Duplicate doc - same id
Clearly this IS the same document. I think the view is somehow corrupt, what I would suggest is you recreate the view (maybe just column A) and see if it still happens.
Before that, check this one last thing. For Column A, what does the last tab show? Is it the field name (as shown below) or a $## (which is normally the column number) or something really odd like field1:field2
Subject: RE: Duplicate doc - same id
The view is not corrupted, nor is the document. This is normal behavior for a particular situation.
You have a multivalued field containing two values. This field is displayed in your “column A”. The column is set to sort and to “Show multiple values as separate entries.”
When you view the document using a form, for some reason only one of the values is visible. Possibly this is a keyword field of a type where values not in the list are not visible, or it’s a “Native OS” style of field and the field is too small to display both values (e.g. the multivalue delimiter is newline and the field is only tall enough to display one line).
You can confirm this by using the document properties dialog from a view, and look at the fields stored in the document.
Here’s a multivalued field named SPR, with two values. If the view was sorted as I describe above, it would appear in the view twice.
Subject: Duplicate doc - same id
Incidently I have edited the ‘first’ doc in the view and saved. The changes show up on both docs although column A is still different.
Subject: RE: Duplicate doc - same id
Try rebuilding the view (recreating the index). You can test the hypothesis by copying the view structure and just the faultly doc to a temporary db.