Identity Governance Universe Import Stuck at 0% Progress

Products

• CA Identity Manager

Issue/Introduction

This article addresses scenarios where a Universe import in Identity Governance fails to progress, remaining at 0% for an extended duration. This is typically indicative of a database resource constraint preventing the import job from initializing correctly.

 

Environment

Identity Governance 14.x

Cause

The Identity Governance database (ig_db) has reached the capacity of its 'PRIMARY' filegroup, preventing the import process from allocating the necessary space for execution contexts.

• Universe import remains stuck at "0% In Progress" in the dashboard.
• Workpoint checks may appear successful, and restarting the JBOSS service does not resolve the issue.
• Log files contain an org.springframework.jdbc.BadSqlGrammarException indicating an allocation failure:

  com.microsoft.sqlserver.jdbc.SQLServerException: Could not allocate space for object 'dbo.qExecutionContexts'.'U_qExecutionContexts' in database 'ig_db' because the 'PRIMARY' filegroup is full.

Resolution

The Identity Governance database (ig_db) has reached the capacity of its 'PRIMARY' filegroup, preventing the import process from allocating the necessary space for execution contexts.

Resolution: To resolve this issue, you must increase the available disk space for the database:

1. Verify Database Space:

   • Work with your Database Administrator (DBA) to verify the current space utilization of the ig_db database.
   • Confirm that the 'PRIMARY' filegroup is indeed full or has reached its growth limit.

2. Increase Available Space:

   • Add Files: Add a new file to the 'PRIMARY' filegroup to allow for immediate expansion.
   • Configure Autogrowth: Ensure that existing files in the 'PRIMARY' filegroup have 'Autogrowth' enabled and that the drive hosting the data files has sufficient physical storage available.
   • Cleanup: Alternatively, if applicable, delete unneeded files or drop unnecessary objects in the filegroup to reclaim space.

3. Restart and Resubmit:

   • Once the DBA confirms that additional space is available and the filegroup can grow, restart the Identity Governance application server.
   • Resubmit the stuck Campaign/Universe import.