05-22-2018 09:28 AM - edited 03-17-2019 12:51 PM
Hi All
I have the following problem:
In the cluster, a Subscriber have the dbreplication runtimestate in (4) Setup Failed.
Any ideas to recover the correct synchronization?
TIA
Cristian
05-22-2018 09:54 AM
Hi there
DB Replication status 4 is dropped. Have you gone thru the steps explained in this document.
Hope this helps!
Cheers
Rath!
***Please rate helpful posts***
05-22-2018 03:24 PM
Before you start the replication repair process, make sure that all nodes are NTP synced. If NTP is off, that may have caused the database replication problem in the first place.
05-23-2018 07:19 AM
Hi, the NTP is running.
NTP PUB
NTP Sub failed
TIA
Cristian
05-23-2018 07:38 AM - edited 05-23-2018 07:39 AM
Hi there
As Mahoney correctly pointed, your issue could be NTP related. NTP can mess up you DB replication.
Please check the diagnose commands
Also check with the network side if the ntp packets between Pub >>> Sub for any kind of blocking. Packet capture should be a good way.
I also suggest to open up a TAC, may be faulty subscriber ntp file should be manually corrected.
Hope this helps!
Cheers
Rath!
***Please rate helpful posts***
05-23-2018 07:11 AM
Hi
I see the following problem. The cluster have 4 servers, but the server node g_5_ccm11_5_1_10000_6 does not appear in this replication network.
Then, how to do for recover the replication in thos node?
TIA
Cristian
05-23-2018 07:22 AM
Hi there
Just wondering about the security password on that subscriber. Is that a new build?
Have you tried the db replication steps from this document. If not, please try that. Most of the DB replication issues should be resolved with this.
Also you could try the below
As a last resort you should plan rebuilding the Sub, opening a TAC/recovery
Hope this helps!
Cheers
Rath!
***Please rate helpful posts***
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide