Menu
    KNOWLEDGE BASE

    "Custom SQL relation refers to a non-existent parameter" when using < and > in Tableau Prep Custom SQL

    Published: 21 Aug 2018
    Last Modified Date: 21 Nov 2018

    Issue

    When defining Custom SQL in Tableau Prep that contains the characters '<' and '>' in this order, the following error may occur: 
     
    Error in input 'Custom SQL'. Can't connect to datasource <datasource>. An error occurred while communicating with the data source.
    Custom SQL relation refers to a non-existent parameter: < text>

    For example if the Custom SQL contains a clause such as' WHERE Order ID <15 and Order ID>1, the error message will be:
     
    Error in input 'Custom SQL'. Can't connect to datasource <datasource>. An error occurred while communicating with the data source.
    Custom SQL relation refers to a non-existent parameter: <15 and Order ID>

    Environment

    Tableau Prep 

    Resolution

    To resolve this issue, upgrade Tableau Prep to version 2018.3.1 or later.
     

    Cause

    When '<' is used first and then the '>' after it in a Custom SQL statement, Custom SQL is not using them in a proper manner.

    This behavior is related to known issue ID 815619 and was resolved in the 2018.3.1 release of Tableau Prep.

    Did this article resolve the issue?    
    PRINT THIS PAGE
    Related Links
    Attachments

    All Support

    SUPPORT BY PRODUCT
    TOOLS & DOWNLOADS
    INFORMATION
    ASSISTANCE