KNOWLEDGE BASE

Error "Warning: Null value is eliminated by an aggregate or other SET operation" Creating or Refreshing Extract


Published: 14 Jan 2016
Last Modified Date: 29 Aug 2016

Issue

When creating or refreshing a SQL Server Extract the following error might occur: 

Refresh extract failed.

In background task for extracts, one of the following error displays in the tooltip for that extract:

"com.tableausoftware.nativeapi.dll.TableauException: MicrosoftSQL Server Native Client 10.0SQL ServerWarning: Null value is eliminated by an aggregate or other SET operation. MicrosoftSQL Server Native Client 10.0SQL ServerThe transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'."

Or:

Warning: Null value is eliminated by an aggregate or other SET operation.
Error converting data type varchar to float. 
Unable to create extract. 

 

Environment

  • Tableau Desktop
  • Tableau Server
  • MS SQL Server 2012 & 2014
Did this article resolve the issue?