2659049 - Joining a SDA Virtual Table with a HANA table fails with error Unable to load driver manager

You run a query on HANA, joining a Smart Data Access (SDA) Virtual Table and a HANA Table fails with the following error:

Internal Error: Unable to load driver manager.

You can find additional information in the indexserver trace:

PlanExecutor.cpp(00872) : plan plan775470@<HANAHOST_XX>:<PORT> failed with rc 403; internal error[unixODBC][Driver Manager]Data source name not found, and no default driver specified
PlanExecutor.cpp(00872) : -- returns for plan775470@<HANAHOST_XX>:<PORT>:
PlanExecutor.cpp(00872) : [unixODBC][Driver Manager]Data source name not found, and no default driver specified(403), plan: 1/5 pops: RowPlanOperator pop5(in cd, out ef)
PlanExecutor.cpp(00872) : pop1, 08:44:21.103  +0.085, cpu 20308302304, <HANAHOST_YY>:<PORT>, RowPlanOperator, rc 403, [unixODBC][Driver Manager]Data source name not found, and no default driver specified
...
PlanExecutor.cpp(00872) : pop1 (rc 403, [unixODBC][Driver Manager]Data source name not found, and no default driver specified)

• SAP HANA Database 1.0;
• SAP HANA Database 2.0;
• Smart Data Access;
• Multiple Hosts (scale-out) environment.

scale out, scaleout, multihost, multi host, multiple, multihosts, hosts, odbc, driver, drivers, unixODBC , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem