Bookshelf Home | Contents | Index | Search | PDF

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

Run the following query on the Server database:

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

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.
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.

Bookshelf Home | Contents | Index | Search | PDF