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

MySQL attribute_value column, cwd_directory_attribute table can only accept 255 characters

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Low
    • None
    • 5.0, 4.4.4
    • Installation
    • mysql database

    Description

      Adding a user directory fails in JIRA, on the User Schema User object filter when entering more than 255 chars resulting in the following error:

      Request processing failed; nested exception is com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:DirectoryAttribute][directoryId,10001][name,ldap.user.dn][value,((objectClass=user)(|(memberOf=cn=departmentdevfte,ou=enterprise distribution groups,ou=msg,OU=ENT,DC=ent,DC=abc,DC=co,DC=corp)(memberOf=cn=devcontractors,ou=enterprise distribution groups,ou=msg,OU=ENT,DC=ent,DC=abc,DC=co,DC=corp)(memberOf=CN=devtools,OU=Enterprise Distribution Groups,OU=MSG,OU=ENT,DC=ent,DC=abc,DC=co,DC=corp)))] (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))
      

      The following is a workaround for this to allow for more characters in that column:

      alter table cwd_directory_attribute modify attribute_value VARCHAR(400) ; 
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mandreacchio Michael Andreacchio
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: