Modifying the S_DOCK_TXN_LOG Table

The Transaction Processor and the Transaction Router server components run on the Siebel Server and route transactions from the master transaction log to the outbox folder on the remote client. The Transaction Processor removes rows from the log after Siebel Remote writes transactions from the S_DOCK_TXN_LOG table to DX files in the docking\txnproc folder.

Caution: You must not directly modify the contents or structure of the master transaction log under any circumstances.

In a Microsoft SQL Server or DB2 environment, truncation of the S_DOCK_TXN_LOG table in a server database causes Siebel Remote to reset the txn_id values that it assigns to new transactions. Siebel Remote does not reset the corresponding txn_id values in the S_DOCK_STATUS table. In this situation, new transactions that Siebel Remote inserts in the S_DOCK_TXN_LOG table contain a txn_id mismatch when compared to the values that the S_DOCK_STATUS table contain. The Transaction Processor does not process these transactions. It removes them from the S_DOCK_TXN_LOG table.

If Siebel Remote truncates the S_DOCK_TXN_LOG table, then you must reextract all remote clients and delete all existing transactions and local databases before you reinitialize these clients. The reextract process resets the txn_id values in the S_DOCK_STATUS table so that the values correspond with the txn_id values that exist in the S_DOCK_TXN_LOG table. Deleting transactions and local databases is necessary to prevent mismatch errors between new S_DOC_STATUS txn_id values and older txn_id values that exist in the local databases.