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: 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
Agent version uses Data Services engine 4.2 SP8 or earlier
SAP HANA Cloud Integration 1.0 for data services
CPI, CPI-DS, HCI, HCI-DS, compatibility , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem
About this pageThis 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.