Today we will talk about dump “SYSTEM_SHMCONSTR_LOGON_FAILED”, which you can see below:
In our system, we started getting this dump many times per day after a restart was done in the system. As you can see in the “Error analysis” it mention “The logon failed (rc=”1 (User unknown or password wrong)”).” and we can also see it mention client 000.
The first thing that we are going to do, is to check parameter “rdisp/server_startup/user“, which in this case its values is DDIC. We have to check if DDIC user exists in client 000. For this I don’t have access to client 000, so I will check from HANA Studio.
In the above query, we can see the DDIC in client 000 is locked (UFLAG 64 = Locked by administrator).
To fix this error, we have 2 options.
- Unlock DDIC in all clients for this system (which is not really a good idea)
- Create a new user in every client identical to DDIC, which can be a SYSTEM user without privileges
In this case we will pick option 2 and perform the following steps:
- Create a new user in every client of type SYSTEM without privileges
- Change parameter rdisp/server_startup/user to this new user
- Restart the system
After this steps are performed successfully, the dump should dissapear.
References: 2906703 – SYSTEM_SHMCONSTR_LOGON_FAILED with User DDIC