We have encountered the issue that” Some data with the value of hex 0x01 - 0x1f “ when store in crm system.(which can be stored in the client's database including MongoDB, Oracle etc.)


Error Meaasge:

Failure happened on 'Sink' side. ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147220872, error message: Invalid character in field 'xxxx': '', hexadecimal value 0x1A, is an invalid character..,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,''Type=System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]],Message=The creator of this fault did not specify a Reason.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'


After testing in the out of box environment that confirmed the data contains hex decimal formatting could not be saved in the CRM system

This issue is quite serious as client's data may not fit to import into CRM due to its limitation, we need Hex decimal format data can store in the crm system