Menu
    KNOWLEDGE BASE

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

    Published: 23 Jun 2014
    Last Modified Date: 07 Jul 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. 
     

    Additional Information

    Materialized Views

    A materialized view is a “select query” performed on the data source and the result set is stored as a table in the database. The materialized view can be kept in sync with database updates.
    Did this article resolve the issue?    
    PRINT THIS PAGE
    Related Links
    Attachments

    All Support

    SUPPORT BY PRODUCT
    TOOLS & DOWNLOADS
    INFORMATION
    ASSISTANCE