Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
9
-
Description
Problem Definition
Misalignment on some calendars will cause failure during the space/calendar import to Cloud
Suggested Solution
Add preflight check for Team Calendars to handle the misalignment between the calendars.
Why this is important
To avoid error during the import
Workaround
- SQL query to identify the mismatched calendars, on Confluence on-prem:
select sub."ID" as child_id,sub."NAME" as child_name,sub."SPACE_KEY" as child_space,parent."ID" as parent_id,parent."NAME" as parent_name,parent."SPACE_KEY" as parent_space from "AO_950DC3_TC_SUBCALS" sub join "AO_950DC3_TC_SUBCALS" parent on parent."ID"=sub."PARENT_ID" where sub."PARENT_ID" is not null and sub."SPACE_KEY" is not null and sub."SPACE_KEY" != parent."SPACE_KEY";
- Sample output:
Child Calendars from line 1 & 4 will not be migrated to Cloud as the Parent Calendar is not associated to any space
Child Calendars from line 2 & 3 will cause ERROR: duplicate key value violates unique constraint "AO_950DC3_TC_SUBCALS_pkey" error during the import, because the Space Key isn't aligned with the Parent Calendar's.
- Sample output:
- SQL to fix the mismatched calendars, before the migration:
- Line 1 & 4 scenario - Update "SPACE_KEY" of Parent Calendar, so the parent calendar is migrated with target space
UPDATE "AO_950DC3_TC_SUBCALS" SET "SPACE_KEY"='ABC' WHERE "ID"='<id_of_parent_calendar>';
- Line 2 & 3 scenario - Set the "SPACE_KEY" to null on the child calendar, so it is migrated with its parent calendar under the same space
UPDATE "AO_950DC3_TC_SUBCALS" SET "SPACE_KEY"='ABC' WHERE "ID"='<id_of_child_calendar>';
- Line 1 & 4 scenario - Update "SPACE_KEY" of Parent Calendar, so the parent calendar is migrated with target space
Attachments
Issue Links
- relates to
-
CONFCLOUD-77425 CCMA fails to migrate space with team calendars due to duplicate event type key
- Closed
-
CONFCLOUD-77903 Deleting a migrated space may not delete all team calendars associated with that space
- Gathering Impact