Dispatcher does not start after Refresh database

[qwertie]

Hi all,

We are currently carrying out System Refresh from  Production System to Test system using hana backup and recovery method.

We are currently able to restore & recover the Production backup on Test System. We have tried to restart the database & application .But we are unable to start the SAP application and disp+work is gray.

dev_w0 shows the below logs:

Sat Jul 20 12:39:55:886 2024
*** ERROR => Connect to database failed, rc=1, rcSQL=-10709
[dbhdbsql.cpp 620]
 SQLCODE : -10709
 SQLERRTEXT : Connection failed (RTE:[89009] Socket connect timeout (60000 ms) (192.168.212.250:21026 -> sappcopy:\
 30515))
 ***LOG R19=> ThDbConnect, db_connect () [thxxtool.c 6114]
 ThIErrHandle: in_ThErrHandle: 1
 *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c 2851]

 Info for wp 0

pid = 459367
 severity = 0
 status = 0
 stat = WP_NEW
 waiting_for = NO_WAITING
 workerType = DP_WORKER_DIAWP
 act_cs_count = 0
 csTrack = 0
 csTrackRwExcl = 0
 csTrackRwShrd = 0
 mode_cleaned_counter = 0
 control_flag = 0x1200000
 report = > <
 action = 0
 tab_name = > <

 ThIErrHandle: no current incoming request

 Entering TH_CALLHOOKS
 ThCallHooks: call hooks for event BEFORE_DUMP
 ThIErrHandle: entering PfStatReset
 ThIErrHandle: Entering DpRecoverMtxAfterProcessCrash
 DpRecoverMtxAfterProcessCrash: recover mutex after crash of W0
 ThIErrHandle: DpRecoverMtxAfterProcessCrash o.k.
 ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

 ***
 *** work process W0 died => ThInit: db_connect
 call ThrShutDown (1)...
 SigISetIgnoreAction : SIG_IGN for signal SIGUSR1
 SigISetIgnoreAction : SIG_IGN for signal SIGUSR2
EnqWorkProcess: Initializing enqueue client
 ***LOG Q02=> wp_halt2, halt wp () [dpuxtool.c 335]

Can you please help us on how to resolve this error?

I must add that after system rename(Changes the SAP system ID), the problem is solved and the application server starts. But we want to solve the problem without changing the system sid.

Your help in this regard will be highly appreciated.

With regards,

Maryam

SAP S/4HANA 

SAP HANA 

[qwertie]

check your hdbuserstore keys. like Hakan mentioned, you can not connect to your database (shows up in your logfile)

[Maryam_95]

Thank you rsnit; I'll check hdbuserstore keys.

[qwertie]

furthermore maybe you can check and post the output of the following (sidadm user)

hdbsql -U DEFAULT

and

R3trans -d

br