Qlik Community

QlikView Connectors

Discussion board for collaboration related to QlikView Connectors.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

ODBC Read Error

Hello,

I am trying to connect to the HANA Calculation views, created in another schema to QlikView.

I am able to connect to HANA System using ODBC, and I load the views in the _SYS_BIC schema.

But as soon I execute the statement, I get an ODBC Read Error.

Attached the screenshots.

This is the error I get:

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 4294956995, ErrorMsg: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10301 Invalid host type (UCS2 (LE)) for parameter (46)

The aggregations level has been maintained at the HANA Side.

It would be great if someone could help me figure out this issue!!

Thanks & regards,

Varsha

3 Replies
Highlighted

Re: ODBC Read Error

I'm not an expert. But shouldn't you be using MDX queries to get to this type of data?

Highlighted
Not applicable

Re: ODBC Read Error

Hi Peter,

Thanks for the reply.

But I am trying to connect the HANA Calculation Views to the QlikView.

The views contains data from the basic SAP Tables.

Thanks & regards,

Varsha

Highlighted
Partner
Partner

Re: ODBC Read Error

Hi varsha,

Could you solve the problem? I'm having the same error message.

Regards,

Renzo Hohagen