Azure AD aggregation is running slow

[LalithyaReddy (Lalithya V)]

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.

We are aggregating Azure AD in SailPoint IIQ 8.4 and enabled exchange configuration to pull EXO_LitigationHoldDate and EXO_LitigationHoldEnabled attributes in account schema. But the account aggregation is very slow and is taking more than 14hrs+.

When observed logs during aggregation we are getting exception stating “ERROR QuartzScheduler_Worker-1 sailpoint.object.LockInfo:455 - Aggregation lock expired for Identity: xxxxx”.

Kindly let me know if anyone faced this issue. Appreciate your help.

[Remold (Remold Krol)]

It looks like the issue is on the IIQ - database side.

Are the aggregations of other applications running ‘normal’?

Can you test updating the database maxTotal settings in the iiq.properties file, by doubling the number of open connections?

##### Data Source Properties #####
dataSource.maxWaitMillis=10000
dataSource.maxTotal=50
dataSource.minIdle=5

If dataSource.maxTotal=50, then test it with 100 (maybe also test it with 25).

– Remold

[drosenbauer (Devin Rosenbauer)]

It’s partly just the nature of the connector - it has to make a zillion web services calls, sometimes one per user, to a SaaS service with a rate limit.

[LalithyaReddy (Lalithya V)]

Hi @Remold ,

I don’t see any issue with other aggregation tasks.

We already have data source properties as stated below:

Data Source Properties

dataSource.maxWaitMillis=10000
dataSource.maxTotal=1000
dataSource.minIdle=5

Thanks
Lalithya V.