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.
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);
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';