Using the Endtxnutl Utility to Adopt Orphaned Records

This 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 type of 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 and degrade performance.

It is recommended that you frequently use the Endtxnutl utility, depending on how frequently the data traffic creates orphan records. You can run endtxnutl as often as you require without interrupting Siebel Remote operations. Siebel Remote runs endtxnutl one time every 24 hours, by default.

For more information about:

• The Endtxnutl utility and orphan records, see 478182.1 and 477816.1 (Article ID) on My Oracle Support. These documents were previously published as Siebel Technical Note 634 and Siebel Troubleshooting Steps 38, respectively.

• The S_DOCK_TXN_LOG table, see Modifying the S_DOCK_TXN_LOG Table.

To use the Endtxnutl utility to adopt orphaned records

1. Configure parameters for the session.

   For more information, see Configuring Session Parameters for a Utility.

2. To run the Endtxnutl utility, enter the following command in a single line:

   endtxnutl /u username /p password /a Siebel_server_name /T minimum_transaction_age_in_hours /o output_file_name
   

   Use parameters described in the following table.

   Parameter	Required	Description
   u username	Required	The login name for the administrator.
   p password	Required	The password for the administrator.
   a Siebel_server_name	Required	The name of the remote server that the Endtxnutl utility uses to scan for transactions in the S_DOCK_TXN_LOG table that include routing and docking information.
   t minimum_transaction_age_in_hours	Optional	The Endtxnutl utility runs only on orphan records from transactions that Siebel Remote started at least by the number of hours that you specify in this parameter. The default value is 24. The range of acceptable values is from 24 through 168.
   o output_file_name	Optional	If you do not specify a path, then the Endtxnutl utility creates the endtxnutl.out output file in the current folder.

   The following is an example of a typical command that runs the Endtxnutl utility:

   endtxnutl /u sadmin /p pwd /a siebsrvr17 /o d:\endtxnutl.out
   

   where:

   • Endtxnutl is the name of the utility.

   • sadmin is the user name.

   • pwd is the password.

   • siebsrvr17 is the name of the Siebel Server.

   • d:\endtxnutl.out is the name of the output file.