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

AGS to path with no retention results in node with two primary parents

    Details

    • Type: Hot Fix Request
    • Status: Closed
    • Resolution: Resolved
    • Affects Version/s: AGS 3.2.0.1
    • Fix Version/s: None
    • Component/s: Records Management
    • Labels:
      None
    • Environment:
      Using MySql 5.7.28 or MariaDB

      ACS 6.2.2 and AGS 3.3.1
      ACS 6.1.0 with AGS 3.1.0
    • Bug Priority:
      Category 1
    • Hot Fix Version:
      AGS 3.3 (ACS 6.2.2)
    • ACT Numbers:

      01009939

    • Delivery Team:
      Customer Excellence

      Description

      Issue/Use Case

      The goal is to create a folder in a Share site utilizing folder rule and action, that will, (a) when you drop a folder in that folder, declare the dropped file to be a record and file that record (creating the path as necessary) into the appropriate directory in the file plan. When it was set up this way, however, Alfresco throws an error in the logs that says:

      2020-06-09 20:23:36,681 ERROR [node.ibatis.NodeDAOImpl$MySQL] [http-nio-8080-exec-39] ALF-13066: Orphan child node has been re-homed under lost_found: (3102940, workspace://SpacesStore/500aba12-1d60-4be9-8742-7398aedf2e09)

      The dropped file then has two primary parents. The node can't be inspected or deleted with the node browser. The folder containing the node doesn't render in Share.

      (Note: This does not happen with PostgreSQL, seems to only break with MySQL or MariaDB.)

      Steps to reproduce

      • Set up Alfresco 6.1.0 with AGS 3.1.0 using MySql 5.7.28.
      • Create a RM site (standard compliance)
      • Create a Share site (mine was private and named "test")
      • Create a folder in the test site named "drop"
      • Create a folder in the test site named "docs"
      • Go to the RM site and manage rules for the "Unfiled Records" folder
        • Create a rule
        • Name the rule "file record"
        • Add an action for "complete record"
        • Add another action for "file to"
        • Set the Record Folder Location to /{node.cm:description}/Electronic Records/ {date.year.long} {date.month.number}
        • Check "Create Full Path to Folder"
        • When reproduced the error, the target folder did not exist.
        • You can check or uncheck Run in Background checkbox. It still reproduces the issue. 
        • Save the rule
      • Go to the "test" site and manage rules for the "drop" folder
        • Create a rule
        • Name the rule "declare record"
        • Add an action for "declare as a record"
        • Leave "Record Folder Location" blank
        • Check "Hide Record" (enable hiding of records)
        • Note: You can check or uncheck Run in Background checkbox. It still reproduces the issue. 
        • Save the rule 
      • In the "docs" folder of the "test" site create a plain text file named "test.txt" with the description "foo"
      • Move the "test.txt" file from the "docs" folder to the "drop" folder.

      Expected Behavior
      A node will be declared as record, hidden, whilst a new folder is created, then the record will be moved into that new location.

      Observed Behavior
      Either the node attempts to move and eventually fails, or the node completes but has two parent nodes which corrupts it, which following symptoms: 

      1. MariaDB and MySQL break during this process

      (a) This break could mean that the system freezes and finally allows the move of the document to fail gracefully

      OR 

      (b) The break allows the move, but provides two parents for the node, thus corrupting the node.

      2. This can be reproduced in both:

      • ACS 6.2.2 and AGS 3.3.1
      • ACS 6.1.0 with AGS 3.1.0 

      Workaround 
      None 

        Attachments

          Structure

            Activity

              People

              • Assignee:
                closedissues Closed Issues
                Reporter:
                rholt Richard Holt [X] (Inactive)
              • Votes:
                1 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Structure Helper Panel