KNOWLEDGE BASE

Externalizing Tableau Server repository using Azure Database for PostgreSQL flexible server fails


Published: 24 Apr 2022
Last Modified Date: 26 Apr 2022

Issue

Externalizing Tableau Server repository using Azure Database for PostgreSQL flexible server fails.

When this issue occurs, databasemaintenance_node<X>-<Y>.log will contain the error below (* Note that <X> is node number and <Y> is process number in Tableau Server.):- INFO  com.tableausoftware.db.maintenance.operations.impl.ExternalTableauRepository - Adding extension uuid-ossp to workgroup workgroup as user ADMIN on instance /var/opt/tableau/tableau_server/data/tabsvc/pgsql

- ERROR com.tableausoftware.db.maintenance.operations.impl.ExternalTableauRepository - Exception raised while adding extensions to database.
 
org.postgresql.util.PSQLException: ERROR: extension "uuid-ossp" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL
   HINT: to see the full allow list of extensions, please run: "show azure.extensions;"
 

Environment

  • Tableau Server 2021.3.7 with Tableau Server Management Add-on
  • Ubuntu 18.04 LTS
  • Azure Database for PostgreSQL flexible server as an external repository

Additional Information

tsm.log will contains the following log snippets:
- INFO  com.tableausoftware.tabadmin.async.AbstractMultiStepAsyncJobStrategy - 155% - Restoring database failed.
- INFO  com.tableausoftware.tabadmin.async.AbstractMultiStepAsyncJobStrategy - 161% - Rolling back database.
- INFO  com.tableausoftware.tabadmin.async.AbstractMultiStepAsyncJobStrategy - 166% - Deleting temporary backup file.
- INFO  com.tableausoftware.tabadmin.async.AbstractMultiStepAsyncJobStrategy - 172% - Cleaning up restore data on all nodes.

- INFO  com.tableausoftware.tabadmin.async.AbstractMultiStepAsyncJobStrategy - 288% - Restoring previous repository location.
- ERROR com.tableausoftware.tabadmin.async.AsyncJobDelegate - Asynchronous job <job ID> failed.
- INFO  com.tableausoftware.tabadmin.cli.Console - Switch to external repository failed.
- ERROR com.tableausoftware.tabadmin.cli.Console - See '/var/opt/tableau/tableau_server/data/tabsvc/logs/tabadmincontroller/tabadmincontroller_*.log' on Tableau Server nodes running the Administration Controller process for server log information.

 

tabadmincontroller_node<X>-<Y>.log will contain the messages below (* Note that <X> is node number and <Y> is process number in Tableau Server.):
- WARN com.tableausoftware.tabadmin.webapp.restore.ParallelRestoreMultiplexer - Exception while running 'restore begin pgsql_<version number>' on node node<node number>
   com.tableausoftware.backuprestore.endpoint.BackupRestoreException: net.jodah.failsafe.FailsafeException: org.apache.thrift.TApplicationException: Internal error processing completeCreateRolesAndDatabases
- ERROR com.tableausoftware.tabadmin.webapp.restore.ParallelRestoreMultiplexer - Exception while running 'restore begin' on services on node node<node number>
   java.util.concurrent.ExecutionException: java.lang.RuntimeException: BackupRestoreException(message:net.jodah.failsafe.FailsafeException: org.apache.thrift.TApplicationException: Internal error processing completeCreateRolesAndDatabases)


* Note that when this issue occurs, the database named workgroup and relationship are created but they would have no tables in them.

Did this article resolve the issue?