Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-16929

Groups with Long Names Cannot be Added to Site Folders/Documents

    Details

    • Type: Service Pack Request
    • Status: Open
    • Resolution: Unresolved
    • Affects Version/s: 5.1.1, 4.2
    • Fix Version/s: 5.2.N
    • Component/s: Share Application
    • Labels:
      None
    • Bug Priority:
      Category 3
    • ACT Numbers:

      00725681

      Description

      Problem Summary

      Groups with long names (greater than 94 characters) cannot be added to a Site folder or document. The Share GUI allows Groups with names as long as 100 characters. When a group is added to a Site folder or document, Alfresco prefixes the group name with "GROUP_" and attempts to insert the group into the table ALF_AUTHORITY. However the AUTHORITY column is only 100 characters long and an error is raised.

      Steps to Reproduce

      1. Install Alfresco Out of the Box
      2. As Admin via Admin Tools -> Users and Groups -> Groups create a group with a Group name longer than 94 characters (e.g. "this_is_a_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_long_name")
      NOTE: The field´s max length is limitted to 100 characters (see attached maxLength.png)
      3. Create a site
      4. In the site´s document library create a folder or a document
      5. Run the "Manage permissions" action for the folder or document
      6. Attempt to add the group created in step 2 to the folder or document (the role for the group does not matter for this scenario)

      Actual Result

      The below error is reported:
      "Failed to save permissions: Server error . Details can be found in the server logs."
      See also attached errorUI.png.

      Expected Result

      The group should be added successfully.

      Supporting Evidence

      1. This issue was reported by a customer on Alfresco One 4.2.4.15, but the issue also still exists in latest Alfresco One 5.1.1
      2. Attached Alfresco 4.2 logs (alfresco.log) and Alfresco 5.1.1 logs (alfresco-5.1.1.log)
      The logs show the below error:

      ERROR [org.alfresco.repo.web.scripts.RepositoryContainer] [http-apr-8080-exec-6] Server error (09070042)
      org.springframework.extensions.webscripts.WebScriptException: 09070040 Wrapped Exception (with status template): 09070041 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/permissions.post.json.js':
      Error updating database. Cause: org.postgresql.util.PSQLException: 
      ERROR: value too long for type character varying(100)
      The error may exist in alfresco/ibatis/#resource.dialect#/permissions-insert-SqlMap.xml
      The error may involve alfresco.permissions.insert.insert_Authority-Inline
      The error occurred while setting parameters
      SQL: insert into alf_authority (id, version, authority, crc) values (?, ?, ?, ?)
      Cause: org.postgresql.util.PSQLException: 
      ERROR: value too long for type character varying(100)
      

      The Share UI should limit the max length of the Group name while creation (i.e. not limit maxlength to 100 but to 94 in order to add the suffix) or the ALF_AUTHORITY table has to be changed to increase the size of the AUTHORITY column to 106.

        Attachments

        1. alfresco.log
          62 kB
        2. alfresco-5.1.1.log
          35 kB
        3. errorUI.png
          errorUI.png
          96 kB
        4. maxLength.png
          maxLength.png
          254 kB

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  kprakash Kavitha Prakash [X] (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Structure Helper Panel