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?