Dump error: SYSTEM_SHMCONSTR_LOGON_FAILED

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.

1. Unlock DDIC in all clients for this system (which is not really a good idea)
2. 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:

1. Create a new user in every client of type SYSTEM without privileges
2. Change parameter rdisp/server_startup/user to this new user
3. Restart the system

After this steps are performed successfully, the dump should dissapear.

References: 2906703 – SYSTEM_SHMCONSTR_LOGON_FAILED with User DDIC