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

Details

    • 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.

    Description

      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.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-24799 Crowd Directory Attributes can exceed 255 chars, causing problems for long but valid LDAP filter strings

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-19990 Data truncation error when entered a long URL custom field which breaks the Move Issue process

          • Low - Low priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-24526 Upgrading to JIRA 4.3 fails if connecting to Crowd, and a directory description is longer than 256 characters.

          • Low - Low priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-13329 Error when adding a group with name longer than 60 characters to a notification scheme: too long for database column

          • Medium - Medium priority issues
          • Gathering Impact

          Suggestion - JRACLOUD-28805 Prevent data from exceeding the database limitations when configuring User Directories

          • Closed
          mentioned in

          Page Loading...

          Page Loading...

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: