Microsoft KB Archive/938485

= Error message when you use the Data Synchronization tool in the Microsoft Dynamics CRM Connector for Microsoft Dynamics GP: &quot;System Error: Cannot resolve collation conflict for equal to operation&quot; =

Article ID: 938485

Article Last Modified on 8/15/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0
 * Microsoft Dynamics CRM Connector for Microsoft Dynamics GP, when used with:
 * Microsoft Dynamics CRM 3.0

-



SYMPTOMS
When you use the Data Synchronization tool in the Microsoft Dynamics CRM 3.0 Connector for Microsoft Dynamics GP, you receive the following error message:

System Error: Cannot resolve collation conflict for equal to operation. Calling int_DataSync_ProcessCRMUomSchedules.

This problem occurs if you use the Data Synchronization tool to display records for linked entities.



CAUSE
This problem occurs if you set the default collation to a value that differs from the &quot;SQL_Latin1_General_CP1_CI_AS&quot; value when you installed the Microsoft Dynamics CRM Connector for Microsoft Dynamics GP.

During the setup of the Microsoft Dynamics CRM Connector, you cannot change the collation of the runtime tables to a value that differs from the &quot;SQL_Latin1_General_CP1_CI_AS&quot; value. When you first use the Data Synchronization tool, temporary tables are created that use the default collation of the integration database. If this default collation differs from the &quot;SQL_Latin1_General_CP1_CI_AS&quot; value, you receive a collation conflict when you run the synchronization.



RESOLUTION
To resolve this problem, delete the temporary sync tables. Then, change the collation of the integration database. To do this, follow these steps:  Click Start, click Run, type services.msc, and then click OK. In the Services pane, stop the following services:  BizTalk Service BizTalk Group: BizTalkServerApplication BizTalk Service BizTalk Group: MBSIntSendHost  Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.  In the query window, run the following statement. select 'drop table [' + name + ']' from sysobjects where name like 'DataSync%' </li> Copy the output of the statement in the Result pane, and then run each line.</li>  In the query window, run the following statement. alter database CRMIntegration_number collate SQL_Latin1_General_CP1_CI_AS Note In this statement,  is a placeholder for the actual integration database number. </li> Restart the services that are stopped in step 2.</li></ol>

Keywords: kberrmsg kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB938485

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.