Share all details related to your problem, including any error messages you may have received.
We are facing issue in the AD aggregation tasks. Attached screenshots for reference. I gone through few blogs and there its stated to remove the issue causing managed attribute from iiq. Here in my case the managed attribute called HASH causing the violation since its tagged to some other group in AD. When another group is getting assigned the same hash value its shows duplicate key not allowed and constraint violation. Kindly assist me.
We are facing issue in the AD aggregation tasks. Attached screenshots for your reference. I gone through few blogs and it was asked to remove the issue causing managed attribute from iiq. Here in my case the managed attribute called HASH causing the violation since its tagged to some other group in AD. When another group is getting assigned the same hash value its shows duplicate key not allowed and constraint violation. Kindly assist me.
you a constraint violation on the manage attribute table.
The reasons could be a lot.
You need to check the DB status, try to maintenance the DB(rebuild index, shrink …). Alse, you can check on DB the existing key of the errors are present in the logs, meybe in DB are present some corrupted data.
I checked in DB where another AD group has the same hash value and as per the error log the group mentioned in the task result are also trying to assign the same hash value since these group are member of the AD group from which the hash values are trying to duplicate.
good, now the next step is understating why, but its very difficult; you can check the db, maybe are present some locks on this table.
I think something gone wrong in one moment; you can try to rebuild the indexes but i think the only solution is delete the duplicated records and recreate.
be careful with this operation, before make an analisys, check if those entitlement are assigned on some identities, see if the duplicated record are actually the some object and talk with your dba admin(could be him/her can find the problem on db)
@enistri_devo So the issue is the AD groups listed in the task result page are nested ones under another AD group from. The nested groups are trying to use the same hash value as in the parent group, this is why I am getting the constraint violation error in the result. Kindly confirm if removing the nested groups is the only solution for this issue or do we have any other way to resolve this?
I have even removed the error causing managed attributes from the debug page, but the tasks are still getting failed. Please confirm if nested groups are allowed here in AD because that is one causing the issue
