Dynamics Community Forum Thread Details

Dual Write error, map empty optionset values?

Hi all,

When writing to the Customers table in F&O, I'm getting Dual Write error messages, see below. I think this is related due to a mapping between an Optionset field in F&O and in Dataverse. When this field in F&O is empty it is creating errors, when filled it is fine. How can I add an empty value in the Value map to prevent this?

Thanks for your help!

Unable to write data to entity accounts. Writes to CustCustomerV3Entity failed with error message Request failed with status code BadRequest and CDS error code : 0x80048419 response message: Error identified in Payload provided by the user for Entity ':'

For more information on this error please follow this help link

https://go.microsoft.com/fwlink/?linkid=2195293

----> InnerException :

Microsoft.OData.ODataException: Cannot convert the literal '' to the expected type 'Edm.Int32'.

---> System.FormatException: Input string was not in a correct format.

at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)

at System.String.System.IConvertible.ToInt32(IFormatProvider provider)

at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)

at Microsoft.OData.PayloadValueConverter.ConvertStringValue(Type targetType)

at Microsoft.OData.PayloadValueConverter.ConvertValue (…)

--- End of inner exception stack trace ---

at Microsoft.OData.PayloadValueConverter.ConvertValue (…)

at Microsoft.Dynamics.Ax.Metadata (…)

at Microsoft.Crm.Extensibility.ODataV4.Primitive (…)

at Microsoft.OData.JsonLight.ODataJsonLightReader (…)

at Microsoft.OData.JsonLight.ODataJsonLightReader (…)

(messageReaderSettings, Boolean validateNullValue, String propertyName)