Response documents deleted from the database

HCL Domino Domino Forum
1

Hi all,

Issue

The response documents are getting deleted often.

Database Details:

  1. Database Replicates with many region servers with different replication formulas.

  2. Database size is about 17 GB.

  3. There are about 12000 users accessing the database globally.

  4. The deletions are occuring in a random fashion. Only some of the response documents in a particular parent are getting deleted.

  5. We also find repeated deletions happening in some cases. (i.e., after we restore the deleted documents again into the database, they get deleted)

We tried looking into the following that may cause deletions and could not trace out the exact reason for the deletions.

  1. Users Manual deletions

  2. Coding

  3. Replication

Please suggest me some way to track the source that causes deletion of the documents.

(Whether the document is lost due to coding or replication or any other reasons)

2

Subject: Response documents deleted from the database

Hi,

Technote #:1086649

How to analyze questionable deletions in a Notes database A customer states that there have been deletions in a database, such as a mail file, that no one has actually deleted. Is there a way to analyze if the documents were in fact deleted, and is it possible to find out what the source of the deletion was?

Who can delete documents in the ACL?

Is there any code that delete a document (Ex: doc.Remove)

Do you have soft deletions enabled?

Any replication formula?

Is it specific for a single region?

Specific type of documents?

JYR

3

Subject: RE: Response documents deleted from the database

Hi,

Thanks a lot for the response. I went through the link and we are trying to implement the debug parameters in notes.ini file.

  1. Soft deletions is not enabled in the database.

  2. This issue is specific to one region only.

  3. Only one type of response documents are getting deleted. The parent document has response documents created using different forms. But the documents created using a particular form “Response_RD” is only getting deleted.

  4. The Replication formula exists for the database. But the reported documents are not getting replicated to other regions.

  5. We have a code that moves the parent and child to another database , once it is approved. But the reported deletions occur in the documents that are not approved. Moreover, the moving is done only by the user manuallly hitting the button. We have also asked the users not to move any documents till we find the root cause for the issue.

  6. After the document is deleted we searched the deletion stubs in the database to make sure that the document is deleted.

  7. There are many groups in the database who have the deletion access. Also many scheduled agents are running in the database.

As there are many activities running in the database, we need some way to track what is the source of deletion (code or replication or other specific reasons). Is there any way to code a separate agent to record each deletion and source of deletion in the database.

4

Subject: RE: Response documents deleted from the database

Is there any way to code a separate agent to record each deletion and source of deletion in the database.

You can use Audit manager form Openntf.org

Also, i would enabled soft deletions

JYR