2022
Error while processing the state
<b>Error Trace :</b>com.avankia.appmashups.engine.conversion.ConversionException: Error on upsert entity: Cannot convert the literal '02/13/2018' to the expected type 'Edm.DateTimeOffset'. at com.avankia.appmashups.mscrm.adapter.MSCRMODataWriter.write(MSCRMODataWriter.java:190) at com.avankia.appmashups.engine.conversion.ConversionProcessor$OutputGroup.processElement(ConversionProcessor.java:1607) at com.avankia.appmashups.engine.conversion.ConversionProcessor.processState(ConversionProcessor.java:762) at com.avankia.appmashups.engine.conversion.ConversionProcessor.execute(ConversionProcessor.java:603) at com.avankia.appmashups.engine.conversion.ConversionProcessor.execute(ConversionProcessor.java:438) at com.avankia.appmashups.engine.conversion.ConversionProcessor.execute(ConversionProcessor.java:195) at com.avankia.appmashups.engine.conversion.ConversionProcessor.execute(ConversionProcessor.java:139) at com.avankia.appmashups.quickbooks.QBWebConnectorSvcSoapImpl$QBConnectorAdapter.processPDL(QBWebConnectorSvcSoapImpl.java:286) at com.avankia.appmashups.quickbooks.QBWebConnectorSvcSoapImpl$QBConnectorAdapter.run(QBWebConnectorSvcSoapImpl.java:238) at java.lang.Thread.run(Thread.java:745)
Solution:
The Odata date format in the mapping doesn’t support MM/dd/yyyy format we have to use yyyy-MM-dd instead.
Example from the mapping
datedelivered-DATE(VALUE("TxnDate"),"yyyy-MM-dd","MM/dd/yyyy")
Should be changed to
datedelivered-DATE(VALUE("TxnDate"),"yyyy-MM-dd","yyyy-MM-dd")