使用复制活动将数据复制到Crm中的Ownerid字段时获取问题 [英] Getting Issues while copying data to Ownerid field in Crm using Copy Activity

问题描述

您好，

将数据从Sql Server表复制到Dynamics Crm Entity OwnerId字段时出现异常。 sql中列的数据类型是Uniqueidentifier。我们得到的例外是 

{" errorCode" ;："2200"，"消息"："故障发生在'接收'一侧。 ErrorCode = UserErrorUnsupportedAttributeType，'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，Message =
属性类型&'Owner& of field& ownerid&不支持。，Source = Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin，'"，" failureType"：" UserError"，" target"：" CopyFrom_AzureSql_to_Crm"
}

所有者guid已经从Crm Instance本身获取，但在这种情况下我们也得到相同的例外。我完全糊涂了问题是什么.. ??我已经尝试过使用nvarchar更改sql表列中的数据类型，同样的问题。

请帮助我。

解决方案

这是以下主题的副本。

https://social.msdn.microsoft.com/Forums/en-US/a2f63b44-c5b9-4a26-a40e-ee62996a3bce/getting-issues-while-copying-data-to-ownerid-field-in- crm-using-copy-activity？forum = AzureDataFactory

Hello,

Iam getting an exception while copying data from Sql Server table to Dynamics Crm Entity OwnerId field. The datatype of column in sql is Uniqueidentifier. Exception we are getting is 

{ "errorCode": "2200", "message": "Failure happened on 'Sink' side. ErrorCode=UserErrorUnsupportedAttributeType,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The attribute type 'Owner' of field 'ownerid' is not supported.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'", "failureType": "UserError", "target": "CopyFrom_AzureSql_to_Crm" }

The owner guid has been taken from Crm Instance itself, but in this case also we are getting same exception. Iam totally confused what the issue is..?? I have tried with changing datatype in sql table column with nvarchar also, getting same issue.

Please help me out here.

解决方案

This is a duplicate of the below thread .

https://social.msdn.microsoft.com/Forums/en-US/a2f63b44-c5b9-4a26-a40e-ee62996a3bce/getting-issues-while-copying-data-to-ownerid-field-in-crm-using-copy-activity?forum=AzureDataFactory

这篇关于使用复制活动将数据复制到Crm中的Ownerid字段时获取问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！