Refresh role indexes task is taking more than 20 hours

IdentityIQ (IIQ) IIQ Discussion and Questions
, ,
1

Which IIQ version are you inquiring about?

Version 8.3

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

Hi Sailors,

“Refresh role indexes” task is taking more than 20 hours to complete.
Always one of the task server is dedicated to run this job the whole day almost.

As this is a pre-defined task, not sure how we can speed up this task.

Result that I see, after task completion

Refresh Role Indexes - 1377 Attributes
Role Indexes refreshed - 46639

there are more than 47k bundles in the system and its going to increase in future.
What can be done to decrease the task duration ?

3

Hi @vinnysail did you see any new exception in syslog when this task running?

4

syslog exceptions are there for many other transactions, not able to check specifically when this task is running if any exceptions raised.

5

I am not sure but sometime, rebuild index also help in some case.

doc here : How to rebuild IIQ Database Indexes - Compass (sailpoint.com)

6

Hi @pravin_ranjan,
At Microsoft sql server rebuild indexing is done everyday so there is no issue in that space.
Will raise a case with sailpoint and understand what else could be the issue.
Thanks for your response.

7

that make sense, thanks Vinod

Check BundleProfileRelationUpgrader is enabled during upgrade, you will see in SystemConfiguration. hoping it should not linked with your issue.

BundleProfileRelationUpgrader rerun? - Compass (sailpoint.com)

8

Hi @pravin_ranjan,
This feature is disabled on the task servers as we are not using it. Will check and confirm back on the same.

9

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.