Start a Conversation

Solved!

Go to Solution

1 Rookie

 • 

26 Posts

2903

August 8th, 2022 04:00

SAP HANA DB failure.

Hello Expert,

I am completely new to the networker need you help to understand the error..

we have recently configured the Saphana db system which is failing with below error.

The user ‘NMSAP’ is not locked and SAP team were able to login to Hana database with the password.

Kindly help us to resolve this...

(pid = 12264) (08/01/22 15:23:34.600664) HANA_MDC = TRUE
(pid = 12264) (08/01/22 15:23:34.600693) TENANT_ADMIN = FALSE
(pid = 12264) (08/01/22 15:23:34.600707) DATABASES = SYSTEMDB,HAR
(pid = 12264) (08/01/22 15:23:34.600721) HANA_SID = HAR
(pid = 12264) (08/01/22 15:23:34.600734) HANA_INSTANCE = 00
(pid = 12264) (08/01/22 15:23:34.600747) HANA_BIN = /usr/sap/HAR/HDB00/exe
(pid = 12264) (08/01/22 15:23:34.600760) HANA_USR_PASSWD = ******
* 10: authentication failed SQLSTATE: 28000
(pid = 12264) (08/01/22 15:23:35.082136) The '/usr/sap/HAR/HDB00/exe/hdbsql' program exited with error status 3.
The backup for 'HAR:SYSTEMDB' failed.
* 10: authentication failed SQLSTATE: 28000
(pid = 12264) (08/01/22 15:23:35.121706) The '/usr/sap/HAR/HDB00/exe/hdbsql' program exited with error status 3.
The backup for 'HAR:HAR' failed.
(pid = 12264) (08/01/22 15:23:35.121780) At least one of the database backups failed.
(pid = 12264) (08/01/22 15:23:35.121892) NMSAP full backup failed.

 

4 Operator

 • 

1.3K Posts

August 12th, 2022 23:00

@pratnaik! Well the issue is pretty clear the reason for the failure is that your authentication is failing. Take a loot at how the HANA_USR_PASSWD has to be set and try again.

crazyrov_0-1660371599008.png

A little more information on how the backup is configured will help us help you better.

No Events found!

Top