Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-42946

Filter Results gadget's column configuration is lost after upgrade

    XMLWordPrintable

Details

    Description

      Summary

      After upgrading JIRA, the gadgets lose the default columns (issuetype, issuekey, priority, summary) and remain only with the non-default ones configured.
      This happens only when the gadget was using the old method for storing the default values ("--Default--" in gadgetuserpreference table, column userprefvalue)

      Steps to Reproduce

      1. Have a gadget configured with the old configuration used by the default fields
      2. Upgrade JIRA

      Expected Results

      Upgraded JIRA should display all gadgets as they were

      Actual Results

      Gadgets don't have the default columns displayed anymore

      Solution / Workaround

      Workaround 1
      Manually add the columns back

      Workaround 2
      Replace the entities file entries containing the old value with the actual column names.

        • Original:
          <GadgetUserPreference id="10000" portletconfiguration="10000" userprefkey="columnNames" userprefvalue="--Default--|reporter|customfield_10143" />
        • Replaced:
          <GadgetUserPreference id="11158" portletconfiguration="10327" userprefkey="columnNames" userprefvalue="issuetype|issuekey|priority|summary|reporter|customfield_10143" />

      Workaround 3

      1. Run the query in the database :
        select * from gadgetuserpreference where userprefkey = 'columnNames' and userprefvalue like '%--Default--%'
      2. For all those rows returned, verify the values in the older instance and then update the 'userprefvalue' column with the value from old(pre-upgrade) instance.

      Workaround 4 (if you have an xml backup from the pre-upgrade instance)

      1. Generate an xml backup from your instance
      2. Find the parts where the gadgetuserpreference is stored.
      3. Replace this part with the part from the older instance.
      4. Restore the xml backup to the instance

      Attachments

        Issue Links

          Activity

            People

              ohernandez@atlassian.com Oswaldo Hernandez (Inactive)
              malmeida Marcus Silveira
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: