Creating an ObjectType attribute of Type "Default" without "Type Value" makes all the attributes of the ObjectType unavailable

XMLWordPrintable

    • 5
    • Severity 2 - Major
    • 1

      Issue Summary

      When we create an ObjectType attribute of Type "Default" without selecting any "Type Value". All the attributes of the ObjectType become unavailable. Existing Objects can't be edited and we can't create any new objects as well.

      This is reproducible on Data Center: Yes

      Steps to Reproduce

      1. Select any ObjectType
      2. Click "Attributes"
      3. Add a new attribute of "Type" as "Default" and "Type Value" as empty and click "Add"

      Expected Results

      The new attribute should not get added giving an error message that "The Value is invalid" and the attribute should not be created.

      Actual Results

      The new attribute gets created with invalid "DEFAULT_TYPE_ID" value of "-1" in the "AO_8542F1_IFJ_OBJ_TYPE_ATTR" table

      Workaround

      1. Shutdown Jira
      2. Update "DEFAULT_TYPE_ID" value to 0 (Which implies the type Text) in the table "AO_8542F1_IFJ_OBJ_TYPE_ATTR" for the respective attribute where "DEFAULT_TYPE_ID" value is set to "-1"
      3. Start Jira
      4. Perform Clean Re-Index of Insight

      SQL warning:
      Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first. Database modifications are not included in Atlassian Support Offerings

        1. ObjectType_Attr.mov
          13.58 MB
          Prabhu Subramaniyan

            Assignee:
            Benjamin Suess
            Reporter:
            Prabhu Subramaniyan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: