When changing the Purge Settings in Presentation Server Console | Resource Manager | Summary Database | Configure to set a defined retention period from previous Indefinite retention period, records will only be purged from the date that purging has been set. All records previous to the purge setting will remain in the Summary Database indefinitely.

The records that remain in the Summary Database indefinitely do not have a SESSIONEND date, and so are not removed by the purge process.

To identify the records that do not have a SESSIONEND set (Oracle query):

SELECT * FROM sdb_session WHERE sessionend is null AND sessionstart < to_date('30-JUN-2007') ORDER BY sessionstart ASC;

To set SESSIONEND to SESSIONSTART (Oracle query):

UPDATE sdb_session SET sessionend = sessionstart WHERE sessionend is null AND sessionstart < to_date('30-JUN-2007');

The records will then be removed by the nightly purge process.