-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 7.0.2 CE GA3, 7.0.0 DXP SP2, 7.0.0 DXP FP13
-
Fix Version/s: 7.0.0 DXP FP25, 7.0.X EE, 7.0.4 CE GA5, Master
-
Component/s: WCM
-
Branch Version/s:7.0.x
-
Backported to Branch:Committed
-
Story Points:1.5
-
Fix Priority:4
-
Git Pull Request:
UpgradeJournalArticleImage.updateJournalArticleImagesInstanceId() can fail with unique constraint violation.
JournalArticleImage has IX_103D6207 unique index on groupId, articleId, version, elInstanceId, elName, languageId and set elInstanceId for records which miss it based on articleId and elName which is not unique, so we might end up setting the same elInstanceId for multiple records and get the constraint violation error.
Caused by LPS-63727 which aimed to fix the same problem, but seems like it didn't fix it for every case. Error is the same.
- causes
-
LPS-75090
During upgrade, inconsistent elinstanceid values are assigned to JournalArticleImage
- Closed
- is duplicated by
-
- Closed
- is fixed by
-
LPS-79651
Duplicate entry exceptions for index IX_103D6207
- Closed
- is related to
-
LPS-63727
"Duplicate entry for key 'ix_103d6207'" is thrown when upgrading from 6.2 to master
- Closed