/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
- The HANA Database system was migrated to a new server. Post migration, the client SAPGUI system begins generating many 'DBSQL_NO_MORE_CONNECTION' ABAP dumps in ST22.
Category Resource bottleneck
Runtime Errors DBSQL_NO_MORE_CONNECTION
Date and Time 20.10.2023 16:47:39 (EET)
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text |
| No resources available for further secondary database connections. |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened? |
| The resources for further secondary database connections have been used |
| up. |
| |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Error analysis |
| There are two possible causes: |
| |
| 1. An SQL error occurred when opening a database connection. Normally |
| this would be due to the configurable limit for the number of |
| simultaneious database connections being exceeded. |
| |
| 2. Too many database connections were active in a work process when the |
| program crashed. The maximum number of parallel database transactions |
| per work process is 16. If this error is reproducible, it could be a |
| programing error. This error is normally due to DB transactions not |
| being closed by COMMIT or ROLLBACK. |
| |
| The actual reason for this happening can be found in "Information from |
| the DB Interface". If "Cannot open more than 16 connections" appears |
| here, reason 2 applies. |
| If not, reason 1 applies. |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|System environment |
| SAP Release..... 756 |
| SAP Basis level 0003 |
| |
| Application server... host |
| Instance name....... instance_name |
| Network address...... <> |
| Operating system... Linux |
| Release.............. 5.14.21-150400.24.81 |
| Hardware type....... x86_64 |
| Character length..... 16 Bits |
| Pointer length........ 64 Bits |
| Work process number... 7 |
| Work process ID....... 32654 |
| ABAP load version.... 3060 |
| Shortdump setting. full |
| |
| Database server... host |
| Database type..... HDB |
| Database name..... SID |
| Database user ID SAPHANADB |
| |
----------------------------------------------------------------------------------------------------
|Active Calls in SAP Kernel |
----------------------------------------------------------------------------------------------------
|Lines of C stack in kernel (structure different on each platform) |
----------------------------------------------------------------------------------------------------
|# buildID: e67e7efac94981c22e1d6c8d955ef5cf06c5e9b6 |
|instance_name;0x919cb7;[S](LinStackBacktrace(void**, int, int)+0xa8)[0x55c8e5f19cb7] |
|instance_name;0x91e2bb;[S](LinStack(_IO_FILE*)+0x48)[0x55c8e5f1e2bb] |
|instance_name;0x919737;[S](CTrcStack2+0x4b)[0x55c8e5f19737] |
|instance_name;0xbe259e;[S](rabax_CStackSave()+0x9e)[0x55c8e61e259e] |
|instance_name;0xbdc489;[S](rabax(char16_t const*, char16_t const*, int, char16_t const*, void cons|
|instance_name;0x2696d1e;[S](dbi::base::RabaxThrowFactory::throw_rabax(char16_t const*, char16_t co|
|instance_name;0x2793f9c;[S](dbi::metadata::NoMoreConnections::_raise(dbi::base::BaseRabaxThrowFact|
|instance_name;0x9d02c2;[S](dbi::base::BaseRabaxException::raise(dbi::base::BaseRabaxThrowFactory&)|
|instance_name;0x2793448;[S](dbi::metadata::VendorMetaData::handleDbslRc(DBSL_RETURN, DB_CON_DA con|
|instance_name;0x3097a9b;[S](dbi::metadata::VendorMetaData::set(DB_CON_DA&, bool)+0x2b)[0x55c8e8697|
|instance_name;0x2de799f;[S](OSqlStmtEntry::checkDbFeatures(OSqlStmntDescr const&)+0x5f)[0x55c8e83e|
|instance_name;0x2de6b1f;[S](OSqlStmtEntry::setInputValues(OSqlStmntDescr const&)+0x1f)[0x55c8e83e6|
|instance_name;0x2de53e2;[S](ab_jsqln()+0x142)[0x55c8e83e53e2] |
|instance_name;0x2b19933;[S](ab_extri()+0x1b3)[0x55c8e8119933] |
|instance_name;0x2b47d9b;[S](ab_xevent(char16_t const*)+0x3bb)[0x55c8e8147d9b] |
|instance_name;0x2b48036;[S](ab_trigg()+0xa6)[0x55c8e8148036] |
|instance_name;0x2e9ab8d;[S](ab_run+0x2d)[0x55c8e849ab8d] |
|instance_name;0x2ae948c;[S](dynpmcal(DINFDUMY*, STPDUMMY*)+0x6dc)[0x55c8e80e948c] |
|instance_name;0x2ae9d6c;[S](dynppai0(DINFDUMY*)+0x2cc)[0x55c8e80e9d6c] |
|instance_name;0x2ae8249;[S](dynprctl(DINFDUMY*)+0x129)[0x55c8e80e8249] |
|instance_name;0x2ae757c;[S](dynpen00(int)+0x3ac)[0x55c8e80e757c] |
|instance_name;0x2adca41;[S](RfcHandler::handleRequest(REQUEST_BUF*, bool)+0x271)[0x55c8e80dca41] |
|instance_name;0x2e29fb1;[S](ThStart()+0x7b1)[0x55c8e8429fb1] |
|instance_name;0x2df4324;[S](DpMain+0x3d4)[0x55c8e83f4324] |
|instance_name;0x2a69c7e;[S](main+0x2e)[0x55c8e8069c7e] |
|# buildID: 767aa1e4d4fc7c106971b202b6b00e92f47411dc |
|libc.so.6;0x3524d;[S](__libc_start_main+0xef)[0x7fe2fee3524d] |
|# buildID: e67e7efac94981c22e1d6c8d955ef5cf06c5e9b6 |
|instance_name;0x2df3e8a;[S](_start+0x2a)[0x55c8e83f3e8a] |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Database Interface Information |
----------------------------------------------------------------------------------------------------
|C|1|Try to connect via secure store (SERVICE) on connection 1 ... [/bas/789_REL/src/dbs/hdb/dbhdbs|
|C|1|connect property [APPLICATION = ABAP:SID] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1420] |
|C|1|connect property [APPLICATIONVERSION = 789 PL 100] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1424|
|C|1|connect property [APPLICATION_SERVER_INSTANCE_NAME = instance_name] [/bas/789_REL/src/dbs/|
|C|1|connect property [APPLICATION_SERVER_WORKPROCESS_INDEX = 19] [/bas/789_REL/src/dbs/hdb/dbhdbsq|
|C|1|connect property [KEY = DEFAULT] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1033] |
|C|1|connect property [UNICODE = 1] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027] |
|C|1|connect property [SQLMODE = SAPR3] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027] |
|C|1|connect property [VARCHARMODE = ABAP] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027] |
|C|1|connect property [PACKETSIZE = 1048576] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027] |
|C|1|connect property [COMPLETEARRAYEXECUTION = 1] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027] |
|C|1|connect property [CACHEDVIEWTS = 1] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027] |
|C|1|connect property [EMPTYTIMESTAMPISNULL = false] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027] |
|C|1|connect property [SPATIALTYPES = 1] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027] |
|C|1|connect property [STATEMENTROUTINGWARNINGS = TRUE] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027|
|C|1|connect property [STATEMENTHASH = 1] [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#1027] |
|C|E|Connect to database failed, rc=1, rcSQL=-10709 [/bas/789_REL/src/dbs/hdb/dbhdbsql.cpp#620] |
|C|1|SQLCODE : -10709 [/bas/789_REL/src/dbs/hdb/dbsdbtrc.cpp#610] |
|C|1|SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection re|
|C|1| 0582 -> xx.xx.x.xx:30513} (xx.xx.x.xx:40582 -> server:30513)) [/bas|
|B|1|DatabaseMetaData: connection name R/3*ANNOTATION: No more DB connections [/bas/789_REL/src/krn|
----------------------------------------------------------------------------------------------------
- Stopping the SAPGUI & HDB results in the SAP system failing to connect to the database altogether.
- Work process logs can also contain the following error on client side where no SQL exception is observed in the ABAP Dump
B 1 0: name = R/3, con_id = 000000000, state = ACTIVE , tx = NO , bc = NO , iso = DEF, oc = 0
B 1 1: name = R/3*RSAU, con_id = 002000708, state = CONNECTING , tx = NO , bc = NO , iso = DEF, o
B 1 2: name = R/3*RSAU, con_id = 002000709, state = CONNECTING , tx = NO , bc = NO , iso = DEF, o
B 1 3: name = R/3*RSAU, con_id = 002000710, state = CONNECTING , tx = NO , bc = NO , iso = DEF, o
B 1 4: name = R/3*RSAU, con_id = 002000711, state = CONNECTING , tx = NO , bc = NO , iso = DEF, o
B 1 5: name = R/3*RSAU, con_id = 002000712, state = CONNECTING , tx = NO , bc = NO , iso = DEF, o
B 1 6: name = R/3*RSAU, con_id = 002000713, state = CONNECTING , tx = NO , bc = NO , iso = DEF, o
B 1 7: name = R/3*RSAU, con_id = 002000714, state = CONNECTING , tx = NO , bc = NO , iso = DEF, o
B 1 8: name = R/3*RSAU, con_id = 002000715, state = CONNECTING , tx = NO , bc = NO , iso = DEF, o
B 1 9: name = R/3*RSAU, con_id = 002000716, state = CONNECTING , tx = NO , bc = NO , iso = DEF, o
B 1 10: name = R/3*RSAU, con_id = 002000717, state = CONNECTING , tx = NO , bc = NO , iso = DEF,
B 1 11: name = R/3*RSAU, con_id = 002000718, state = CONNECTING , tx = NO , bc = NO , iso = DEF,
B 1 12: name = R/3*RSAU, con_id = 002000719, state = CONNECTING , tx = NO , bc = NO , iso = DEF,
B 1 13: name = R/3*RSAU, con_id = 002000720, state = CONNECTING , tx = NO , bc = NO , iso = DEF,
B 1 14: name = R/3*RSAU, con_id = 002000721, state = CONNECTING , tx = NO , bc = NO , iso = DEF,
B 1 15: name = R/3*RSAU, con_id = 002000722, state = CONNECTING , tx = NO , bc = NO , iso = DEF,
B ECannot open more than 16 connections [/bas/785_REL/src/krn/dbi/dbs/dbcon.c#5197]
B 1 VendorMetaData::set: connection name R/3*USAGE:No more DB connections [/bas/785_REL/src/krn/d
Read more...
Environment
SAP HANA Platform Edition 2.0
Product
SAP HANA, platform edition 2.0 ; SAP S/4HANA all versions
Keywords
KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , BC-CST , Client/Server Technology , Problem
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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)