Siebel Remote and Replication Manager Administration Guide > Implementing Siebel Remote Server > Setting Siebel Remote System Preferences >

MRG:Inter Table Conflict Res


In releases prior to Siebel Release 7.7, insert conflicts on intersection tables were handled by creating a duplicate record with a non-zero value in the Conflict ID field. Beginning with Release 7.7, you can choose between available values for this preference to determine how your Siebel Implementation will handle insert conflicts on intersection tables in Enterprise, Regional, and local Siebel databases.

When a record that is involved in an insert conflict is associated with extension records and child records, the extension records and child records undergo the same conflict resolution process as the parent record.

The following paragraphs describe the available values for the MRG:Inter Table Conflict Res system preference:

  • First In. Keeps the existing record, along with its associated extension records and child records. Discards all values from the record for which an insertion was attempted, along with that record's associated extension records and child records.
  • Last In. Replaces the existing record with the record being inserted. Replaces the associated extension records and child records of the existing record with those of the record being inserted.
  • Merge. (Default value) Combines values from both records, along with their extension records and child records. Exact behavior depends on which fields are populated with non-NULL values and on the value of the system preference MRG:Inter Table Merge Rule. For more information, see MRG:Inter Table Merge Rule.

CAUTION:  This system preference should be set before any Mobile Web Clients are extracted. If the preference is changed after extraction, Mobile Web Clients should be re-extracted, otherwise server data and client data may diverge.

Mobile Web Client users can view the results of conflict resolution operations in their local databases by navigating to User Preferences > Remote Status.

Siebel Remote and Replication Manager Administration Guide