Hi All,
My company recently upgraded to Tableau Desktop version 2020.1.2 as well as, Tableau Server 2020.1.2
After this upgrade we ran into an issue with a dashboard that was built on a previous version (I am unable to pinpoint what version it was built on, so if someone knows how to check that let me know) but my guess was some iteration of Tableau 2018 or 2019. The issue is that we get the following error message when trying to load the datasource:
I searched online and could not find a great answer to this error message, and the other confusing part is that the error messages says that a few of the columns are 'invalid in the select list because it is not contained in either an aggregate function or group by clause' however, there are no aggregations in the underlying data source, I am simply just returning the whole table.
From the error message I am also assuming that these are temp fields created by the older version of tableau, because of the name ⌗Tableau_5_2_sp_temp. So I believe the issue is with the version of Tableau and I am wondering if anyone knows how to solve this issue. So far I have tried the following:
1- downloading the file from tableau server into the latest version of tableau desktop, reconnecting to the table as another data source and then replacing the current data source with the new connection and the error still appears
2 - downloading the file from tableau server into tableau 2019.4 and the error does not occur, however, once I publish back into Tableau Server 2020 the error reappears there
Is there a simple way to get this error to stop occurring other than starting from scratch and rebuilding the entire dashboard in Tableau 2020?
Thanks,
Shawn
When Tableau executes a stored procedure, using a live connection, it does the following;
- Creates a temporary table.
- Executes the SP and inserts the results into the temporary table.
- Performs a SELECT from the temporary table.
⌗Tableau_5_2_sp_temp appears to be the temporary table that Tableau has created.
From this point forward, Tableau treats this SELECT like any other live data model or custom SQL. For instance, if you filter on Country = US, it will run a query kind of like this:
SELECT * FROM ⌗Tableau_5_2_sp_temp WHERE [Country] = 'US'
If you perform aggregations, it will do something similar. So, what you are seeing is Tableau attempting to create GROUP BY statements because of some sort of aggregation being performed. The question from here would then be what is the est_hh_inc_higher_ranges_cd field? Is this a field in your database? Does this look familiar at all?
