SAP Knowledge Base Article - Preview

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


  • You are using Smart Data Access (SDA) to connect HANA to an Oracle remote data source.
  • You are using Smart Data Access (SDA) to connect HANA to remote SQL Server database.
  • 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



SAP HANA Database (Revision/SPS independent)


SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0


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.