topic Re: SAP HANA connection using SAS/Access Interface ODBC in Administration and Deployment

SAP HANA connection using SAS/Access Interface ODBC

PKumar — Fri, 30 Jun 2017 13:42:42 GMT

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.

Re: SAP HANA connection using SAS/Access Interface ODBC

AndrewHowell — Mon, 03 Jul 2017 04:31:58 GMT

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

Re: SAP HANA connection using SAS/Access Interface ODBC

anja — Mon, 03 Jul 2017 12:45:46 GMT

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

Re: SAP HANA connection using SAS/Access Interface ODBC

PKumar — Mon, 28 Aug 2017 15:32:45 GMT

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?

Re: SAP HANA connection using SAS/Access Interface ODBC

nhvdwalt — Tue, 29 Aug 2017 04:38:33 GMT

Which ODBC driver are you using for SAP HANA ?

Re: SAP HANA connection using SAS/Access Interface ODBC

SathyaMantena — Thu, 07 Mar 2019 12:45:02 GMT

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.

Re: SAP HANA connection using SAS/Access Interface ODBC

dioninoang — Tue, 08 Mar 2022 13:54:26 GMT

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?

Re: SAP HANA connection using SAS/Access Interface ODBC

dioninoang — Tue, 08 Mar 2022 13:58:21 GMT

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?

Re: SAP HANA connection using SAS/Access Interface ODBC

Sajid01 — Wed, 09 Mar 2022 13:32:14 GMT

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-register-table-query-executed/m-p/800994#M23917

Please have a look. Perhaps the underlying cause is the same.