Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Execute the below query, and it shows incorrect results.

...

Content by Label
showLabelsfalse
max5
spacesPS
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "cmj" and type = "page" and space = "PS"
labelscmj

Page properties
hiddentrue
Related issues
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
true 1621347556218 1621411320000 null 303 abc sprint 1 111 null true 1620201720000 null false false
true 1622556888736 1622557080000 306 abc sprint 2 111 null true 1621430280000 null false false

Solution

  1. Generate the mapping of the configuration objects' native IDs from the snapshot to the matched objects' IDs from the current system.

  2. 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]

    Image Added

  3. Use the generated JSON file to check the mapping of the sprints after the deployment.

  4. 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.