Kbase P115192: How to change the behavior of the replication agent when the source database is shut down
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/05/2010 |
|
Status: Verified
GOAL:
How to change the behavior of the replication agent when the source database is shut down
GOAL:
How to allow connections to the target database when the replication server terminates
GOAL:
Why do users connecting to target database receive error (10356) Access to database target not allowed. The database is enabled for site replication but either replication is not running, or this process is not authorized to open a replication enabled database.
GOAL:
What is the agent-shutdown-action parameter used for?
FACT(s) (Environment):
OpenEdge Replication 10.1x
OpenEdge Replication 10.2x
All Supported Operating Systems
FIX:
A new parameter (agent-shutdown-action ) has been added to OpenEdge Replication 10.1A, under the [server] Properties, which configures the action of the replication agent (RPLA) when the source database is shut down or the replication server (RPLS) ends.
agent-shutdown-action takes two values which specifies the action that the replication agent (RPLA) will take when it looses connection to the replication server (RPLS). They are:
1. recovery: The agent will remain active but in a PRE-TRANSITION state waiting for the replication server to reconnect. Provided that a Replication PLUS license is in use, new client connections to the target database will still be allowed. The agent will stay in pre-transition forever unless auto transition is configured. Connect timeout does not take effect when in pre-transition. Since the replication process is stopped, the accuracy of 'timed' reports needs to be taken into account until such time as replication is re-established.
The following message will be recorded in the target database lg file:
The Replication Server has been terminated or the Source database has been shutdown. The Agents will enter PRE-TRANSITION, waiting for re-connection from the Replication Server. (12688)
2. normal : The agent will terminate; the target database will stay up. Existing client connections will be able to continue their reporting queries. New client connections will be disallowed until such time as replication has been re-established ie: the Replication Server and Replication Agent have synchronized and resumed communications.
The following message will be recorded in the target database lg file:
The Fathom Replication Agent agent1 is ending. (10506)
Access to database target not allowed. The database is enabled for site replication but either replication is not running, or this process is not authorized to open a replication enabled database. (10356)
"Normal" was the expected behavior in previous versions and is the default behavior. Setting the agent-shutdown-action parameter to recovery will enable the new behavior.