cancel
Showing results for 
Search instead for 
Did you mean: 

DISPATCHER GRAY

RAFA_BASIS
Explorer
0 Kudos
268

Hi, Experts!

well i'm really not sure about what happen with dispatcher

servidoraapp:YYYadm 1003> sapcontrol -nr 00 -function GetProcessList
04.09.2024 17:08:49
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
disp+work, Dispatcher, GRAY, Stopped, , , 4244
igswd_mt, IGS Watchdog, GREEN, Running, 2024 09 04 14:41:27, 2:27:22, 4245

servidoraapp:YYYadm 1004> sapcontrol -nr 01 -function GetProcessList
04.09.2024 17:08:56
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
msg_server, MessageServer, GREEN, Running, 2024 09 04 14:41:22, 2:27:34, 3980
enq_server, Enqueue Server 2, GREEN, Running, 2024 09 04 14:41:22, 2:27:34, 3981

already check: the ports its ok! the hostname on the OS and DB its ok! the license its ok! the firewall desactivate! the ping resolved on the OS and DB. shutdown applicative SAP to level OS and stop DB, and restart the box, review the resources of memory it's ok, the notes in sap: 3390633,2667891,3392400 it's ok.  and used the command df it's ok. but the problem persist. attached the log  dev_disp and dev_w0.

HDB version info:
version: 2.00.076.00.1705400033
branch: fa/hana2sp07
machine config: linuxx86_64

please help me to resolved this problem

Txs in advanced.

RAFA_BASIS
Explorer
0 Kudos
HiC *** ERROR => Connect to database failed, rc=1, rcSQL=10 [dbhdbsql.cpp 630] C SQLCODE : 10 C SQLERRTEXT : authentication failed B ***LOG BY2=> sql error 10 performing CON [dbsh 1329]
View Entire Topic
alwina_enns
Advisor
Advisor

Hello, 

in the dev_w* log there is the error:

Connect to database failed, rc=1, rcSQL=2

Check the configuration as described in KBA:

2961140 - SQLERRTEXT : general error: database 'SID' not connected

Regards, Alwina 

RAFA_BASIS
Explorer
0 Kudos
Hi alwina, now change the error: C *** ERROR => Connect to database failed, rc=1, rcSQL=10 [dbhdbsql.cpp 630] C SQLCODE : 10 C SQLERRTEXT : authentication failed B ***LOG BY2=> sql error 10 performing CON [dbsh 1329].
RAFA_BASIS
Explorer
0 Kudos
i do the note 2961140 and this is the result: to level database hd4adm@testhanadb:/usr/sap/HD4/HDB00/exe> hdbuserstore list DATA FILE : /usr/sap/HD4/home/.hdb/testhanadb/SSFS_HDB.DAT KEY FILE : /usr/sap/HD4/home/.hdb/testhanadb/SSFS_HDB.KEY KEY HD4SAPDBCTRL ENV : testhanadb:30013 USER: SAPDBCTRL KEY MYSYSTEM ENV : testhanadb:30013 USER: SYSTEM KEY DEFAULT ENV : testhanadb:30003 USER: SYSTEM ACTIVE RECORDS : 10 DELETED RECORDS : 9 NUMBER OF COMPLETE KEY: 3 Operation succeed. to level OS testhanaapp:s4dadm 1169> hdbuserstore list DATA FILE : /home/s4dadm/.hdb/testhanaapp/SSFS_HDB.DAT KEY FILE : /home/s4dadm/.hdb/testhanaapp/SSFS_HDB.KEY KEY DEFAULT ENV : testhanadb:30013 USER: SAPHANADB ACTIVE RECORDS : 4 DELETED RECORDS : 31 NUMBER OF COMPLETE KEY: 1 Operation succeed.