Account Aggregation taking Time

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

Version 8.4

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

Hello Experts,

I need one help for Account Aggregation. I have 15 oracle applications , 1 Active Directory and 1 Oracle Unified Directory.

I have created single Account aggregation task and includes all the application. now i noticed that it is taking 8-10 hours to execute. any idea how to improve performance and is this correct way to aggregate accounts.

Please help on this and let me know alternative solutions.

Thanks

2

Hi Niket,
you can arreglate a lot of setting.

First of all, you can unmark the Disable optimization flag in the task(if it is marked).

Later, you can use the delta aggregation, for AD you active directly to the task(better if use an aggregation task only for AD); for ORACLE you must to check if the delta is active and possibile foreach DB.

Also, you can set the partition, if you more than one task server, and set the number of threads in each server, follow those guides:
https://community.sailpoint.com/t5/Other-Documents/Partitioning-Best-Practices/ta-p/74964

https://community.sailpoint.com/t5/Other-Documents/Java-JVM-Memory-Tuning-Guide-for-IdentityIQ/ta-p/79202

At least, you can review the connetors configuration, maybe its possible optimize the querys.

I suggest to you a status check of Sailpoint DB and schedule a maintenance plan.

3

I have not selected Disable optimization flag options and we have enabled the partition but still getting 8-10 hours to execute.

I have added all the Applications in single account aggregation task. I am not sure is this correct way to execute or not.

4

ok, you need the make a little analysis. You need know the executions time of each applications and works on it.
You can launch the aggregation task for each single applications and see the times, maybe is only one needs all these hours.

For AD, you can active the Delta aggregacion and set multiple serchDNs in the connetor for improve the partitioning.
Same, for Oracle connetors, you can set the logic of partitioning in the connetor.

How many account are you reading for each app?

If you have an IIQ service, please check the performance of the network between SP, IIQService and AD. For the DBs check the performace of the querys.

5

If you have included in same task mostly this will go in a sequential manner, if you don’t have any dependency between these apps aggregation, try creating separate tasks for each app and see how much it takes

6

Few things to check .

  1. What these task take to complete individually if ran standalone ?
  2. is the single account aggregation is sequential or parallel?
  3. Arre these task partioned ?
7
  1. What these task take to complete individually if ran standalone ? - yes this is running within time frame.
  1. is the single account aggregation is sequential or parallel? - Need to check.
  2. Arre these task partioned ? - Yes
8

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