Access Review Loading Time is Slow!

[ashish_sharma]

Which IIQ version are you inquiring about?

8.4p1

Please share any images or screenshots, if relevant.

Please share any other relevant files that may be required (for example, logs).

loggers shows a lot of activity from CertificationUtil.class on reviewed item (Which is default class ootb)

Share all details about your problem, including any error messages you may have received.

We have received numerous complaints from managers experiencing significant slowness during access reviews. Our last campaign was on version 8.2p2, and we have since upgraded to 8.4p1. However, during testing in a lower environment, we are encountering similar slowness when opening access reviews.

Points to Note:

• It takes considerably more time to open access reviews that consist of Roles compared to those with only Entitlements.
• The loading time extends further when the certifier has previously made some decisions on items and is trying to review those decisions. Reviewed items take longer to load, while undecided items load relatively quickly.
• The number of items doesn’t seem to significantly affect the loading time, although larger numbers of items do increase the time. Even access reviews with just 5 items that include Roles take a considerable amount of time.

Has anyone else experienced similar slowness in their access review campaigns? If so, how did you resolve the issue?

[pravin_ranjan (Kumar Ranjan)]

@ashish_sharma which type of this cortication is ? check if some performance tunning will help and run idx rule to see any idx issues.

Individual Active Directory group certification - Compass (sailpoint.com)

Partitioning Best Practices - Compass (sailpoint.com) - here you will get some information

Also try to enable logs of class : sailpoint.certification to see if it will give more details.

logger.cert.name=sailpoint.certification
logger.cert.level=info

[enistri_devo (Emanuele Nistri)]

Hi @ashish_sharma,

when you detect this behavior in sailpoint could be cause froms some reason like:

• Another heavy proces is running
• Infinity loop
• Low server resource
• High number of item(in your case workItem or certificationItem)
• Missing\Corrupted\Fragmented Index on DB for table that managed this object

Check the resource usage when you open this page on UI\Task\DB server and the logs to verify errors\warning or if something is running

[ashish_sharma]

Hello @pravin_ranjan
We are running Manager certification via Targeted Certification.
Tried looking at different options like partitioning and all which didn’t seem to help. Like i mentioned the log on CertificationUtil shows activity on getting bundle info.
In addition to the points above, the loading time affects only reviewed decision that was approved. The undecided items (tab) opens without delay. The review tab if it has only revoked item, it opens without delay.