Siebel Remote and Replication Manager Administration Guide > Configuring the Siebel Server > Process of Configuring System Preferences for the Siebel Server >

Configuring System Preferences for Resolving Conflicts

This task is a step in Process of Configuring System Preferences for the Siebel Server.

This topic describes system preferences that you can configure to resolve conflicts.

Setting the Intersection Table Conflict Resolution Field

If a record that is involved in an insert conflict is associated with extension records and child records, then Siebel Remote uses the same conflict resolution process to resolve these records that it uses to resolve the parent record. The user can navigate to the User Preferences screen, and then the Remote Status view to examine the results of conflict resolution operations that reside in the local database.

CAUTION:  For important caution information about setting the Intersection Table Conflict Resolution field, see Caution About Extracting the Server Database.

To set the Intersection Table Conflict Resolution field

• Set the Intersection Table Conflict Resolution field using values from the following table.

  Value	Description
  First In	Keeps the existing record and the associated extension records and child records. Deletes all values from the record where Siebel Remote attempted an insertion. It also deletes the extension records and child records that are associated with the record where Siebel Remote attempted an insertion.
  Last In	Replaces the existing record with the record that Siebel Remote is inserting. Replaces the associated extension records and child records of the existing record with the associated extension records and child records of the record Siebel Remote is inserting.
  Merge	(Default value) Combines values from these records and their extension records and child records. The exact behavior that Siebel Remote uses depends on the fields that it populates with non-NULL values and on the value of the Intersection Table Merge Rule system preference. For more information, see Setting the Intersection Table Merge Rule Field.

Intersection Table Conflict Resolution with Various Siebel Releases

In releases earlier than Siebel CRM version 7.7, Siebel CRM handled an insert conflict on an intersection table by creating a duplicate record with a nonzero value in the Conflict ID field. Beginning with Siebel CRM version 7.7, you can choose between available values for this preference to determine how Siebel CRM handles insert conflicts on intersection tables in enterprise, regional, and local databases. For more information, see About the Siebel Enterprise and the Siebel Enterprise Server.

Setting the Intersection Table Merge Rule Field

The Intersection Table Merge Rule field depends on the following value that you set in the Intersection Table Conflict Resolution field:

• Merge. The Intersection Table Merge Rule field determines the field values that survive when Siebel Remote merges two records to resolve an insert conflict on an intersection table.
• A value other than Merge. Siebel Remote ignores the Intersection Table Merge Rule field.

CAUTION:  For important caution information about setting the Intersection Table Merge Rule field, see Caution About Extracting the Server Database.

For more information about resolving insert conflicts, see Setting the Intersection Table Conflict Resolution Field.

To set the Intersection Table Merge Rule field

1. Set the Intersection Table Conflict Resolution field to Merge.
2. Set the Intersection Table Merge Rule field to one of the following values:
   • First In. (Default value) Siebel Remote applies the following rules to fields in parent records, child records, and associated extension records:
     • Siebel Remote replaces existing NULL values with new, non-NULL values
     • Siebel Remote preserves existing, non-NULL values
   • Last In. Siebel Remote applies the following rules to fields in parent records, child records, and associated extension records:
     • Siebel Remote replaces existing NULL values and non-NULL values with new, non-NULL values.
     • If the corresponding new value is NULL, then Siebel Remote preserves existing, non-NULL values.