You receive the "An error occurred while retrieving the list of users in Active Directory" error message when you try to create a new Microsoft CRM user by using the Microsoft CRM Deployment Manager tool (899188)


The information in this article applies to:

  • Microsoft CRM 1.2

Beta Information

This article discusses a Beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.

No formal product support is available from Microsoft for this Beta product. For information about how to obtain support for a Beta release, see the documentation that is included with the Beta product files, or check the Web location where you downloaded the release.

SYMPTOMS

When you try to create a new Microsoft CRM user by using the Microsoft CRM Deployment Manager tool, you receive the following error message:
An error occurred while retrieving the list of users in Active Directory. For more information, Contact your system administrator.
Additionally, all the following Error events are logged in the Application log of the computer that is running Microsoft CRM Server.

Event 1 Event source: DMSNAPIN
Event category: None
Event ID: 0
Date: date
Time: time
Type: Error
User: N/A
Computer: computername
Description: DELETE statement conflicted with COLUMN REFERENCE constraint 'contract_template_contracts'. The conflict occurred in database 'Company_Name_MSCRM', table 'ContractBase', column 'ContractTemplateId'. Event 2 Event source: DMSNAPIN
Event category: None
Event ID: 0
Date: date
Time: time
Type: Error
User: N/A
Computer: computername
Description: System.ArgumentException: Type of value has a mismatch with column typeCouldn't store <1708> in VersionNumber Column. Expected type is Byte[].
System.ArgumentException: Type of value has a mismatch with column type at System.Data.Common.ObjectStorage.Set(Int32 recordNo, Object value) at System.Data.DataColumn.set_Item(Int32 record, Object value)
--- End of inner exception stack trace ---
at System.Data.DataColumn.set_Item(Int32 record, Object value) at System.Data.DataRow.set_Item(DataColumn column, Object value) at System.Data.DataRow.set_Item(String columnName, Object value) at Microsoft.Crm.Tools.ImportExportXml.XmlCustomization.PublishEmailTemplates(String strXmlDoc, Object status).Event 3 Event source: DMSNAPIN
Event category: None
Event ID: 0
Date: date
Time: time
Type: Error
User: N/A
Computer: computername
Description: ExecuteNonQuery Error : DELETE statement conflicted with COLUMN REFERENCE constraint 'contract_template_contracts'. The conflict occurred in database 'Company_Name_MSCRM', table 'ContractBase', column 'ContractTemplateId'. The statement has been terminated. , StackTrace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) Event 4 Event source: DMSNAPIN
Event category: None
Event ID: 0
Date: date
Time: time
Type: Error
User: N/A
Computer: computername
Description: The following information is part of the event: Source: .Net SqlClient Data Provider Number: 547 State: 0 Class: 16 Server: DSBS2K3 Message: DELETE statement conflicted with COLUMN REFERENCE constraint 'kb_article_template_kb_articles'. The conflict occurred in database 'Adventure_Works_Cycle_MSCRM', table 'KbArticleBase', column 'KbArticleTemplateId'. The statement has been terminated. Procedure: Line: 1. Event 5 Event source: DMSNAPIN
Event category: None
Event ID: 0
Date: date
Time: time
Type: Error
User: N/A
Computer: computername
Description: The following information is part of the event: ExecuteNonQuery Error : DELETE statement conflicted with COLUMN REFERENCE constraint 'kb_article_template_kb_articles'. The conflict occurred in database 'Adventure_Works_Cycle_MSCRM', table 'KbArticleBase', column 'KbArticleTemplateId'. The statement has been terminated. , StackTrace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

CAUSE

This problem occurs if you have the Microsoft .NET Framework 2.0 Beta release installed on the computer that is running Microsoft CRM 1.2 Server.

RESOLUTION

Microsoft CRM has a fix for this problem that is part of a cumulative update. The cumulative update information is described in the following Microsoft Knowledge Base article:

904435 Update Rollup 2 is available for Microsoft CRM 1.2

MORE INFORMATION

For more information about the terminology that is used to describe Microsoft product updates, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Modification Type:MinorLast Reviewed:7/25/2006
Keywords:kbMBSadministration kbMBSMigrate kbQFE kbHotfixServer kbpubtypekc KB899188 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.