2802793 - HANA 2.0 database datastore fails connection test - CPI-DS

• Connection test fails on HANA 2.0 database datastore
• HANA client driver is installed
• Datastore configured to use direct server connection returns following error when testing connection:
  Test failed for the default configuration 'default' of datastore: 'name':
  ODBC call <SQLDriverConnect> to connect database <> failed with error: <ODBC call <SQLDriverConnect> to connect to database <> failed with error: <[SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[89008] Socket closed by peer (<hostname:port>))>. Use the ODBCDriverSelector (Windows) or DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct driver. If the problem still exists after selecting the correct version of the driver, notify Customer Support.>. Use the ODBCDriverSelector (Windows) or DSConnectionManagerlsh (UNIX) utility in LINK_DIR/bin to configure the correct driver. If the problem still exists after selecting the correct version of the driver, notify Customer Support.
• Datastore configured to use DSN connection returns success for connection test
• Attempting to view tables on the datastore that uses a DSN connection returns error:
  Cannot retrieve children nodes - browse remote error: ODBC data source <name> error message for operation <SQLTables>: <[SAP AG][LIBODBCHDB SO][HDBODBC] General error;-10821 Session not connected>.

• SAP Cloud Platform Integration for data services
• SAP HANA 2.0 SPS2 or later

CPI, CPI-DS, HCI, HCI-DS, compatibility , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem