Defect #3336
closedWrong provisioning mapping and mixed identifiers after migrating accounts to version 13
100%
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
Related issues
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
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
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?
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.
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