search

tableau / VizAlerts

Data-driven alerting for Tableau Server
MIT License
212 stars 91 forks source link

VizAlertsConfig "ERROR: current transaction is aborted" following upgrade Tableau Server to 2021.4.1 #189

Closed westmalle closed 2 years ago

westmalle commented 2 years ago

We just upgraded TS from 2020.3 to 2021.4.1 and vizalerts seems broken. VizAlerts version is 2.1.1 The VizAlertsConfig worksheet returns an error: Unexpected Server Error TableauException: ERROR: current transaction is aborted, commands ignored until end of transaction block; Error while executing the query The data source connection works fine when testing from Tableau Server "Edit Connection", but the SQL query returns the error. The SQL query runs ok in a SQL client tool with the same "readonly" user. Any idea how to solve ?

westmalle commented 2 years ago

vizalert_config_error vizalerts_custom_sql_client

westmalle commented 2 years ago

I noticed that converting the data source from live to extract, the extract refresh works. Problem seems only to appear when connecting live.

mcoles commented 2 years ago

Most likely due to the PostgreSQL upgrade that requires a new driver. Same issue this person had: https://community.tableau.com/s/question/0D54T00000bjE3e/we-did-an-upgrade-to-20211-this-week-and-have-an-outstanding-issue-with-the-admin-reports-that-connect-to-the-postgresql-data

westmalle commented 2 years ago

Thanks Matt. I tried to update the driver by following the instructions (for linux) driver_postgresql_tableau I put the downloaded driver (postgresql-42.2.22.jar) in /opt/tableau/tableau_driver/jdbc opt_driver

After that, when I try to connect to TS postgresql database, it hangs for a while (1 minute) and returns an error : connection_failed

westmalle commented 2 years ago

I found the solution : just restart tableau server after installing the driver !