KNOWLEDGE BASE

Error "Tableau Data Engine Error: 40460: SimpleDatabase::SelectMetadataName: expected found=1" Appending Data to Extract


Published: 18 Oct 2016
Last Modified Date: 12 Jan 2017

Issue

When you try to append data to an extract that is published as part of a workbook, the following error occurs: 
Tableau Data Engine Error: 40460: SimpleDatabase::SelectMetadataName: expected found=1 

Environment

  • Tableau Desktop 
  • Tableau Server
  • Tableau Online
  • Extract (.tde)

Resolution

Step 1: Publishing

  1. Publish the extract to Tableau Server or Tableau Online. For more information, see Publish a Data Source.
  2. Ensure that Update workbook to use the published data source is selected.
  3. Publish the workbook to Tableau Server or Tableau Online. For more information, see Publish a Workbook.

Step 2: Appending

  1. In Tableau Desktop, select File > New to create a new workbook. 
  2. Connect to the data source you published in Step 1. For more information, see Connector Examples: Tableau Server or Tableau Online.
  3. Connect to the file you want to append data from. 
  4. You can now append data to your published extract: 
    Right-click the published data source > Tableau Data Server > Append from data source. 

Cause

Calculations from the workbook caused a mismatch of columns and prevented data from being appended. 
 
Did this article resolve the issue?