cancel
Showing results for 
Search instead for 
Did you mean: 

Facing Disconnection from SAP application to DB for every 20 minutes

rajashekarm
Discoverer
0 Kudos
53

We are facing issue with one of the application server where for every 20 minutes the connections are getting disconnected and reconnecting and we are seeing below dumps for every 20 minute only from one app server rest other application servers are working fine.

Dumps:
DBIF_RSQL_SQL_ERROR and DBIF_RTAB_SQL_ERROR

Workprocess log
B Tue Nov 26 06:23:18 2024
B dblink[db_reconnect]: { new_reconnect_message=1
C DbSlPing(con=0) -> c1=0, orc=1403, 0=DBSL_ERR_OK
B dbcon[db_con_reconnect]: { reco_trials=3, reco_sleep_time=5
B 00: name=R/3, con_id=000000000, state=INACTIVE , tx=NO , bc=NO , hc=NO , perm=YES, reco=NO , refused_cnt =000000000, isol=DEF,
B info=NO , timeout=000, con_max=255, con_opt=255, occ=NO , prog=
B dbcon[db_con_reconnect]: } rc=0
B ***LOG BV4=> reconnect state is set for the work process [dblink 1999]
B ***LOG BYY=> work process left reconnect status [dblink 2000]
B dblink[db_reconnect]: } rc=0
M ThHdlReconnect: reconnect o.k.
B
B Tue Nov 26 06:41:18 2024
B dblink[db_reconnect]: { new_reconnect_message=1
C DbSlPing(con=0) -> c1=0, orc=1403, 0=DBSL_ERR_OK
B dbcon[db_con_reconnect]: { reco_trials=3, reco_sleep_time=5
B 00: name=R/3, con_id=000000000, state=INACTIVE , tx=NO , bc=NO , hc=NO , perm=YES, reco=NO , refused_cnt =000000000, isol=DEF,
B info=NO , timeout=000, con_max=255, con_opt=255, occ=NO , prog=
B dbcon[db_con_reconnect]: } rc=0
B ***LOG BV4=> reconnect state is set for the work process [dblink 1999]
B ***LOG BYY=> work process left reconnect status [dblink 2000]
B dblink[db_reconnect]: } rc=0
M ThHdlReconnect: reconnect o.k.

There is no firewall configured between APP to DB and ping test is fine and ran niping as well it looks fine
But for every 20 minutes exact the connection are getting reset

Accepted Solutions (0)

Answers (0)