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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: