KNOWLEDGE BASE

Error "Error in parameters for command 'connection-custom-sql-ui'/bad value: connection-name" Editing Custom SQL


Published: 02 Feb 2018
Last Modified Date: 02 Feb 2018

Issue

When you try to edit custom SQL for a datasource, the following error occurs: 
Error in parameters for command 'connection-custom-sql-ui'/bad value: connection-name

Environment

  • Tableau Desktop 10.4.0
  • Custom SQL

Resolution

Rename the datasource in question, removing all special characters:
  1. Open a worksheet within the affected workbook
  2. In the Data pane, on the left, right-click on the datasource in question and select Rename
  3. Rename the datasource, ensuring only basic alphanumeric chartacters are used

Cause

Tableau Desktop was unable to parse a special character, such as ç or ó

Additional Information

A similar error can be triggered with other actions in Tableau Desktop, such as publishing.  While the command section of the error may be different, if bad value: connection-name is in the error, then the resolution may still be to rename the datasource, removing special characters. 
Did this article resolve the issue?