Kbase P30486: 10356 error attempting to connect to the source database after replication server has terminated.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/3/2011 |
|
Status: Verified
SYMPTOM(s):
Target database has been shut down
Error connecting to source database
Access to database <dbname> 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)
Existing users connected to source database continue to work
FACT(s) (Environment):
Fathom High Availability Replication 1.0A
All Supported Operating Systems
CAUSE:
Bug# 20030709-050
CAUSE:
Once the replication target database is no longer available, the source database and the replication agent attempt to reconnect to the target. After the timeout threshold has been reached, the replication server agent shuts down. Once this happens, no further connections to the source database are allowed.
FIX:
Assuming that the target database is not coming back on line any time soon, the source can be made to accept connections without shutting down the source database server. Use the following DSRUTIL commands to acheive this:
To release any pending waits run:
DSRUTIL sourcedb -C RELWAITS
To disable Fathom Replication run:
DSRUTIL sourcedb -C disablesitereplication source.
Once this is done, replication must be started over.
Fixed in 9.1D07 and higher.