Bookshelf Home | Contents | Index | PDF |
Siebel Remote and Replication Manager Administration Guide > Troubleshooting Siebel Remote > Using Troubleshooting Utilities > Using the Endtxnutl Utility to Adopt Orphaned RecordsThis topic describes how to use the Endtxnutl utility to create parent records so that orphan records synchronize. A database transaction can create an orphan record, which is a child record that is not associated with a parent record. The Transaction Processor server component treats an orphan record as an incomplete transaction that Siebel Remote must not synchronize. Orphan records also cause the transaction log table (S_DOCK_TXN_LOG) to grow, which can degrade performance. It is recommended that you use the Endtxnutl utility regularly, choosing an appropriate frequency that depends on the rate at which data traffic creates orphan records. You can run endtxnutl as often as you require without interrupting normal Siebel Remote operations. By default, endtxnutl runs one time every 24 hours. For more information about the Endtxnutl utility and orphan records, see 478182.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 634. Also see Troubleshooting Steps 38 on My Oracle Support. To use the Endtxnutl utility to adopt orphaned records
The following is an example of a typical command that runs the Endtxnutl utility: endtxnutl /u sadmin /p sadmin /a siebsrvr78 /o d:\endtxnutl.out
How the Endtxnutl Utility Finds an Adoptive ParentThe Endtxnutl utility scans the S_DOCK_TXN_LOG table for transactions that do not contain a committed parent transaction and that are at least a set number of hours old. For each transaction that meets these criteria, endtxnutl inserts a dummy parent transaction in the transaction log. When the Transaction Processor detects the inserted parent transactions, it processes the child records correctly. Situations That Create OrphansThe following situations might result in the creation of an orphan record:
Querying for Orphan RecordsTo inspect orphan records in the server database, you can use an SQL query. This query locates rows in the S_DOC_TXN_LOG table that meet any of the following conditions:
|
Siebel Remote and Replication Manager Administration Guide | Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |