KNOWLEDGE BASE

Error "ORA-01406: fetched column value was truncated" Creating Extract When Using Custom SQL


Published: 23 Jun 2014
Last Modified Date: 27 Feb 2017

Issue

When you are using custom SQL in your data source connection and you try to create an extract , the following error might occur:
 
Oracle database error 1406: ORA-01406: fetched column value was truncated
Unable to create extract

When connecting to the Oracle data base and creating an extract without custom SQL, the extract completes successfully.

Environment

  • Tableau Desktop
  • Oracle
  • Custom SQL

Resolution

As a workaround, rather than using Custom SQL, use the same code to create a materialized view directly in the database. 
 
Did this article resolve the issue?