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
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.