Siebel Remote and Replication Manager Administration Guide > Troubleshooting Remote and Replication Manager > Replication Agent >

Replication Agent Failure Due to Special Characters During an Update

You may encounter situations where special characters cause Replication Agent to fail during an update. Use the following procedure to find the transaction IDs involved with this failure.

To find the transaction (TXN_ID) causing this problem

  1. Run the following query on the Server database:

    SELECT MIN(TXN_ID), MAX(TXN_ID) FROM S_DOCK_TXN_LOG

  2. From the Siebel Server machine, go to a DOS prompt and type the following:

    cd server_root_dir\bin

    siebenv

    txnutl /u SADMIN /p SADMIN /s MIN(TXN_ID) /e MAX(TXN_ID) /d dbo /c <SiebelServerDataSource> /w dx-file > output_file

    where:

    • /u is the user name of the Admin account
    • /p is the password of the Admin account
    • /s is the output of MIN(TXN_ID) of the previous query
    • /e is the output of MAX(TXN_ID) of the previous query
    • /w is dx-file name the transactions of S_DOCK_TXN_LOG are written to in the format of a dx-file
    • /d is the schema owner (dbo)
    • /c is the Siebel Server ODBC Data Source used to connect to the database
    • dx-file is the file you have to check to find the transaction that caused the problem.
  3. Open the output file with any editor and go to the end of the file. You will see something like the following:

    Txn Type: S

    Txn Id: 49051

    Src Node: 16

    Created By: 1-2G-162

    DLog Row Id: 16-RHP

    The TXN_ID in this case is 49051.


 Siebel Remote and Replication Manager Administration Guide 
 Published: 19 November 2003