Hello! I created a flow in Tableau Prep that won't generate an output (a data source published to Tableau Server) and is repeatedly giving me the same error message. Please see below.
System error: AqlProcessor evaluation failed: [Teradata][ODBC] (10470) Data conversion not supported.
When this error first appeared, I didn't have any data conversion steps in the flow. All fields were meant to remain as they were, and I planned on making any necessary changes to formatting and data types in Tableau Desktop once it was an established connection.
So, I searched online and came across a few Tableau Community questions with the same error message and it indicated that this error occurs when there are duplicate rows. Even after removing duplicate rows with the new aggregate step, the error persisted.
The error only appears when I try to run the flow. Before I actually hit "Run", the flow has no errors listed in the "Alerts" corner icon, giving me the false hope that all is well.
Some additional information about the flow that may be helpful:
- The connected data source for this Flow is 1 company database through Teradata (I have the proper drivers installed) and uses 4 custom SQLs (each appears as 1 icon in the Flow workspace) to generate the data we need.
- There are no errors in the actual Custom SQL queries. They have been tested individually and run perfectly.
- There are 3 unions (pairing up 2 SQLs at a time, then creating one last union of those 2 resulting tables to form 1 final table) in the whole flow.
- One of the columns in 2 of the Custom SQLs' queries (these 2 are paired up for a union before the final, third union) is NULL all the way down.
- There are 3 geographic fields in the final data source and they have all defaulted to a String-Abc data type: a Latitude field; a Longitude field; and a Location field (not sure if this is a Lat or Long measurement, but it's just half of what would be needed to actually map it)
- The goal is the have the final data source will be published to the Tableau Server, refreshed daily, and connected to a published Tableau workbook-
Unfortunately, I can't share the actual flow because it's for work, but any advice would be greatly appreciated. Thank you!
