Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-16265

Increase varchar for TYPE_VALUE column on AO_8542F1_IFJ_OBJ_TYPE_ATTR table

XMLWordPrintable

    • 1
    • We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Related with bug: Adding a few groups (or with too many characters on the group name) on User type Attribute of an Object fails silently

      Currently the varchar for TYPE_VALUE column on AO_8542F1_IFJ_OBJ_TYPE_ATTR table is 255.

      If on a User attribute users try to include many groups it fails due the varchar limit.

      Increase the varchar permanently, or to change it to another type such as text.

      Workaround

      Manually increase the varchar of TYPE_VALUE column:

      alter table "AO_8542F1_IFJ_OBJ_TYPE_ATTR" alter column "TYPE_VALUE" type varchar (400);

            [JSDSERVER-16265] Increase varchar for TYPE_VALUE column on AO_8542F1_IFJ_OBJ_TYPE_ATTR table

            Luke Ellis made changes -
            Fix Version/s New: 10.7.2 [ 113126 ]
            Fix Version/s New: 10.3.8 [ 112691 ]
            Fix Version/s New: 11.0.0 [ 111000 ]
            Luke Ellis made changes -
            Status Original: In Progress [ 3 ] New: Waiting for Release [ 12075 ]
            Luke Ellis made changes -
            Status Original: Gathering Interest [ 11772 ] New: In Progress [ 3 ]
            Luke Ellis made changes -
            Assignee New: Luke Ellis [ cfd0dcced0d7 ]
            SET Analytics Bot made changes -
            Support reference count New: 1
            Security Metrics Bot made changes -
            Labels New: ril
            Security Metrics Bot made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 1027367 ]
            Mikaela Teixeira created issue -

              cfd0dcced0d7 Luke Ellis
              a0a054388f60 Mikaela Teixeira
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: