List of preserve and exclude tables for cloning

When installing Service Exchange, certain tables must be preserved or excluded to maintain connectivity after a clone.

If the default system profile is used, some of the Service Exchange table data isn’t preserved. To address this issue, you must create a custom clone profile with specific settings required for Service Exchange. Navigate to All > System Clone > Clone Profiles and select New to create a custom profile. For more details on clone profiles, see Create a custom clone profile. In this profile, you must:

• Remove the Remote Process Sync Disable Records script from the Cleanup scripts related list,
• Validate if the following Service Exchange tables are included in the custom profile.

주:

After a clone, you must reestablish the connection and activate the Capture Definitions. See Reestablish connection after a clone for a provider and Reestablish connection after a clone for a consumer.

Service Exchange tables to preserve

Add the following Service Exchange tables to the Clone Profile Preservers list if they’re missing. Remove any Service Exchange tables that aren’t in this list.

표 1. Preserve or exclude table

	Preserve Tables	Exclude Tables
Global	catalog_ui_policy catalog_ui_policy_action ih_sync_capture_definition ih_sync_definition ih_sync_inbound_definition ih_sync_outbound_definition ih_sync_process_event ih_sync_remote_system item_option_new sc_cat_item_catalog sc_cat_item_category sc_cat_item_user_criteria_mtom sc_cat_item_user_criteria_no_mtom sc_category scan_finding scan_task sn_sb_con_entitlement sn_sb_error sn_sb_known_error_code sn_sb_con_provider_connection sn_sb_con_provider_task sn_sb_release sn_sb_remote_script_approval sn_sb_rps_connection sn_sb_service_bridge_settings sn_sb_transform_line sn_transport_queue sn_fds_pro_consumer_criteria sn_fds_pro_inbound_offering_item sn_fds_pro_offering_item sn_fds_con_outbound_offering sn_fds_con_outbound_subscription	ih_sync_capture_definition ih_sync_definition ih_sync_inbound_definition ih_sync_outbound_definition ih_sync_process_event ih_sync_remote_system scan_finding scan_task sn_sb_error sn_sb_pro_persona sn_sb_remote_task sn_sb_rps_connection sn_sb_service_bridge_settings sn_sb_transform_line sn_fds_pro_consumer_criteria sn_fds_pro_inbound_offering_item sn_fds_pro_inbound_subscription sn_fds_pro_offering_item sn_fds_con_m2m_company_offering sn_fds_con_outbound_offering_item sn_fds_con_outbound_subscription
Base	sn_sb_authorized_user sn_sb_error sn_sb_identity sn_sb_known_error_code sn_sb_provider_task sn_sb_release sn_sb_remote_script_approval sn_sb_remote_task sn_sb_scratchpad sn_sb_service_bridge_settings sn_sb_transform_line	sn_sb_authorized_user sn_sb_connection sn_sb_entitlement sn_sb_error sn_sb_identity sn_sb_provider_task sn_sb_remote_record_producer sn_sb_remote_script_approval sn_sb_remote_task sn_sb_scratchpad sn_sb_service_bridge_settings sn_sb_transform_line
Provider	sn_sb_pro_authorized_user sn_sb_pro_consumer_connection sn_sb_pro_entitlement sn_sb_pro_provider sn_sb_pro_provider_task sn_sb_pro_registration sn_sb_pro_remote_choice_definition sn_sb_pro_remote_record_producer sn_sb_pro_remote_service sn_sb_pro_remote_task sn_sb_pro_remote_task_variable sn_sb_pro_service_bridge_settings sn_sb_pro_transform	sn_sb_pro_inbound_field sn_sb_pro_outbound_field sn_sb_pro_provider sn_sb_pro_registration sn_sb_pro_remote_record_producer_consumer_criteria sn_sb_pro_remote_task_def sn_sb_pro_remote_task_def_consumer_criteria sn_sb_pro_remote_task_variable sn_sb_pro_transform
Consumer	sn_sb_con_authorized_user sn_sb_con_consumer sn_sb_con_entitlement sn_sb_con_inbound_field sn_sb_con_outbound_field sn_sb_con_provider_task sn_sb_con_remote_record_producer sn_sb_con_remote_task sn_sb_con_remote_task_def sn_sb_con_remote_task_variable sn_sb_con_service_bridge_settings sn_sb_con_transform	sn_sb_con_consumer sn_sb_con_inbound_field sn_sb_con_outbound_field sn_sb_con_persona sn_sb_con_remote_task_def sn_sb_con_remote_task_variable sn_sb_con_transform
Remote Process Sync Transport	sn_sb_rps_connection (Provider only)	sn_sb_rps_connection (Provider only)
Transporter	sn_transport_profile* sn_transport_queue*	N/a
Employee Profile	user_criteria sys_alias sys_user sys_user_has_role	sys_alias
Foundation Data Sync	sn_fds_data_processing_queue sn_fds_offering sn_fds_offering_item sn_fds_request sn_fds_subscription sn_fds_subscription_item	sn_fds_data_processing_queue sn_fds_offering_item sn_fds_subscription sn_fds_subscription_item
Foundation Data Sync for Providers	sn_fds_pro_inbound_offering_request sn_fds_pro_offering sn_fds_pro_offering_request	sn_fds_pro_inbound_offering sn_fds_pro_inbound_offering_request sn_fds_pro_inbound_subscription_item sn_fds_pro_offering sn_fds_pro_subscription sn_fds_pro_subscription_item
Foundation Data Sync for Consumers	sn_fds_con_offering sn_fds_con_offering_item sn_fds_con_offering_request sn_fds_con_outbound_offering_request sn_fds_con_subscription sn_fds_con_subscription_item	sn_fds_con_offering_item sn_fds_con_subscription sn_fds_con_subscription_item
Health	sn_sb_issue sn_sb_health_connection_stats sn_sb_health_issue	sn_sb_issue sn_sb_health_connection_stats sn_sb_health_issue

"*" - Applicable for both provider and consumer.