Solved

Workday WQL Error

  • 22 December 2023
  • 1 reply
  • 81 views

Userlevel 1
Badge

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.

icon

Best answer by Ethem Q 22 December 2023, 22:21

View original

1 reply

Userlevel 4
Badge

Hi @joshphillipssr 

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.

Reply