06-30-2019 07:31 AM
Today when i entered utilis dbreplication runtimestate in imp subscriber i got the following output
DB Version: ccm12_0_1_10000_12
Repltimeout: Only available on the PUB
PROCESS option: Only available on the PUB
Cluster Detailed View from TFM-IMP-SUB (2 Servers):
PING DB/RPC/ REPL. Replication REPLICATION SETUP
SERVER-NAME IP ADDRESS (msec) DbMon? QUEUE Group ID (RTMT) & DB Status
----------- ---------- ------ ------- ----- ----------- ------------------
ABC-IMP-PUB 172.20.53.8 0.245 Y/Y/Y 18344 (g_4) (2) DB Active-Failed
ABC-IMP-SUB 172.20.53.9 0.013 Y/Y/Y 0 (g_6) (2) Setup Completed
Here DB status says DB Active-Failed what could be the reason? why its so? whats the next step i want to do to rectify it? reset or repair? there is no error or mismatch.. then what does it mean then
count number shows entirely different .
run sql SELECT count(*) from enduser
publisher it says 12 and subscriber it says 13..
07-01-2019 04:52 AM
07-01-2019 05:27 AM
I saw that link. but cannot see the same situation that im facing.
One more thing, HA is not enabled in the presence group yet.
07-01-2019 05:29 AM
I saw that link. but cannot see any thing in that same situation that im facing right now.
One more thing, HA is not enabled in the presence group yet.
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