Using CData Sync Cross Platform with Workday WQL connection. Some queries work successfully, but a bunch fail with this message:
[0] Received error from Workday: Invalid WQL query: !**! This error occurred during a request to calculate the field !**!, for instance !**!.. Cause: com.workday.exceptions.ExternalFieldException: The Increment or Decrement Date field, !**!, has encountered a blank date..
Thanks.
Best answer by Ethem Q
View original
Hi
I am not immediately sure what exactly is causing the error for you, however I know that we have had other users report that the inclusion of certain columns in the allworkers object has caused similar issues for them in the past.
That being said, you may find setting the connection property MetadataFilters to 'Calculated' helpful (MetadataFilters=Calculated). This setting will automatically filter out all of the calculated fields and should eliminate these kind of issues. You can read more here:
https://cdn.cdata.com/help/JWJ/jdbc/RSBWorkday_p_MetadataFilters.htm
In case the above suggestion does not work for you and you keep facing this error, there might be a need to take a look at the job logs for further investigation so it would be better to reach out to our support team at support@cdata.com or submit a ticket with support here: https://www.cdata.com/support/submit.aspx.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers