KNOWLEDGE BASE

Error "Refresh failed (Unknown failure)" Refreshing SQL Server Extract on Tableau Server


Published: 13 Dec 2013
Last Modified Date: 24 Aug 2015

Issue

Scheduled extract refreshes of Microsoft SQL Server data source might fail on Tableau Server, and the following error might appear in the background tasks view:
 
Refresh failed (Unknown failure) Tableau Data Engine Error: 4: SimpleDatabase::SelectMetadataName: expected found=1, actual found=0 (fk=18446744073709551615 name="Extract" nameTable="SCHEMAS")
 
When you try to refresh the extract on Tableau Desktop, the refresh succeeds.

Environment

  • Tableau Server 
  • Microsoft SQL Server

Resolution

On the computer running Tableau Server, download and install the Microsoft SQL Server driver from the Drivers & Activation page.

Cause

The necessary Microsoft SQL Server driver is not installed on the computer running Tableau Server.
Did this article resolve the issue?