AD Group aggregation Failure after SailPoint upgrade to 8.3

Which IIQ version are you inquiring about?

*8.3

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

  • We’ve recently upgraded SailPoint from v8.1 to 8.3. Since the upgrade when we run AD group aggregation, it fails for a few groups with the error stated below.
  • Exception during aggregation of CN=xyz,OU=xyz,OU=xyz,DC=xx,DC=xxxx,DC=com. Reason: org.hibernate.exception.ConstraintViolationException: could not execute statement. We also disabled the “Enable Native Identity Change Event propagation” checkbox under Miscellaneous settings.
  • Any suggestions on this error are appreciated. Thanks in advance.

Hi @LalithyaReddy ,
Can you check the logs and get the stack trace for this error?

Thanks

@LalithyaReddy

You can try to remove the Maximum deleted group threshold value as it could cause the duplication of groups. After the task gets successful, you can revert.

Another reason might be UUID thing, check below thread :

Getting error on Active Directory group aggregation after 8.4 upgrade - Identit
yIQ (IIQ) / IIQ Discussion and Questions - SailPoint Developer Community

Thank you @pravin_ranjan for the suggestion. We will try and keep you posted on the results.