Tableau ERROR: current transaction is aborted, commands ignored until end of transaction block

Tableau ERROR: current transaction is aborted, commands ignored until end of transaction block

When trying to connect to postgres DB we get this error. Cause – Check drivers

https://www.tableau.com/support/drivers

Data source – postgre SQL

https://help.tableau.com/current/pro/desktop/en-us/examples_postgresql.htm

Tableau how to get more then 16 columns

I tried following approach and it worked.
rename .twb file to .xml
(if your tableau file is twbx then rename this file to .zip . get .twb file from this zip file. )
Open in notepad

search for following text:

change ’16’ to your desired value.
Now rename the .xml back to .twb. Open in tableau.

Though you could add more columns in tableau by changing xml, UI doesn’t look good. As tableau doesn’t support scroll bar on “Rows”

source:
https://community.tableau.com/thread/238456