Siebel Remote and Replication Manager Administration Guide > Troubleshooting Siebel Remote > Using Troubleshooting Utilities >

Using the Txnskip Utility to Examine Skipped Transactions

This topic describes how to identify skipped transactions and how to use the Txnskip utility to identify users who require reextraction. The Txnskip utility creates reports that identify users who are affected by any skipped transactions. An affected user is a user who receives a transaction if that transaction is not skipped. For data integrity, it might be necessary for you to reextract the local database for each affected user. You can run txnskip without shutting down the server components that Siebel Remote uses.

To use the Txnskip utility to examine skipped transactions

1. Log in to the Siebel Server with administrator privileges.

   For more information, see Logging In to the Siebel Server as an Administrator.

2. Navigate to the Administration - Siebel Remote screen, and then the Transaction Skipped view.
3. In the Transaction Processor list, choose a record according to the Transaction Processor Name and the Siebel Server name.
4. Examine the skipped transactions that display in the untitled list at the bottom of the screen.

   If you use Siebel Tools to view the untitled list, then this untitled list is named Skipped Transaction List Applet.

5. Make a note of the ID number of the first transaction and the ID number of the last transaction in a sequence of skipped transactions.

   In Step 7, you use the ID number of the first transaction for the first_transaction parameter. You use the ID number of the last transaction for the last_transaction parameter.

6. Configure parameters for the session.

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

7. To run the Txnskip utility, enter the following command in a single line:

   txnskip /u username /p password /o "output_file" /a Siebel_server_name /b first_transaction /e last_transaction

   Use parameters described in the following table.

   Parameter	Description
   u username	The login name for the administrator.
   p password	The password for the administrator.
   o "output_file"	The path and file name for the file that holds the report that the Txnskip utility creates.
   a Siebel_server_name	Required. The name of the Siebel Server where the user synchronizes.
   c ODBC_data_source	The ODBC Data Source. The default environment variable is SIEBEL_DATA_SOURCE.
   d Siebel_table_owner	The Siebel table owner. The default environment variable is SIEBEL_TABLE_OWNER.
   b first_transaction	The transaction ID for the first skipped transaction in the sequence.
   e last_transaction	The transaction ID for the last skipped transaction in the sequence.

8. Examine the output file.