Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-28805

Prevent data from exceeding the database limitations when configuring User Directories

XMLWordPrintable

    • We collect Jira 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.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Current it's possible to enter a user object filter or group object filter that exceeds the limitations of the database schema cwd_directory_attribute.attribute_value is a varchar(255). Can you look at adding this limitation into the JIRA GUI to prevent users from encountering a data truncation error in the logs? For example:

      atlassian-jira.log
      ...
Caused by: com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:DirectoryAttribute][directoryId,10100][name,ldap.user.filter][value,(&(objectclass=unicornRider)(!(ou:dn:=Guardians of The Globe))(|(memberof=cn=Lightning Strike Thunderdome,ou=Groups,ou=The Avengers)(memberof=cn=jiradmins,ou=Groups,ou=The Avengers)(memberof=cn=strikeforceone,ou=Groups,ou=The Avengers)(memberof=cn=UAT,ou=Groups,ou=The Avengers)(memberof=cn=myspace,ou=Groups,ou=The Avengers))] (SQL Exception while executing the following:INSERT INTO cwd_directory_attribute (directory_id, attribute_name, attribute_value) VALUES (?, ?, ?) (Data truncation: Data too long for column 'attribute_value' at row 1))
...

      To replicate

      1. Add a new User Directory to JIRA.
      2. Add a very long object or group filter.
      3. Attempt to synchronise, this will fail with a "Data truncation" error.

      Workaround

      Please refer to the Data Truncation due to Data too long for column KB article.

            Unassigned Unassigned
            dcurrie@atlassian.com Dave C
            Votes:
            8 Vote for this issue
            Watchers:
            14 Start watching this issue

              Created:
              Updated:
              Resolved: