KNOWLEDGE BASE

Error "Incorrect data type binary, getting expected spatial type" When Creating Extract


Published: 30 Nov 2020
Last Modified Date: 30 Nov 2020

Issue

When creating an extract of a data source that contains a spatial join within a logical table which has a relationship with another table, the following error may occur:

Unable to complete action
Incorrect data type binary, getting expected spatial type.
Error Code: CA8336D0
Unable to create extract


OR

Incorrect data type 9, getting expected 7 type.

Environment

  • Tableau Desktop
  • Spatial File

Resolution

As a possible workaround, instead of using a relationship between the logical table containing the spatial join and the other table(s), use a join between the physical tables:
  1. Open the affected workbook in Tableau Desktop.
  2. On the Data Source page, click the relationship line between logical tables, and note how the relationship is defined (for example, take a screenshot).
  3. Right-click the table that does not contain the spatial join, and select 'Remove'.
  4. Double-click the logical table containing the spatial join to open it.
  5. From the Connections pane on the left, select the connection containing the table to be added back, and then add the required table by double-clicking it, or dragging it to the canvas. Inspect the join clause to make sure it reflects how you want to connect the tables. 

Cause

This behavior is related to Issue ID 1127432, which is being addressed by Tableau development team.

Additional Information

For more information about creating joins between physical tables from different databases, see this document.
Did this article resolve the issue?