SPR

Technote

Problem:
This issue occurs because an internal database header setting for the soft
deletion time is being written as 0 unexpectedly when creating new databases or
when upgrading older databases which do not have the setting previously. It is
a regression issue which occurred as an unintended effect of the fix for the
issue described in the technote, "Users change Soft Delete timeout but
documents still removed from Trash folder after 48 hours" (#1169807).

This issue was reported to Quality Engineering as SPR# KYOE6B9929, and was
fixed in Domino 6.5.4 Fix Pack 2, Domino 6.5.5, and Domino 7.0.

Excerpt from the Lotus Domino Release 6.5.4 Fix Pack 2 fix list (available at
http://www.ibm.com/developerworks/lotus):

Database
SPR# KYOE6B9929 - Fixed a problem where mail in the trash folder was removed
after reopening a mail database. The problem is that if a new mail database is
created, the amount of time that the soft deletes are retained is set to 0. So,
if a user deletes a message, then closes and reopens their mail, the soft
deleted message will be deleted from the Trash. The problem will always occur.
Previously created mail databases will not exhibit this problem. As a
workaround, the user can manually change their soft delete expire time in their
database properties, which will overwrite the initial setting in the database."
This regression was introduced in 6.5.3 FP1.

Refer to the Upgrade Central site for details on upgrading Notes/Domino.

Workarounds

To avoid the issue with new mail files in the future:

Modify the deletion hours setting in the mail template. This can be done using
either the Notes Client or the Domino Designer client. Open the database,
select File > Database > Properties, and go to the Beanie tab in the InfoBox
for Database properties that pops up. Set the "Soft delete expire time in
hours" setting to a different value (the default is 48) and click the arrow to
accept the new value. Now reset the setting back to the desired value.

To avoid the issue with existing mail files:

Method #1: In the User Interface
The users should change the soft deletion expire time to a new value and then
back to the original or desired value. For example, if the value is 48 (the
default), set it to 49 and then back to 48. To access the expire time, select
the database and from the menu select File > Database > Properties. Go to the
Beanie tab (last tab) in the InfoBox for Database properties. Set the "Soft
Delete Expire Time in Hours" property to a different value and click the arrow
to accept the new value. Now reset the setting back to the desired value and
click the arrow.

Method #2: Programmatic change to the mail template
Add the following code to the mail template's Database Script PostOpen event.
The Database Script design element is listed under Other > Database Resources
in Domino Designer.

Note: This workaround requires that the owner of the mail file (or a delegated
calendar user) have Designer or Manager access to the database; otherwise, they
will not have the proper rights to reset the property. If the owner does not
have this access level then someone who does can simply reopen and close the
database using a Notes Client; the code will reset the soft delete expire time
property.

Note: Simply disabling and re-enabling using the SetOption method does not
result in the header entry being updated as desired.

Dim hours As Integer
Set db=source.Database
If db.getoption(dbopt_softdelete) Then
hours%=db.undeleteexpiretime
'The below line ensures that errors will not occur when users with Editor
or lower rights trigger the code.
On Error Resume Next
db.undeleteexpiretime=hours%+1
db.undeleteexpiretime=hours%
End If
More >