2578523 - SAP HANA Smart Data Access - exceeded simultaneous SESSIONS_PER_USER limit | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2578523 - SAP HANA Smart Data Access - exceeded simultaneous SESSIONS_PER_USER limit

Symptom

  • You are using Smart Data Access (SDA) to connect HANA to an Oracle remote data source.
  • The database connections opened by HANA in the Oracle remote data source remain inactive after query execution and never close.
  • The following error can be observed in both Oracle and the HANA indexserver trace file:

[unixODBC][Oracle][ODBC][Ora]ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit


Read more...

Environment

SAP HANA Database (Revision/SPS independent)

Product

SAP HANA 1.0, platform edition

Keywords

SDA, Oracle, remote_conn_idle_timeout, ORA-02391, SESSIONS_PER_USER , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem

About this page

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

Search for additional results

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