Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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
I'm not an expert. But shouldn't you be using MDX queries to get to this type of data?
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
Hi varsha,
Could you solve the problem? I'm having the same error message.
Regards,
Renzo Hohagen
Same issue, does somebody know how to solve this?
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:
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