|Applies To||RSA Product Set: SecurID|
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.1 SP1
|Issue||A scheduled clean up job of an external identity source will not run. The job is listed in the Security Console under Administration > Batch Jobs, but the information in the Complete Date column never changes, so new scheduled clean up jobs do not run.|
Running the Clean Up Unresovlable Users option completes successfully.
|Cause||There is an old scheduled cleanup job stuck in the Scheduled Queue, which prevents new scheduled jobs of the same type from running.|
Before completing the steps below, take a backup of the Authentication Manager database (Operations Console > Maintenance > Backup and Restore > Backup Now). Make a note of the backup password used for the backup. If the backup is saved to the local Authentication Manager server, copy the backup off the server and store in a secure location.
SELECT id, name, status, error_message, created_on FROM rsa_rep.ims_batch_job;
SELECT name, id, schedule_data, status, last_updated_on, FROM rsa_rep.ims_batch_job where id='<id_captured_above>';
4. Now run the DELETE command to remove the scheduled batch job that never runs:
DELETE FROM rsa_rep.ims_batch_job WHERE id='<paste_id_from_above>';
This SQL statement removes the particular scheduled batch job that never runs, now locate any stuck scheduled cleanup batch jobs.
SELECT name, id, schedule_data, status, last_updated_on FROM rsa_rep.ims_schedule_job;
SELECT name, id, schedule_data, status, last_updated_on FROM rsa_rep.ims_schedule_job WHERE id='<Unresolvable_Users_and_Groups_id>';
DELETE FROM rsa_rep.ims_schedule_job WHERE id='<Unresolvable_Users_and_Groups_id>';
8. The database is now clean of the stuck jobs. Try to run a new cleanup.