Purge does not work
From Swivel Knowledgebase Wiki
Contents |
Overview
Removing PINsafe deleted users using the Purge function fails.
Prerequisites
PINsafe 3.5
PINsafe 3.6.3275
PINsafe 3.6.3369
Symptoms
Error Log Message:
0 users have been permanently deleted from <repository name> repository.
Solution
On the PINsafe Administration console select User Administration. Ensure that All Repositories is not selected by selecting the repository from which users should be permanently deleted then click on Purge. Select the State Deleted and verify if any deleted users are present. If deleted users are present, select the repository they are members of, click on Purge, click on User Sync then check the State again.
There is a bug in PINsafe 3.6.3275 that prevents deleted users being purged from the database. There is however a workaround by turning off the purge function so that the users will be removed straight away rather than being marked as deleted. To use the work around and remove all users that are not found in the repository:
On the PINsafe Administration Console, select Repository, then the Repository name required. Set the "Mark users as deleted" option to No.
Then run a manual user sync, which will remove the deleted users. You can then turn the option back on as required.
Note: There is a bug in PINsafe 3.6.3369 where if you select All Repositories from the User Administration page, then the Purge operation doesn't find any users. If you select the AD repository instead, then Purge should work.
Exception occurred during database access, exception: java.sql.SQLException: Subquery returns more than 1 row
When an Active/Active PINsafe is out of synchronisation, the users may be marked as deleted on both PINsafe instances and this may prevent them being purged. Ensure the databases are synchronised.
