Kbase P122728: Replication won't synchronize after stopping and restarting the source or target database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/4/2009 |
|
Status: Verified
SYMPTOM(s):
Replication won't synchronize after stopping and restarting the source or target database.
Database log file shows either the agent trying to connect to the replication server, or the server trying to connect to the agent (depending on whether the source or target database is being restarted).
FACT(s) (Environment):
The shutdown database has been restarted.
Proshut has been used to shutdown one of the databases.
OpenEdge Replication
Fathom Replication
All Supported Operating Systems
CAUSE:
The remote replication process was also automatically shutdown and needs to be restarted before replication can synchronize.
Issuing a normal database shutdown of either the source or target database will notify both the source and target replication processes to shutdown. i.e.
If you shutdown the source database it will obviously stop the replication server process but it will also notify the replication agent on the target side to shutdown.
Likewise, if you shutdown the target database it will shutdown both the replication agent and will notify the replication server process on the source side to shutdown.
In both cases, it will leave the remote database running but will just shutdown the replication processes.
FIX:
To restart the Replication Server on the source side, you can either:
a) Stop and restart the source database.
b) If the database is running you can use the dsrutil command to restart the replication server:
dsrutil <dbname> -C restart server
To restart the Replication Agent on the target side you will need to stop and restart the target database. There is currently no way to restart the agent while the target database is running.