SAP Knowledge Base Article - Preview

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

Symptom

  • 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>.

Read more...

Environment

  • SAP Cloud Platform Integration for data services
  • SAP HANA 2.0 SPS2 or later
  • Agent version uses Data Services engine 4.2 SP8 or earlier

Product

SAP HANA Cloud Integration 1.0 for data services

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.