Unable To Access Administrative view 'Background Task For Extracts'

KNOWLEDGE BASE

Unable To Access Administrative view 'Background Task For Extracts'

Published: 27 Mar 2020
Last Modified Date: 27 Mar 2020

Issue

When accessing Tableau Server administrative view 'Background task for extracts', the following error occurs:

[unixODBC][Driver Manager]Can't open lib '/opt/tableau/tableau_driver/postgresql-odbc/psqlodbcw.so' : file not found
Unable to connect to the PostgreSQL server 'xxxxxxxxxx'. Check that the server is running and that you have access privileges to the requested database.
ldd <path/to/driver> returns libpq.so.5 => not found

Environment

Tableau Server 2019.4.4
CentOS 7

Resolution

Download and install new version of pgsql driver:
tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm

Cause

The version of postgres driver used is old and not compatible with the Tableau Server installed. From Tableau Server 2019.2, tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm is used.