Uploaded image for project: 'Jira Software Server and Data Center'
  1. Jira Software Server and Data Center
  2. JSWSERVER-13098

JIRA Agile doesn't delete rank from table when the Custom Field was deleted

    XMLWordPrintable

    Details

      Description

      Summary

      JIRA Agile doesn't delete rank data from AO_60DB71_LEXORANK table when the Custom Field was deleted

      Steps to Reproduce

      1. Follow KB Remove+Duplicate+LexoRank and delete duplicated Agile Rank data.
      2. Check AO_60DB71_LEXORANK table
        select "FIELD_ID",count("FIELD_ID") from "AO_60DB71_LEXORANK" group by "FIELD_ID";
        
      3. Check AO_60DB71_LEXORANKBALANCER table
        select "FIELD_ID" from "AO_60DB71_LEXORANKBALANCER";

      Expected Results

      Data with single FIELD_ID

      select "FIELD_ID",count("FIELD_ID") from "AO_60DB71_LEXORANK" group by "FIELD_ID";
           15200	      854577
      
      select "FIELD_ID" from "AO_60DB71_LEXORANKBALANCER";
           15200
      

      Actual Results

      Data with multiple FIELD_ID:

      select "FIELD_ID",count("FIELD_ID") from "AO_60DB71_LEXORANK" group by "FIELD_ID";
           15200	      854577
           15201	      822690
      
      select "FIELD_ID" from "AO_60DB71_LEXORANKBALANCER";
           15200
           15201
      

      Notes

      Potentially fixed in JIRA Software 7.0.4.
      To check current Agile custom fields:

      // List Agile customfields
      select * from customfield where customfieldtypekey like 'com.pyxis.greenhopper.jira%';
      
      // Default lexorank field
      SELECT propertyvalue FROM propertyentry LEFT JOIN propertynumber ON propertyentry.ID = propertynumber.ID WHERE property_key = 'GreenHopper.LexoRank.Default.customfield.id';
      

      Workaround

      Stop JIRA and delete data manually.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              ayakovlev@atlassian.com Andriy Yakovlev
              Votes:
              11 Vote for this issue
              Watchers:
              15 Start watching this issue

                Dates

                Created:
                Updated: