To resolve this issue:
Switch it to "On Task Completion" for both the User Sync and the Account Sync.
This will speed up the certification process and prevent the certifications from hanging.
To release the hung certifications:
The hung certification process is most likely due to the blocking timeout value that is currently set.
DEBUG [ims.tmt.events] CertifyRoleEvent IMSEvent.setAttribute next_state:invalid >> null
ERROR [ims.tmt.events] Failed to get task session org.jboss.util.NestedSQLException:
No ManagedConnections available within configured blocking timeout ( 5000 [ms] ); - nested throwable:
Modify this timeout value in the Task Persistence Config File.
Bump up this value and re-test. (Start by raising the value to 8000).
The file to modify is here:
If you do not have a test environment in which to test, the tasks would need to be rerun.
We also recommend running the Task Persistence clean up script:
C:\Program Files\CA\IAM Suite\Identity Manager\tools\db\taskpersistence
There is a SQL query that needs to be run.
It is a two part process:
First there is a script to mark the completed tasks (which can be edited to mark pending tasks as well).
Then there is a SQL procedure to run (to delete the pending and completed tasks).