Qlik Community

QlikView Connector for SAP

Discussion Board for collaboration related to the QlikView Connector for SAP.

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

2 Replies

Re: ODBC Read Error

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

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