This article explains how to fix the a sprint's activated date which is not exported while during migration but only exports the start date is exported.
Problem
After a snapshot & deployment, the start sprint dates are not correct.
Instructions
...
showing correctly.
Cause
The Configuration Manager for Jira (CMJ) app does not export the sprint's activated date, it only exports the start date. The same date is set as start and activated dates during import.
Example
Execute the below query, and it shows incorrect results.
Code Block |
---|
SELECT * FROM "AO_60DB71_SPRINT" WHERE "STARTED" = true and "NAME" like '%abc%' |
All affected sprints are ending START_DATE with four 0000s.
Info |
---|
CLOSED COMPLETE_DATE END_DATE GOAL ID NAME RAPID_VIEW_ID SEQUENCE STARTED START_DATE ACTIVATED_DATE AUTO_START_STOP SYNCED |
Solution
Generate the mapping of the configuration objects' native IDs from the snapshot to the matched objects' IDs from the current system.
This could be done by enabling the "Persist deployed snapshot to current system native ID mappings" setting in CMJ's general settings page before deployment- https://appfire.atlassian.net/wiki/spaces/CMJ/pages/82775728/General+Settings
Use the generated JSON file to check the mapping of the sprints after the deployment.
Update the activated date of the target sprints in the AO_60DB71_SPRINT database table for the corresponding sprints in the target system to the sprints in the source instance by using the ALTER command on the AO_60DB71_SPRINT table.