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

    • 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);  

          Form Name

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

            No work has yet been logged on this issue.

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

                Created:
                Updated: