KB485072: MicroStrategy out-of-the-box PostgreSQL JDBC driver fails to connect PostgreSQL database when authentication method is scram-sha-256

Description

The Strategy out-of-the-box PostgreSQL JDBC driver fails to connect to the PostgreSQL database when the authentication method is scram-sha-256.
The following error is returned:
(QueryEngine encountered error: Connect failed. Unable to connect.
Error type: System call error. Error communicating with connection process. Child Process hung: Command ConnectionConnectWithNewParameters. The target data source hasn't responded to the Connect request after 60 seconds. It may be stressed.. Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job 99, Error Code= -2147212544.)

Solution

The issue has been fixed in Strategy 2021 Update 2. Upgrade to Strategy 2021 Update 2 or later to take advantage of the fix. 
 

Workaround

1. If scram-sha-256 authentication on the PostgreSQL database is not required, use md5 or password authentication as an alternative.
2. Use the Strategy out-of-the-box PostgreSQL ODBC driver:
   
• Strategy ODBC Driver for PostgreSQL Wire Protocol
• PostgreSQL Unicode (x64)