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: 16 Jan 2019

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