Article ID: 899188
Article Last Modified on 7/25/2006
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:
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
Keywords: kbmbsadministration kbmbsmigrate kbpubtypekc kbqfe kbhotfixserver KB899188