After upgrading to GPDB7, no Tableau reports can run- getting ERROR: "current transaction is aborted, commands ignored until end of transaction block"

Products

• VMware Tanzu Data Suite

Issue/Introduction

User may receive the following error during execution of Tableau reports after upgrading from GPDB6 to GPDB7

current transaction is aborted, commands ignored until end of transaction block

Cause

The following error is the primary cause of the Tableau report failure:

ERROR","42703","column c.relhasoids does not exist

relhasoids no longer exists as Postgres 12 (GPDB7) and above, and oid is no longer a special column.

Resolution

Tableau postgresql driver need to be upgraded to support the current running version of GPDB