SAP Knowledge Base Article - Preview

3202640 - User administration tcodes (SU01,SU10 etc) takes lot of time to execute

Symptom

User administration transactions like SU01, SU10 are taking long time in S/4 system. All other transactions are working as expected.

  • The ST12 trace shows that most of time is spent in DB.

e.g.

Transaction SU01 = ****ABAP| 12.912=0,0 %
Traced user <USER>Database|-----------------------------127.338.347=100,0 %
 System| 6.556=0,0 %
Execution times in microsecondsTotal|-------************+127.357.815=100,0 %

CL_SQL_CONNECTION=============CM004 34 1 0 127.304.402 0 127.304.402 127.304.402 127.304.402 1 0 127.304.402 100 0 127.304.402 0    CONNECT

DBMS_TECH_USER@<host name>:<port number> on connection 2

  • SQLDBC Trace and work process trace would show following connection error:

SQL ERROR :
SQLCODE : -10709
SQLSTATE :
MESSAGE : Connection failed (RTE:[89006] System call 'send' failed, rc=110:Connection timed out {<IP address>:<port number>} (<host name>:<port number>))

Image /data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

S/4 HANA application

Keywords

DBMS, DBMS_TECH_USER,DBMS_USR_MGT , KBA , HAN-DB , SAP HANA Database , 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.