SAP Knowledge Base Article - Public

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

Symptom

Problem

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



Resolution



INLINECustomer Support


redred#ffe6e6INTERNAL TROUBLESHOOTING

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
DeleteOldResetPasswordInfosMigrator.java


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

Environment

Systemmode & VersionTomcat VersionJava VersionBrowserOperation System

Authentication

On premise





INLINECustomer Support

KCS-Article Status


Progress:

BlueINTERNAL

JIRA-Issue:

Title

LabelsLabels ↑




INLINECustomer Support


90722613-c522-393e-972f-edb86d9c14c7SCS-3779



Keywords

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

Product

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