Siebel Remote and Replication Manager Administration Guide > Client-Side Merge Issues on the Server >

Solution

This section describes the solution and how to repair the client-side merge problem.

The solution is to provide the ability to repair orphaned data on the server. To do this you will use the following:

• Log all merge transactions on the server
• Use a batch process to reassociate orphaned child records with the appropriate parents using the log
• A view that shows the content of the log for administration and system management

For organizations with the client-side merge problem, use the following procedures to repair the orphaned child records.

To turn on CSM Logging

1. From the application-level menu, choose Navigate > Site Map > Administration - Application screen.
2. In the link bar, select System Preferences.
3. Select System Preference Name=CSM Logging.
4. Set the System Preference Value=TRUE.
5. Restart the Siebel Server.

   This allows system preferences to take effect.

6. Restart the Siebel Remote components.

   See Starting and Stopping Siebel Remote Server Components.

The next step should be to create a workflow process that calls the appropriate business service. Create a workflow process that calls the CleanUp business service. To control the size of this log, create another workflow process to remove old merge transactions.

The following two procedures describe how to create these workflows. Two workflows should be created for each method of CSM Log Service.

To repair orphaned child records

This is also called the CleanUp () function.

1. Create a workflow with three steps: Start, CleanUp, and End.

   See Siebel Business Process Designer Administration Guide for details on how to create workflows.

2. For the CleanUp step, set the following:
   1. Set Business Service to CSM Log Service.
   2. Set Method to CleanUp.
   3. There is no input argument or output argument for this method.

To delete entries in the CSM log

This is also called the RemoveOldEntry () function.

1. Create a workflow with three steps: Start, RemoveOldEntry, and End.

   See Siebel Business Process Designer Administration Guide for details on how to create workflows.

2. For the RemoveOldEntry step, set the following:
   1. Set Business Service to CSM Log Service.
   2. Set Method to RemoveOldEntry.
3. Create one input argument and set Input Argument=TransactionId.
4. Find the value of this input argument in the CSM Log View.

   This workflow deletes records in the CSM Log table that have a transaction ID smaller than the input argument.

To run a workflow from the command line

1. From a DOS (or shell) prompt, change the current directory to:

   <Siebel Installation directory>\siebsrvr\bin

2. Enter:

   srvrmgr /g <gateway> /e <enterprise> /s <siebsrvr> /u <username> /p <password>

3. To run wfprocmgr, enter:

   start task comp wfprocmgr with ProcessName="<Workflow Name>"

Administrators determine how frequently to repair orphaned child records and delete CSM log entries. Typically, the frequency should be determined by how often Merging is used to clean up duplicate entries.