KB484581: Error "Current Transaction Is Aborted, Commands Ignored Until End Of Transaction Block;" occurs when interacting with PostgreSQL Data Source.

Problem Description
Error "Current Transaction Is Aborted, Commands Ignored Until End Of Transaction Block;" occurs, when trying to connect, refresh or change schema of a PostgreSQL data source on MSTR web. 
You will meet this problem when using the "PostgreSQL Unicode (x64)" driver (version 11.00.0000) to connect PostgreSQL 12.x database. 
Root Cause
This problem is caused by the PostgreSQL Unicode (x64) driver. 
Some versions of PostgreSQL Unicode(x64) drivers do not properly handle the cancel request when trying to connect to PostgreSQL 12.x database. Because of this, It believes the transaction is still available and attempts to run queries off of it, which causes things to break.
Workaround

1. Use another OOTB PostgreSQL ODBC driver "Strategy ODBC Driver for PostgreSQL Wire Protocol"
2. Upgrade the PostgreSQL Unicode (x64) driver to 12.02.0000  https://www.postgresql.org/ftp/odbc/versions/

Note: this problem will be addressed in the coming MSTR 2021 Release.