ODBC Read Error

[#1]

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

[Peter_Cammaert]

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

[#3]

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

[RenzoH]

Hi varsha,

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

Regards,

Renzo Hohagen

[Emmanuelle__Bustos]

Same issue, does somebody know how to solve this?

[Chip_Matejowsky · Accepted solution]

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