Description

When executing a data archiving rule is causing fields to be duplicated on the form of the archived table (or extended tables) This is occurring when the application scope doesn't match between extended tables and parent table. For example, sn_hr_er_case extends sn_hr_core_case, but two are in different application scopes. This caused the program failed to create sys_ui_list and sys_ui_section for archive tables. Due to this problem, we saw duplicate fields in UI forms. This issue impacts releases before Rome.

Steps to Reproduce

Steps to Reproduce

1. On an Quebec instance, Install the HR related plugins a. Human Resources Scoped App: Core (com.sn_hr_core) b. Human Resources Scoped App: Employee Relations (com.sn_hr_employee_relations) c. Human Resources Scoped App: Lifecycle Events (com.sn_hr_lifecycle_events) 2. Create one or more records in "sn_hr_core_case_workforce_admin" table 3. Create an Archive Rule on HR case table (sn_hr_core_case) with a condition to archive a record in "sn_hr_core_case_workforce_admin" table. Make sure that the Application scope is Human Resources: Core Name: Test Application: Human Resources: Core Table: HR Case Condition: Number | is | <number of a record from sn_hr_core_case_workforce_admin table> Active : <checked> Click "Save" Result : 1. Archive rule runs with the errors as shown in the screenshot - InvalidTableError1.PNG 2. Checking the forms : sn_hr_er_case and sn_hr_le_case, we can see duplicate fields in the main section. The form section contains duplicate fields in sys_ui_section

Workaround

Note: Please verify following scripts on a sub-prod instance before applying it to production. The provided background scripts must be run by support engineer who has "maint" role. 1. Login to the instance and make sure the user has "maint" role 2. Go to Scripts - Background, run attached "find_affected_tables.txt" script in "global" scope with "Record for rollback" checked. 3. Open sys log and search for messages start with: "Table with duplicate UI Elements only [dupElementsTables]" "Table with duplicate Form Sections [dupFormSectionTables]" 4. Examine the table list and remove the tables you know that's not part of this problematic archive creation process. 5. Download script "fix_duplicate_fields.txt" and construct "var dupElementsTables" and " var dupFormSectionTables" variables with the lists you get from step 4. 6. Go to Scripts - Background, run modified "fix_duplicate_fields.txt"script in "global" scope with "Record for rollback" checked. 7. Verify the issue is fixed. if not, rollback the script execution in step 6.

Related Problem

PRB1504919