Menu
    KNOWLEDGE BASE

    Error "Data definition not valid unless solitary" When Connecting to Teradata and Using Initial SQL query

    Published: 04 Jan 2018
    Last Modified Date: 24 Apr 2018

    Issue

    When connecting to Teradata data source when using an initial SQL query in "Query Banding and Initial SQL" in the connection window, the following error might occur if there are extra spaces into the Initial SQL statements: 

    "Data definition not valid unless solitary"

    Environment

    • Tableau Desktop
    • Teradata
    • Initial SQL statement

    Resolution

    Option 1

    Upgrade to Tableau Desktop 2018.1. For more information, see Upgrading Tableau Desktop in Tableau Help.

    Option 2

    Review the Initial SQL statement and remove trailing spaces before all crlf (carriage return - line feed) outside brackets

    Cause

    This behavior is related to a known issue (ID: 725088) which has been fixed in a recent release of Tableau Desktop. 
    Did this article resolve the issue?    
    PRINT THIS PAGE
    Related Links
    Attachments

    All Support

    SUPPORT BY PRODUCT
    TOOLS & DOWNLOADS
    INFORMATION
    ASSISTANCE