Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL error: SAP HANA and QlikView ODBC

Hi experts

The connection to our HANA DB via ODBC works fine.

When selecting tables and try to load the data we get errors like this one:

SQL##f - SqlState: S1000, ErrorCode: 258, ErrorMsg: [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;258 insufficient privilege: Not authorized SQL SELECT CALMONTH, CALQUARTER, CALWEEK FROM "_SYS_BI"."M_TIME_DIMENSION"

The restricted user on HANA DB side has the following authorizations:

Role: RESTRICTED_USER_ODBC_ACCESS

System Privileges: CATALOG READ

Object Privileges: _SYS_BIC

Analytic Privileges: SYS_BI_CP_ALL

I think it has nothing to do with authorizations.

On the other side we can load data stored by Lumira application on HANA DB:

SQL SELECT *

FROM "_SYS_BIC"."Lumira_Reports/GEOGRAFIE_COUNTRY_CITY";

Any ideas how to fix the error issue?

Thanks

Thomas

1 Solution

Accepted Solutions
sarvesh
Creator III
Creator III

Hi.. Thomas,

Please refer attached PDF file for the reference.

Regard's

Sarvesh Srivastava

View solution in original post

8 Replies
sarvesh
Creator III
Creator III

Hi.. Thomas,

Please refer attached PDF file for the reference.

Regard's

Sarvesh Srivastava

Anonymous
Not applicable
Author

Does your user have permissions to the "_SYS_BI" schema?

Not applicable
Author

Hi Gareth

Yes, it should have, with _SYS_BIC.

Do you agree?

Regards

Thomas

Not applicable
Author

There is the need to manipulate the generic SQL coding of Qlik.

The document given by Sarvesh did resolve a few SQL error issues.

Many thanks.

Thomas

sarvesh
Creator III
Creator III

I don't understand, please elaborate.

Not applicable
Author

Hi Sarvesh Example: //This generated code doesn't work! SQL SELECT ADDRESSTYPE,            Brutto,            DELIVERYDATE FROM "_SYS_BIC"."sap.hana.bnd_fatho/COPY_2_OF_ZPO_HEADER"; //This manipulated/modified code works! SQL SELECT ADDRESSTYPE, TO_DOUBLE("Brutto") as Brutto,      DELIVERYDATE FROM "_SYS_BIC"."sap.hana.bnd_fatho/COPY_2_OF_ZPO_HEADER";

sarvesh
Creator III
Creator III

Ok its fine, in your previous code you have not declared datatype thus your is not working.

rprios90
Partner - Contributor
Partner - Contributor

Dear Thomas,

We are starting the impementation of a project, however, we have had connection problems.

I read your post and use the role and privileges you mention, however, the connection test is successful but the schemas and tables are not displayed.

I would like to know if you need other permissions or roles to be able to connect and extract data from SAP HANA or is there any info available online that contains the minimun requeriments and permissions you need to perform this operation?

Greetings.

Paul Rios