KNOWLEDGE BASE

Published SAP HANA Data Sources on Tableau Server May Fail During Connection or Extract Refresh


Published: 16 May 2019
Last Modified Date: 20 Oct 2019

Issue

When connecting to published SAP HANA data sources, or refreshing published SAP HANA extracts, the connection/extract may fail with errors including:

"[SAP AG][LIBODBCHDB DLL][HDBODBC] Communication link failure;-10709 Connect failed (no reachable host left)" when refreshing SAP HANA data source. 

Environment

  • Tableau Server
  • SAP HANA

Resolution

Edit the password to remove special characters other than underscores ("_").

Cause

Even though SAP HANA allows passwords with special characters, passwords using special characters other than an underscore ("_"), need to be contained in double quotation marks ("). Some SAP HANA clients automatically cast passwords with special characters in quotation marks, such as SAP HANA STUDIO. Many other clients do not have this ability built in, including SAP HANA HDBSQL.

So, even if a user can connect to SAP HANA STUDIO with the same credentials, passwords with special characters may not get passed properly through Tableau Server as a result.
Did this article resolve the issue?