KNOWLEDGE BASE

Error "The size (9999999) given to the column "Column" exceeds the maximum allowed for any data type (8000)"


Published: 19 May 2016
Last Modified Date: 10 Oct 2016

Issue

When you try to create an extract or connect to temp tables or stored procedures, the following error occurs:
The size (9999999) given to the column "Column" exceeds the maximum allowed for any data type (8000)

Environment

  • Tableau Desktop
  • Microsoft SQL Server

Resolution

Work with your database administrator to correct the size declaration of the column.

 

Cause

The size declaration for the column is incorrect.
 
Did this article resolve the issue?