Remove / Delete / Purge Identity Intelligence ETL Job Stuck in 'Create'

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

When an Identity Governance ETL job remains in the 'create' state, it may prevent new ETL processes from executing. This article provides instructions to purge the stuck job and restore functionality.

Environment

• Product: CA Identity Governance
• Release: 14.x, 15.x

Cause

The ETL workflow becomes stuck in a 'create' state due to an interrupted process or an error during execution. Because CA Identity Governance enforces a single-process execution limit for ETL tasks to prevent data corruption, a stuck job effectively locks the service. Without manual intervention to purge this process, the system is unable to initiate new ETL jobs.

Resolution

To remove the stuck ETL workflow and permit new processes to run, the system configuration must be modified to allow the purging of ETL tasks:

1. Navigate to Home > Administration > Settings > Property Settings.
2. Filter for the term etl to locate the relevant configuration settings.
3. Modify the following three settings to true:
   • purge.etl.allowPurgeCompleted
   • purge.universe.purgeETLProcesses
   • purge.etl.allowPurgeAll
4. Navigate to the Workflow list within the administration console.
5. Locate the ETL workflow that is currently stuck in the 'created' state.
6. Select the option to purge the identified workflow.

 

Once the stuck workflow is removed, the system will allow the initiation of a new ETL process.

 

Additional Information

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on your respective region.