I am trying to connect SAS to SAP HANA using "SAS/Access for ODBC". I can able to access the SAP HANA DB using below libname statement.
libname test odbc dsn="XXX" user=XXXXX Password=XXXXXX;
But when i am trying to access the tables in EG i got the below error message.
"SAS IOM Data provider has failed to open data.Unspecified error: -2147417848(0x80010108)"
Thanks.
A couple of suggestions:
Firstly, place
%put &=SYSLIBRC;
.. immediately after the libname statement, to confirm a 0 return code.
When you say you try to access your tables, do you mean interactively or programmatically? Try examining a known table:
proc contents data=test.table;
run;
Or else try:
proc contents data=test._ALL_ nods;
run;
Regardless, please post the code & the log (and the ODBC configuration) for us to help you further
Thanks for the reply.
Error seems inconsistent. I am trying to view the tables from SAS foundation(using -nodms option) instead of EG. Because it gives the error message more accurately.
Below is the code
proc contents data=md_read._ALL_ nods;
run;
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following
traceback information:
The SAS task name is [CONTENTS]
Segmentation Violation
Traceback of the Exception:
.../SASHome/SASFoundation/9.4/sasexe/sas(+0x15aa6e) [0x7fd63ff69a6e]
.../SASHome/SASFoundation/9.4/sasexe/sas(+0x4cb0b) [0x7fd63fe5bb0b]
.../SASHome/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144)
[0x7fd63e7b33c4]
/lib64/libpthread.so.0(+0x3b2a60f710) [0x7fd63f9df710]
Is the error related to any Hotfix?
Hi,
are other users experience the same problem? Could you test w/ another user's EG?
If there are any other databases, can you connect to those?
What version of SAS and EG are you using?
Thanks
Anja
Which ODBC driver are you using for SAP HANA ?
I am not pretty sure about SAP Hana DB structure, so I guess the libname statement needs "schema=" attribute.
I fixed same error by giving "schema=" for MS SQL database in a ODBC libname statement.
SAP HANA needs to declare schema name before table name (cmiiw)... I get the same issue... i already try to add schema in the lib but the result still error.
Its looks like SAS not go deep into schema level, but strange when i register the table SAS show list of correct table in schema level but when load it SAS just give table name.
Any suggestion sir?
Hi, i get the same error... im using cdata odbc to SAP HANA driver.
Its looks like SAS did not put schema name in front of table name...
Any suggestion sir?
Hello @PKumar / @anja
There is a parallel thread running involving SAS Hana
https://communities.sas.com/t5/Administration-and-Deployment/SAS-Management-Console-failed-to-regist...
Please have a look. Perhaps the underlying cause is the same.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.