Reports that connect to the PostgreSQL data are working when I open them in the desktop tool but once published, they are not able to connect to the table with the following error:
ERROR: current transaction is aborted, commands ignored until end of transaction block;
Error while executing the query
Unable to connect to the PostgreSQL server "prdxtablapp01". Check that the server is running and that you have access privileges to the requested database.
We have set the userID and password to the same as they were on the old server, and it works when connecting directly but the reports seem to be having an issue we cannot resolve.
I assume there is a setting on the server we have to set but we are unable to figure out what that is.
Any help would be appreciated.
This is probably because you don't have the necessary Postgres driver installed. See https://www.tableau.com/support/drivers for instructions on downloading and installing the driver.
Tableau upgraded the version of Postgres for these admin views, so you need to upgrade the driver even if you had it installed before.
It is included with some versions of Tableau Server, but might not have installed correctly.
Dan
