MySQL attribute_value column, cwd_directory_attribute table can only accept 255 characters

XMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Low
    • None
    • Affects Version/s: 4.4.4, 5.0
    • Component/s: Installation
    • Environment:

      mysql database

    • 4.04
    • 4

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

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

              Created:
              Updated:
              Resolved: