Details
-
Bug
-
Resolution: Duplicate
-
Low
-
None
-
5.0, 4.4.4
-
mysql database
-
4.04
-
4
-
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
- duplicates
-
JRASERVER-24799 Crowd Directory Attributes can exceed 255 chars, causing problems for long but valid LDAP filter strings
- Closed