SAP Knowledge Base Article - Public

3161608 - On Premise + MSSQL - Passwort zurücksetzen geht nicht / Password reset does not work



On Premise + MSSQL - Passwort zurücksetzen geht nicht / Password reset does not work


INLINECustomer Support


Distilled Customer Issue

The customer HS Emden Leer was not able to delete a user on MSSQL and tried to apply the workaround mentioned in CS-160. The affected user did not know her password and tried to get a reset link. We fixed the actual case in a websession.

Cause of the issue

The reset mail was never send, as hibernate got a non-unique exception. This was due to the fact that multiple entries in ResetPasswordInfo for the user account existed. This should not be possible due to a primary key constraint on the corresponding column. In the customers database, the constraint was missing.

How to fix the issue

In order to fix the issue, a liquibase migration has to be created that makes sure that the primary key constraint exists. To enable the key definition, duplicated entries should be purged from the database. In addition, the reason for the missing key should be identified.

Existing Migrations

2009-12-07-2144-1.xml - renameResetPasswordInfo

Christian Schwarz could fix this permanently, but this fix means a lot of work at every future on premise release, which is useless for a rare cas ethat just happened to one customer now (for whom its fixed).. in case more cases happen simply talk to christian and it will be implemented

Related articles

false5KBfalsemodifiedtruepagelabel = "kb-troubleshooting-article" and type = "page" and space = "KB"kb-troubleshooting-article

INLINECustomer Support


Systemmode & VersionTomcat VersionJava VersionBrowserOperation System


On premise

INLINECustomer Support

KCS-Article Status





LabelsLabels ↑

INLINECustomer Support



KBA , BPI-SIG-PM-ONP-DB , Database configuration for SAP Signavio Process Manager , How To


SAP Signavio Process Manager all versions ; Signavio Process Manager all versions