An error occurred while communicating with PostgreSQL with error code DACBE23F when connect Tableau Desktop 2021.4.2 to PostgreSQL 9.6

KNOWLEDGE BASE

An error occurred while communicating with PostgreSQL with error code DACBE23F when connect Tableau Desktop 2021.4.2 to PostgreSQL 9.6

Published: 24 Feb 2022
Last Modified Date: 28 Feb 2022

Issue

An error occurred while communicating with PostgreSQL with error code DACBE23F when connect Tableau Desktop 2021.4.2 to PostgreSQL database 9.6.
The following error is found in the log file 'stdout_jprotocolserver.txt' when PostgreSQL JDBC driver is used.

Error: missing `server' JVM at `C:\Program Files\Tableau\Tableau 2021.4\bin\jre\bin\server\jvm.dll'.

Environment

Tableau Desktop 2021.4.2
Windows 10
PostgreSQL database 9.6

Resolution

Move the file postgresql-42.2.14.jar under the directory C:/Program Files/Tableau/Drivers to somewhere else, which will make Tableau Desktop use the PostgreSQL ODBC driver to connect to PostgreSQL version 9.6.

Note: PostgreSQL ODBC driver is set up by default when Tableau Desktop is installed.

Cause

PostgreSQL JDBC Driver (postgresql-42.2.14.jar) is incompatible between Tableau Desktop 2021.4 and PostgreSQL version 9.6
Tableau started to introduce PostgreSQL JDBC driver in order to connect PostgreSQL database version 12 and above.