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 ONE Support launchpad (Login required).

Search for additional results

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