SAP Knowledge Base Article - Preview

3622305 - Run "SELECT ROLE_NAME FROM ROLES" via HDBSQL, the command hangs.

Symptom

if you try to execute the command from OS level via hdbsql using the following statement "SELECT ROLE_NAME FROM ROLES", the command just hangs, no output is there. But if you try to execute "SELECT ROLE_NAME FROM ROLES" from HANA Studio, it works normally. And if you reduce the selected amount of entries, it also works normally via hdbsql, for example: "select top 18 * from roles"


Read more...

Environment

  • SAP HANA Database 2.0

Product

SAP HANA, platform edition 2.0

Keywords

hdbsql, SELECT ROLE_NAME FROM ROLES, hdbsql hang, MTU,  ifconfig -a, ip address , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.