Symptom
- Cannot create an SAC user after deleted an user with the same email id before.
- This issue is only happens for this specific email.
- The following error is shown when tried to add a new user with this email:
dberror(PreparedStatement.executeUpdate): 4240 - Duplicate identity for this provider: line 1 col 34 (at pos 33)
Correlation ID: XXXXXXX-XXXX-XXXX-XXX-XXXXXXXXXXX
Environment
- SAP Analytics Cloud (Enterprise) 2022.8.17
Reproducing the Issue
- Logon SAC.
- Try to add a new user with email which was deleted before.
- Failed to add this user with the below error:
dberror(PreparedStatement.executeUpdate): 4240 - Duplicate identity for this provider: line 1 col 34 (at pos 33)
Correlation ID: XXXXXXX-XXXX-XXXX-XXX-XXXXXXXXXXX
Cause
A user with the same email was not deleted properly.
Resolution
The issue is under investigation by developer group.
See Also
Please create a support case under LOD-ANA-LS and mention this KBA.
Keywords
remove delete add create user email address , KBA , LOD-ANA-LS , Licensing and Full User Equivalent , Problem
Product
SAP Analytics Cloud 1.0