-
Title
Error: ActiveDirectoryConnector - AfterMail.Common.Util.SearchResultsNotUniqueException: dbo.Mail -
Description
New users in Active Directory are not being imported into Archive Manager and the Archive Active Directory Connector.exe.log displays the following:
INFO ActiveDirectoryConnector - AfterMail.Common.Util.SearchResultsNotUniqueException: dbo.MailStoreSelectByDistinguishedName returned more than one result.
at AfterMail.CommonClasses.SqlHelper.ExecuteDataRow(SqlCommand sqlCommand)
at AfterMail.BusinessLayer.MailStore.FindDistinguishedName(String distinguishedName)
at AfterMail.DirectoryConnector.ActiveDirectoryConnector.GetMailStoreByHomeMDB(String homeMDB)
at AfterMail.DirectoryConnector.ActiveDirectoryConnector.GetMailBox(DirectoryEntry rootEntry, DirectoryEntry mailBoxEntry, SqlConnection sqlConnection) -
Cause
Duplicate Distinguished Names for Mail Stores exist in the Archive Manager SQL Database.
-
Resolution
1) Use ADSI Edit to verify that duplicate Distinguished Names for Mail Stores exist.
This information can be found under the following similar location in ADSI Edit:
Configuration > Services > CN=[Organisation Name] > CN=Administrative Groups > CN=[Admin group name] > CN=Servers > CN=[Server Name] > CN = Information Store > CN = [Storage Group Name]
Export the information displayed here.
2) Run the following SQL query:
use ArchiveManager
select * from mailstore
Export the information displayed here.
Send the exported data from ADSI Edit and the SQL Query to support@quest.com to create a new case and have an Engineer review the extent of duplicate Distinguished Names for Mail Stores.