KNOWLEDGE BASE

Error: "Internal Error..." When Attempting to Join Tables That Use Unsupported Data Types


Published: 25 Apr 2017
Last Modified Date: 18 May 2017

Issue

When attempting to join tables that include columns using unsupported data types, such as HIERARCHYID, GEOMETRY, or VARBINARY, the following error might occur: 

Internal Error - An unexpected error occurred and the operation could not be completed

Environment

  • Tableau Desktop 10.2.0
  • Microsoft SQL Server, Oracle

Cause

This behavior is related to a known issue (ID: 628169) that has been fixed in a later version of Tableau Desktop. 

Additional Information

Tableau does not have corresponding data types for HIERARCHYID, GEOMETRY, or VARBINARY, and such columns are ignored by Tableau - they do not show up in View Data or in the data preview window.
Did this article resolve the issue?