DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Eugenio

Saved on

compared with

New Version 2

changes.mady.by.user Eugenio

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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")