Question Re: SQL ERRCODE: -24950 in Technology Q&A

SQL ERRCODE: -24950

wsunarko — Fri, 24 Jul 2020 11:13:49 GMT

Running SUM to update security on Java Stack, I got the following error in dev_sadbctrl.
What could be the cause ? Thank you.



[PID 29033] 
Tue Jul 21 11:56:00 2020
[PID 29033] SigISetDefaultAction : default handling for signal SIGCHLD
[PID 29033] 
Tue Jul 21 11:56:01 2020
[PID 29033] SQL STMT:    CONNECT to database SYDAWSDSAPP01-DP1 with userkey w
[PID 29033] SQL ERRCODE: -24950
[PID 29033] SQL ERRTEXT: POS(0) ERR_USRFAIL: user authorization failed
[PID 29033] [PID 29033] 
[PID 29033] *** ERROR => -24950: POS(0) ERR_USRFAIL: user authorization failed [dbadainstanceImpl.cpp 355]
[PID 29033] SQL STMT:    CONNECT to database SYDAWSDSAPP01-DP1 with userkey w
[PID 29033] SQL ERRCODE: -24950
[PID 29033] SQL ERRTEXT: POS(0) ERR_USRFAIL: user authorization failed
[PID 29033] [PID 29033] 
[PID 29033] *** ERROR => -24950: POS(0) ERR_USRFAIL: user authorization failed [dbadainstanceImpl.cpp 355]
[PID 29033] *** WARNING => No userkey for connect to DP1 found.

Re: SQL ERRCODE: -24950

AtulKumarJain — Fri, 24 Jul 2020 11:26:30 GMT

Hi Welly,

From above error log it is clear ,there is missing auth to connect to DB.

Have you checked that?

Atul

Re: SQL ERRCODE: -24950

wsunarko — Fri, 24 Jul 2020 12:21:48 GMT

Thanks Atul.
The connection was issued by SUM,I am trying to find how is the connection configured in SUM.
Regards
Welly

Re: SQL ERRCODE: -24950

AtulKumarJain — Fri, 24 Jul 2020 12:36:44 GMT

What all DB related input you made in SUM tool,please check those input.

Best Regards,

Atul