...
Execute the below query, and it shows incorrect results.
...
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Page Properties | ||
---|---|---|
| ||
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 [General Setting|https://botronsoft.atlassian.net/wiki/spaces/CMJ/pages/33456130/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.