KNOWLEDGE BASE

Errors: "TableauException" or "Could not find sheet with name: <SHEET>[0]" When Publishing a Workbook to Tableau Server or/and Tableau Online


Published: 28 Jul 2017
Last Modified Date: 28 Sep 2017

Issue

After publishing a workbook, one of the following errors might occur:
An unexpected error occurred. If you continue to receive this error please contact your Tableau Server Administrator. Session ID ...

Additionally for Tableau Server:
TableauException: Error finding command parameter: yqf
 
Additionally for Tableau Online: 
Could not find sheet with name: <SHEET>[0]

Environment

  • Tableau Server 10.2.2-10.2.4 and 10.3.1-10.3.2
  • Tableau Desktop
  • Tableau Online
  • Custom SQL

Resolution

Step 1

Upgrade to Tableau Desktop 10.2.5 or 10.3.3. For more information, see Upgrading Tableau Desktop in Tableau Help.

Step 2

  1. Copy the original Custom SQL without the added special characters into a text editor such as Notepad. 
  2. Remove the Custom SQL from Data Source Tab in Tableau Desktop 
  3. Re-create Custom SQL in the Data Source Tab in Tableau Desktop with the text from step 1. 
  4. Re-do any field type conversions, such as a non-date to a date/datetime field 
  5. Create worksheet and publish to Tableau Server
For more information about changing the data type of the field, see Convert a Field to a Date Field in Tableau Help. 

Cause

Special characters, such as a "<" symbol, are being injected in the Custom SQL of the data connection in Tableau Desktop, sometimes after a dimension/measure type change such as a non-date to a date/datetime. != can be used instead of <> for not equal statements in the custom SQL.

This behavior is related to a known issue (ID: 659319) that has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?