Increase varchar for TYPE_VALUE column on AO_8542F1_IFJ_OBJ_TYPE_ATTR table

XMLWordPrintable

    • 1

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

            Assignee:
            Luke Ellis
            Reporter:
            Mikaela Teixeira
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: