Project

General

Profile

Actions

Defect #3336

closed

Wrong provisioning mapping and mixed identifiers after migrating accounts to version 13

Added by Alena Peterová over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
Peter Štrunc
Category:
Account managment
Target version:
Start date:
04/17/2023
Due date:
% Done:

100%

Estimated time:
Affected versions:
Owner:

Description

After migrating account with the SQL: https://github.com/bcvsolutions/CzechIdMng/blob/develop/MIGRATION.md#-database (from #3309), provisioning of accounts (entity event IdmIdentity NOTIFY) fails with an exception saying "Duplicate uid for account! Uid [honza] already exists. Change uid for account [65d5aa06-8613-4845-9616-812f7cce14a3] on system [f007c3d4-5e50-49ce-8fd2-09564b7afcb3] in mapping [4935b66a-839d-4020-a25a-b35099f8a5d9]"

The cause is probably the provisioning mapping for the account, which was set to some mapping from a different system by the migration script. (I have "LDAP CAS" and multiple other connected systems - DB, virtuals. The mapping should be "LDAP provisioning", but it is "Default provisioning" from one of the virtuals.)

Please improve the SQL migration script. Also, it would be safer if the SQL changed only records with system_mapping_id=null (after repeatedly running the SQL, new accounts got also broken).


Files

honza_mapping.png (71.7 KB) honza_mapping.png Alena Peterová, 04/17/2023 12:51 PM

Related issues

Related to IdStory Identity Manager - Defect #3309: Undefined account type: new group or password is not provisioned, account can't be edited after upgrade to 13ClosedTomáš Doischer03/22/2023

Actions
Actions #1

Updated by Alena Peterová over 1 year ago

  • Related to Defect #3309: Undefined account type: new group or password is not provisioned, account can't be edited after upgrade to 13 added
Actions #2

Updated by Alena Peterová over 1 year ago

  • Description updated (diff)
Actions #3

Updated by Tomáš Doischer over 1 year ago

  • Sprint set to Sprint 13.1-5 (dub 19 - kvě 03)
  • Target version set to 13.0.4
Actions #4

Updated by Peter Štrunc over 1 year ago

  • Status changed from New to In Progress
Actions #5

Updated by Peter Štrunc over 1 year ago

  • Status changed from In Progress to Needs feedback
  • Assignee changed from Peter Štrunc to Alena Peterová
  • % Done changed from 0 to 80

Fixed and tested.
PR: https://github.com/bcvsolutions/CzechIdMng/pull/386
@apeterova could you check it out, please?

Actions #6

Updated by Alena Peterová over 1 year ago

Tested locally, it works well, thanks!
Please merge the pull request, I don't have permission to do it.

Actions #7

Updated by Peter Štrunc over 1 year ago

  • Status changed from Needs feedback to Closed
  • Assignee changed from Alena Peterová to Peter Štrunc
  • % Done changed from 80 to 100

Merged to develop. Cherry-picked to 13.0.4

Actions

Also available in: Atom PDF