KNOWLEDGE BASE

Error "Tableau Data Engine Error: 49009: no such column [-2f]" Using ROUND() Function


Published: 06 Dec 2016
Last Modified Date: 21 Dec 2016

Issue

In Tableau 10 (both Desktop and Server), when navigating to a dashboard that contains a Round() function, the following error messages may be received:
Unable to connect to the data source.
Try connecting again. If the problem persists, disconnect from the data source and contact the data source owner

 
Tableau Data Engine Error: 49009: no such column [-2]

Entries in the Tableau Server's VizQL log will show 
DataSourceException (type=Unknown, TDE_Status=49009)

In Tableau Server 9.3 and earlier, the following messages will be received:

Session Ended by Server
An unexpected error occurred. If you continue to receive this error please contact your Tableau Server Administrator

Entries in Tableau Server's VizQL log will show: NULL_POINTER_READ_AFTER_CALL_BEFORE_c0000005_ddgplm27.dll!Unknown
 
INVALID_POINTER_WRITE_c0000005_Qt5Core.dll!QString::append

In Tableau Desktop 9.3 and earlier, the application will quit unexpectedly when the calculation is encountered.

Environment

  • Tableau Server
  • Tableau Desktop
  • Tableau Data Engine

Resolution

Do not round to negative precision digits.
For example, ROUND(500,-3) will not execute successfully.
 

Cause

The Round() function for Tableau is not intended to contain negative values for the precision digit.
Did this article resolve the issue?