Prevent data from exceeding the database limitations when configuring User Directories

XMLWordPrintable

      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.

              Assignee:
              Unassigned
              Reporter:
              Dave C
              Votes:
              8 Vote for this issue
              Watchers:
              14 Start watching this issue

                Created:
                Updated:
                Resolved: