Details

    • Type: Service Pack Request
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 2.2.6
    • Fix Version/s: 2.2.7
    • Component/s: Installer
    • Labels:
      None
    • Environment:
      Alfresco 2.2.5
    • Bug Priority:
      Category 2
    • ACT Numbers:

      14199

      Description

      The update process of the ace to acl_member, ... is taking more than 17 hours.

      UPDATE alf_acl_member mem

      SET ace_id = (SELECT min(ace2.id) FROM alf_access_control_entry ace1

      JOIN alf_access_control_entry ace2

      ON ace1.permission_id = ace2.permission_id AND

      ace1.authority_id = ace2.authority_id AND

      ace1.allowed = ace2.allowed AND

      ace1.applies = ace2.applies

      WHERE ace1.id = mem.ace_id );

      https://issues.alfresco.com/jira/browse/ETWOTWO-561 provided a fix for Mysql db while not for Oracle

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs
                  Reporter:
                  fcorsaro Fabrizio Corsaro [X] (Inactive)
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel