2022
Following error appears when trying to sync the records.
SOQL statements cannot be empty.
Solution:
In Salesforce connector, under DBSync account, an EndPoint URL may be pointed to 32.0 instead of 39.0.
So, need to reconnect the Salesforce to set 39.0. Once done, try to sync again.
After reconnecting Salesforce under DBSync account. The End Point URL changed to 39.0
Following error appears in DBsync logs:
Error while initiating Writer Adapter:
<b>Error Trace :</b>com.avankia.appmashups.engine.conversion.ConversionException: com.avankia.appmashups.engine.conversion.ConversionException: Error Compiling: 07cc3bc5-5b94-42ea-804f-104955136ad4_map.xml = public Object VALIDATEROW() throws Exception{String custName = String.valueOf(getCustomer(VALUE("orderId"), VALUE("customer/companyName")));return.
804f-104955136ad4_map.xml, Line 4,Column 46: Class "SC" has no method named"getCustomer".
Solution:
Additional user defined javascript function needs to be added for the project Skuvault and Quckbooks in order to sync Sales Orders and Purchase Orders
So please, contact DBSync support. Or, you can send an email to support@mydbsync.com to raise the ticket to get it resolved.