Ensure tables sys_ux_style and sys_ux_theme are excluded from a clone back"

Hitesh Ramba
Tera Contributor

How can we Ensure tables sys_ux_style and sys_ux_theme are excluded from a clone back" . I am unable to understand this .I think because of this i am unable to add required  header color to my  instance. Can someone help me in this..
Thank You!!

1 REPLY 1

Community Alums
Not applicable

Hi @Hitesh Ramba  ,

The System Clone > Exclude Tables module lists the tables that are not copied during a system clone. By default, the system excludes tables for logging, auditing, notifications, workflow contexts, and license usage.

Note: Excluded workflow context data includes records stored in the wf_context table, and in related tables with names starting with a prefix of wf_. This also includes the workflow scheduler table. This prevents occurrence of workflow timer syncing issues that might take place due to the length of the cloning process if workflow contexts were included.

sys_db_object and sys_db_object.* cannot be added to the exclusions.

When excluding child tables of the Task table, which use the table per hierarchy extension model, child tables are excluded. You do not need to exclude the parent Task table together with the child table.

You can use wildcards to exclude several tables from cloning with one entry. For example, sys_script.* excludes all tables starting with sys_script.
Note: The wildcard has to include the dot '.' before the asterisk.

To preserve the existing data on the target instance, see Create a data preserver. Data on tables that reference the table, such as business rules, is not excluded.

To preserve or exclude related tables, you must preserve and exclude all of the following tables. If any of the tables are missed, the customer may not able to log in to the instance after a clone.
  • sys_user
  • sys_user_role
  • sys_user_group
  • sys_user_grmember
  • sys_group_has_role
  • sys_user_role_contains
  • customer_contact (if the Customer Service Management plugin is active)

Procedure

  1. On the source instance, navigate to System Clone > Exclude Tables.
  2. Select New.
  3. Enter the table Name.
    Entering a parent table results in the clone process also excluding its child tables. For example, excluding the Task table would also exclude the Change, Incident, and Problem tables.
  4. Select Submit.