What does this error mean in Active Directory Account Aggregation?
Source that has been running for years is failing Account Aggregation with this error today
anything in logs after enabling debug in VA?
@iamnithesh
I have debug the issue and read few documents. I have read Sailpoint communitity documents. sharing my thoughts validate your self before implementation.
The active directory connector account aggregation primary key constraint error you are experiencing is likely due to duplicate rows in the checksum table. The checksum table is used to hold deltas for delta aggregation, and the error suggests that there is more than a single entry with the identical native_identity, which should be unique.
This issue might occur if:
You have duplicate accounts within your Active Directory environment.
Delta aggregation was broken or failed on a previous run.
There is an inconsistency in the local database accessible to the connector for the change tracking.
To resolve the problem, you can try the following steps:
Perform a complete aggregation instead of a delta aggregation. This will re-load everything and may rectify any inconsistencies.
Clear the delta aggregation state. You can do this by adding the following entry on the application’s debug page:
After adding this entry, do a full aggregation. After that, remove the entry so that future delta aggregations will work properly.If the issue continues to be a problem, you may need to review your Active Directory environment for any duplicate accounts or discrepancies that would cause this to happen.
Thanks @NandanaSailpoint
I think you are missing a line after
Nithesh Rao, You can try it in ISC to see if it’s possible to set it using Postman — I’m not sure if it works
do the needful. I have taken harbor pilot help. (as part of debugging process) Please double check before implementing.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.