Retention table not cleaning up

  • 7005509
  • 27-Apr-2012
  • 10-Dec-2013

Environment

Novell Data Synchronizer Mobility Pack 1.2.2

Situation

Deleting users from both the connectors does not clean up the entries in the Retention Table for that deleted user(s).
Items in Retention Table but not in cache have to be cleaned up manually.
Retention Table entries continues to grow.
Retention Table entries never shrinks.

Resolution

This is reported as being fixed for Data Synchronizer 2.0, which will be available Fall 2013.

Workaround:
Is to manually clean up the tables.  One way to do it is to execute the following command from the Data Synchronizer database:  delete  from retention where "cacheID" not in (select "cacheID" from cache);

Cause

Maintenance is not properly cleaning up the Retention database.

Additional Information

Executing the following command from the Data Synchronizer database can help identify how many entries are in the Retention database: select count(*) from retention where "needsDelivery" = '1';