BookmarkSubscribeRSS Feed
PKumar
Fluorite | Level 6

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.

8 REPLIES 8
AndrewHowell
Moderator

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

PKumar
Fluorite | Level 6

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?

 

anja
SAS Employee

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

nhvdwalt
Barite | Level 11

Which ODBC driver are you using for SAP HANA ?

SathyaMantena
Calcite | Level 5

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.

dioninoang
Obsidian | Level 7

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?

dioninoang
Obsidian | Level 7

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?

Sajid01
Meteorite | Level 14

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 8 replies
  • 4044 views
  • 0 likes
  • 7 in conversation