Active Directory Connector Error "Configuration.SQL: dbo.GroupSelectByUID returned more than one (4266531)

The following error is logged in the Event Log:

Event Type: Error
Event Source: Active Directory Connector
Event Category: None
Event ID: 0
Date: 01/12/2009
Time: 13:48:08
User: N/A
Computer: ArchiveManager
Description:
Configuration.SQL: dbo.GroupSelectByUID returned more than one result.

Duplicate entries for one or more Groups exist in the Archive Manager database.

Disclaimer: The following resolution contains SQL Queries. SQL Queries are provided "As is" for reference purposes. Quest accepts no liability for issues arising from incorrect usage of SQL Queries. Please ensure that full and current database backups exist before making any changes to the Archive Manager database, if in doubt please contact support.

To remove the duplicates, follow this procedure:

1. Identify the duplicates using the following SQL Query:

USE ArchiveManager
SELECT UID,
COUNT(UID) AS NumOccurrences
FROM "group"
GROUP BY UID
HAVING ( COUNT(UID) > 1 )

The result may look simliar to the output below:

3DE27E6D-11C6-4CDD-8B00-98057BE08770 2

2. Use the following queries to find more information on the duplicate groups:

select * from "group" where UID = '3DE27E6D-11C6-4CDD-8B00-98057BE08770'

The result may look simliar to the output below:

4595 Contractors Active Directory 3DE27E6D-11C6-4CDD-8B00-98057BE08770 2
6598 Contractors Active Directory 3de27e6d-11c6-4cdd-8b00-98057be08770 2

The query shows that there are two entries for the "Contractors" group, the record with the oldest GroupID should be amended.

3. Amend the record with the oldest groupID to change its UID. The query below increases the last digit of the UID in the oldest group record by one:

update "group" set UID = '3DE27E6D-11C6-4CDD-8B00-98057BE08771' where groupID = '4595'

Restart the Actice Directory Connector service once all updates are complete.

Changed Indexes IX_Group_UID to unique