CODEWITHSUNDEEP
lotus-noteslotus
UDAYA KUMAR Chidambaram
UDAYA KUMAR Chidambaram

Reputation: 1

Lotus Notes documents - Gets corrupt & Field Info Tab is empty

I have a notes database and recently we are having an issue across random documents. Users gets error "The linked document cannot be found in the view" when they try to open a document from a view. I am not sure how to reproduce this issue.

I tried the below options to reproduce it, but no luck:

  1. Attaching a document link to one of the Rich text field and deleting the link's target.
  2. Attaching a file as a link and deleting the file in the target.

I am not seeing any pattern with the documents having the issue. The documents accessed few days ago, which was not accessed for more than 2 years also becomes corrupt like this.

Other details:

Since we have a daily backup of the database, we restore the document from one of the restored copy in which it was working fine.

Upvotes: 0

Views: 363

Answers (2)

Emma Leis
Emma Leis

Reputation: 2900

I think those documents have actually been deleted, and two things make me think that:

  • You say in a comment that rebuilding the view makes the documents disappear. I'd expect this only if the documents no longer exist.
  • I have in the past had LotusScript code doing view lookups which produced documents that I knew to be deleted, but the NotesDocument.IsDeleted property was False and the NotesDocument.Items property was Empty (i.e. no fields in the document). This is consistent with your saying the Field info tab is empty.

I'd check if any user action or code could delete documents. You say there are no scheduled agents, but maybe some user action could run code which deletes documents, or some users with the Delete privilege in the database ACL could be directly deleting documents using the Delete key on the keyboard.

Also check the database properties -> Info tab -> User Detail. This should show if there are recent deletions, but the record is probably limited to the last week or less.

Upvotes: 1

D.Bugger
D.Bugger

Reputation: 2359

A guess: did you try re-indexing the view? Shift-F9?

It could also be in the form, or even the view. What if ...

  • you open the same document from a different view?
  • you remove some, many or all fields from the form, do you still see the error?

Upvotes: 1

Related Questions