Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
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.
- Navigate to the Application Administration screen and from the Show drop-down list, click System Preferences.
- Select System Preference Name=CSM Logging.
- Set the System Preference Value=TRUE.
- Restart the Siebel Server.
- Restart the Siebel Remote 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.
- Create a workflow with three steps: Start, CleanUp, and End.
See Siebel Business Process Designer Administration Guide for details on how to create workflows.
- For the CleanUp step, set the following:
To delete entries in the CSM log
This is also called the RemoveOldEntry () function.
- Create a workflow with three steps: Start, RemoveOldEntry, and End.
See Siebel Business Process Designer Administration Guide for details on how to create workflows.
- For the RemoveOldEntry step, set the following:
- Create one input argument and set Input Argument=TransactionId.
- 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
- From a DOS (or shell) prompt, change the current directory to:
- Enter:
srvrmgr /g <gateway> /e <enterprise> /s <siebsrvr> /u <username> /p <password>
- 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.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Remote and Replication Manager Administration Guide Published: 19 November 2003 |