Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

The user cannot restart replication in TimesTen (TT) in Service Agent (SA) 2.0

Core Issue

Replication between the two TimesTen Data Authority Servers (TTDAS) instances within one site is down for a long period of time. As a result, this error is generated when replication is re-started:

sip@POP # cd /opt/TimesTen/5_0_30/bin
sip@POP # ./ttAdmin -repPolicy manual POP_0
*** [TimesTen][TimesTen 5.0.30 ODBC Driver][TimesTen]TT8025: Replication Log Threshold limit reached at
master. Replication state for this data store is changed to FAILED state. -- file "db.c", lineno 8567,
 
procedure "sbDbConnect()"
*** ODBC Warning = S1000, TimesTen Warning = 8025

*** [TimesTen][TimesTen 5.0.30 ODBC Driver][TimesTen]TT8025: Replication Log Threshold limit reached at
master. Replication state for this data store is changed to FAILED state. -- file "db.c", lineno 8567,
procedure "sbDbConnect()"
*** ODBC Warning = S1000, TimesTen Warning = 8025

RAM Residence Policy            : inUse
Replication Agent Policy        : manual
Replication Manually Started    : False

Resolution

To copy over the TTDAS instance within the same site to ensure that there are no discrepancies, navigate as sip user to the directory where TTDAS is installed and execute the ./duplicatepeer.bsh script, as shown in this example:

$ cd /opt/dynamicsoft/dsProducts/TTDAS/1.0.1.1/sql
$./duplicatepeer.bsh
Duplicating Schema/Data from peer node
Preparing to:
  -- stop replication to/from the peer node ,
  -- destroy the local database ,
  -- and duplicate the schema/data in the peer node:
       -- from DSN
       -- on HOST
       -- to local DSN
       -- on HOST
       -- of the local DB
ARE YOU SURE YOU WANT TO PROCEED (Y/N)? [N]  hit Y ("Y" must be capitalized)
     RAM Residence Policy            : inUse
     Replication Agent Policy        : manual
     Replication Manually Started    : False
     Oracle Agent Policy             : manual
     Oracle Agent Manually Started   : False
(If it complains about not being able to stop replication, that is fine, hit Y to continue)
(Some time will pass while it copies over the database)
When it asks to start replication daemon, enter Y
Now Replication is done (it might display the Replication Status here)
RAM Residence Policy            : inUse
Replication Agent Policy        : manual
Replication Manually Started    : True
Oracle Agent Policy             : manual
Oracle Agent Manually Started   : False
Processing completed.
Version history
Revision #:
1 of 1
Last update:
‎06-22-2009 03:37 PM
Updated by: