-
Bug
-
Resolution: Fixed
-
Medium
-
6.1.5, 6.2, 6.2.7, 6.3.7, 6.3.14, 6.4, 6.4.5, 6.4.13, 7.1.1, 7.1.8, 7.2.3, 7.1.9
-
6.01
-
52
-
Severity 3 - Minor
-
44
-
-
Steps to Reproduce:
Create a User Directory with a User/Group filter larger than 255 chars.
Expected Results:
JIRA should give an error on the same screen explaining the value is too big
Actual Results:
JIRA throws a "We had some technical problems during your last operation.
We deeply apologize for that " error page with the response from the database
Request processing failed; nested exception is com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:DirectoryAttribute][directoryId,10001][name,ldap.user.filter][value,(&(objectCategory=Person)(sAMAccountName=*)(|(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)(memberof=cn=lerolero,dc=lero,dc=com)))] (SQL Exception while executing the following:INSERT INTO public.cwd_directory_attribute (directory_id, attribute_name, attribute_value) VALUES (?, ?, ?) (ERROR: value too long for type character varying(255)))
Workaround
Note: Before trying these steps, it is very important to both create a backup of your SQL data as well as to then stop Jira before trying these steps. Take a note of the configuration as well as there are multiple cases that have reported that the configuration will be missing after increase the column size.
It is currently possible to work-around this issue by following the steps in the KB Data truncation due to data too long for column - Atlassian Documentation.
- Create a backup of your SQL data in Jira. Backing up data - Atlassian Documentation has details on how to do this, but Atlassian recommends using the native database backup tools for this instead of relying upon the XML backup.
- Stop Jira
- You can then run the following SQL commands against the database to change these column sizes (this syntax is correct for postgresql, other versions of SQL might have a different syntax)
alter table cwd_directory_attribute alter column attribute_value type varchar (400);
Note: this example expands the column to accept 400 characters in this case. You might need a larger value here should your filter be still greater than this.
- Start Jira
- is duplicated by
-
JRASERVER-26349 Increase the user object filter length in LDAP directories
- Closed
- is related to
-
JRASERVER-36916 Add input validation for length of entries into the Object filter fields in LDAP Configuration
- Closed
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
- relates to
-
RAID-929 Loading...
- was cloned as
-
EMBCWD-959 Loading...
-
JSB-8 Loading...