IdentityIQ certification generation appears to hang

3 Kudos

Symptoms

While running a certification generation in IdentityIQ, the task appears to hang.

Diagnosis

Certification generation may take a significant amount of time to complete, depending on the scope of the certification and the system resources available. There is no readily available trace to report progress on this task. To verify a certification generation is proceeding as expected, inspect the certification artifacts to see if they are updating.

Solution

As the certification generation proceeds, it updates the spt_certification_entity SQL DB. By comparing the number of entries in the table at different times, you can verify the task is progressing.

Open a terminal/command prompt.
Launch the IIQ Console utility.
Run the following SQL Query:
> sql 'SELECT COUNT(*) FROM spt_certification_entity'
After several minutes, run the same command again.
Compare the results from each execution. If the count has increased, the certification generation is proceeding as expected.

If you confirm your certification generation is hanging, you may be able to pinpoint the cause by partitioning the certification generation.

In the case of Manager Certifications, you can use the available partitioning setting to allow IdentityIQ to partition the certification. If it i any other kind, you must manually separate the process into multiple, smaller certifications.

Partitioning the certification may remediate the issue, or help identify the specific point the hang occurs to assist in further troubleshooting.

Additional steps

You can also use IdentityIQ logging to verify certification generations are progressing as expected. Edit your log4j.properties to include the class log4j.logger.sailpoint.api.certification.BaseCertificationBuilder=all

IdentityIQ certification generation appears to hang