Issue Migrating DT_NTEXT from Salesforce to Dynamics 365

  • 106Views
  • Last Post 16 July 2021
0
votes
Vile Rantala posted this 17 June 2021

Hi,

Currently I'm trying to migrate the values from a DT_NTEXT field from Salesforce to Dyn365CRM, which destination field has the same format, but when the Skyvia update process is finished, i got the following error.

"Type Mismatch: Type of Attribute: MY_DT_NTEXT_FIELD is: System.Byte[]. However, Type of passed-in value is: Microsoft.Xrm.Sdk.OptionSetValueCollection"

The process used is an update, after the account record is created. so i'm not sure how to proceed to get that field migrated.

Attached Files

Order By: Standard | Newest | Votes
0
votes
Sabina Bashuk posted this 22 June 2021

Hello Vile,

Thank you for contacting Skyvia Support!

Could you please share the link to your package, so that we could check?

0
votes
Vile Rantala posted this 24 June 2021

Thanks Sabina, there you go

https://app.skyvia.com/#/81236/packages/131325

 

0
votes
Sabina Bashuk posted this 29 June 2021

Hi Vile,

Sorry for the delayed reply.

Are the fields you mention in Salesforce and Dynamics custom fields, or standard? 

0
votes
Vile Rantala posted this 30 June 2021

Well, on dynamics it is a custom field, and probably also in Salesforce, i've tried with insert and upsert action, then with update, but no luck at the moment.

0
votes
Sabina Bashuk posted this 02 July 2021

As we can see, in the package 131325 the data is being imported into the Dynamics table Account.

The error says that the column MY_DT_NTEXT_FIELD has type byte[], and you are trying to insert OptionSetValueCollection

  1. We couldn't find the MY_DT_NTEXT_FIELD in the mapping. Have you edited the Account column?
  2. Our provider forms the OptionSetValueCollection for inserting in the field with type MultiSelectPicklist. Have you created not a text field?

Our Technical Team's assumption is the following: there was a MY_DT_NTEXT_FIELD field with an initial type MultiSelectPicklist, and then you have changed the field type, but haven't updated the Dynamics connection's metadata. So, the Skyvia Import package continued to process the MY_DT_NTEXT_FIELD field as MultiSelectPicklist.

 

We recommend you to refresh the Dynamics connection's metadata and edit the package mapping

0
votes
Vile Rantala posted this 07 July 2021

Hi Sabina,

 

This maybe is misunderstanding, "My_DT_NTEXT_FIELD" is an example, the exactly fields are the following:

From Salesforce account table is "Customer_Logo__c" (DT_NText)
In Dyn365 on account table is "rbe_customerlogo" (DT_NText)

0
votes
Mariia Zaharova posted this 07 July 2021

Hello Vile,

 

This is Mariia from Skyvia Support. I will handle this case with you.

 

Yes, we can see these fields in the package content. Could you please specify what exactly data type is set for the rbe_customerlogo field in Dynamics CRM (check this directly via Dynamics CRM UI)?

Also, did you try performing Sabina's suggestion - clear metadata cache and check the mapping? Whether the same issue still occurs?

 

We are looking forward to your reply.

0
votes
Vile Rantala posted this 08 July 2021

 

Hi Maria,

 

 

 

Thanks for your response, "rbe_customerlogo" is an image type field in dynamics.

 

0
votes
Mariia Zaharova posted this 09 July 2021

Hello Vile,

 

Thank you for your response.

One additional question - what data type is set to the Customer_Logo__c field in Salesforce and what data is stored there? Are you sure that these values must be sent to the "rbe_customerlogo" field?

 

Thank you for providing this information. This should help to detect the reason for the issue.

 

Best regards,

Mariia

0
votes
Vile Rantala posted this 09 July 2021

Hi Maria,

Thanks, for your response, currently based on the documentation provided by Salesforce partner, the "Customer_Logo__c" field data type isthe following

Rich Text Area(32768)

0
votes
Mariia Zaharova posted this 16 July 2021

 Hello Vile,

 

Thank you for your response.

We have reproduced the issue and are working on finding possible solutions.

The issue occurs because Salesforce returns data from the Rich Text Area field in the following format:

<img alt="User-added image" src="https://c.na95.content.force.com/servlet/rtaImage?eid=a0C2G000013yuw0&amp;feoid=00N2G00000CC9Mf&amp;refid=0EM2G000001b0ay" style="height: 193px; width: 500px;"></img>

I.e. data is not returned as an image, the data is returned as a general information about image with a source link.

As soon as any news is available I will let you know.

 

Best regards,

Mariia

Close