SAP Knowledge Base Article - Preview

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

Symptom

You run a query on HANA, joining a 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)


Read more...

Environment

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

Product

SAP HANA, platform edition all versions

Keywords

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

About this page

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

Search for additional results

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