Error "The field does not exist in the database" on Group Dimensions When Data is Updated
Published: 12 Jun 2014 Last Modified Date: 09 Sep 2015
When refreshing an extract, opening and closing a workbook, or switching to a live connection, some dimensions are marked invalid and the following error might display when hovering over them:
The field does not exist in the database
Tableau Desktop 8.1
Contact your database administrator to have the affected fields added to the database as new fields.
Groups were being used to create new fields that did not exist in the database. For example, a Customer field was being used to group customers according to the State in which they live, thus creating a new State field.
SQL imposes a limit on the length of a query statement and creating groups, such as the one described above, can create a string that exceeds this limit.
Thank you for providing your feedback on the effectiveness of the article.