3445260 - DBCON to 'Babelfish for Aurora PostgreSQL' fails throwing "sql error 0 performing CON'

The customer configured a SAP NetWeaver DBCON (multiconnect) connection to an external 'Babelfish for Amazon Aurora PostgreSQL' database which runs on a server other than the SAP NetWeaver host. 
In DBACockpit, testing the Database Connection in DBCON or in SE38, by executing report ADBC_TEST_CONNECTION, returns following error message:

ERROR Database connection BABELFISH: ADBC error ‘Internal error 1 has occurred’

The developer trace of the work process involved in the DBCON connection indicates:

  Connect to BABELFISH as  xxxxxxx with OBJECT_SOURCE=SAPMonitor MSSQL_SERVER=xxxx MSSQL_DBNAME=xxxx
  Connection 0 failed using Driver={ODBC Driver 11 for SQL Server};Server=xxxx-babelfish.xxxx; ...

  ***LOG BY2=> sql error 0 performing CON [dbds  ]
  ***LOG BY0=> <message text not available> [dbds  ][ dbds ]

Executing following queries on the DBCON target database return following information:

select @@version
select SERVERPROPERTY ( 'edition' )
select SERVERPROPERTY ( 'collation' )

     Babelfish for Aurora PostgreSQL with SQL Server Compatibility - 12.0.2000.8 ... Copyright (c) Amazon Web Services PostgreSQL 15.4 on aarch64-unknown-linux-gnu (Babelfish 3.3.0)
     Standard Edition
     sql_latin1_general_cp1_ci_as

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• DBCON Source system is:    SAP NW 7.5 ABAP
• DBCON Target database is : AWS RDS instance / DB version. AWS Aurora Postgres 15.4 with Babelfish
  ( Babelfish for Aurora PostgreSQL with SQL Server Compatibility - 12.0.2000.8  ... Amazon Web Services PostgreSQL 15.4 on aarch64-unknown-linux-gnu (Babelfish 3.3.0) Standard Edition  sql_latin1_general_cp1_ci_as)

Amazon Aurora is a relational database engine built for the cloud with full MySQL and PostgreSQL compatibility.
Babelfish is a open-source software, a built-in capability of Amazon Aurora PostgreSQL provided under the terms of the Apache 2.0 license and PostgreSQL license.

DBCON, database multiconnect, SQL Server, Amazon Aurora, Cloud-Native,  Babelfish for Aurora PostgreSQL, with SQL Server Compatibility
SQL Server, AWS, ODBC, DBSL, dbacockpit, Iaas, PaaS, RDBMS, not supported , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , Problem