topic Re: ODBC Read Error in QlikView

ODBC Read Error

Mon, 26 Jan 2026 21:26:37 GMT

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

Re: ODBC Read Error

Peter_Cammaert — Fri, 17 Mar 2017 16:05:34 GMT

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

Re: ODBC Read Error

Mon, 20 Mar 2017 13:46:19 GMT

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

Re: ODBC Read Error

RenzoH — Mon, 03 Dec 2018 16:31:19 GMT

Hi varsha,

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

Regards,

Renzo Hohagen

Re: ODBC Read Error

Emmanuelle__Bustos — Mon, 21 Jun 2021 15:45:54 GMT

Same issue, does somebody know how to solve this?

Re: ODBC Read Error

Chip_Matejowsky — Mon, 21 Jun 2021 20:06:41 GMT

Hi @Emmanuelle__Bustos,

I did a Google search on the last part of the error and found two entries listed below

http://remote-database.com/00002061/db67a84001661a14e10000000a1550b0.html provides the below definition

10301: Invalid host type (<name>) for parameter (<number>)

Explanation:

The method that was called could not be executed, because the <name> data type entered in the SQLDBC_PreparedStatement::bindParameter method is invalid.

User Action:

Only choose values for the data type (SQLDBC_Hosttype) specified in the SQLDBC_Types.h file.
Check whether your version of the SQLDBC interface supports the data type entered.

https://userapps.support.sap.com/sap/support/knowledge/en/2393565 has information regarding the SAP error, but an account/login is required so I wasn't able to see what the complete entry was.

Best Regards