02-26-2016 02:29 AM - edited 03-17-2019 06:02 AM
Hello,
I just noticed at the system reports it says "the sqlhosts file on x.x.x.x does not match the publisher"
Same page, rhosts files are ok and utils dbreplication runtimestate command output has no error.
What is the cause this error ? How can I clear this ?
admin:utils dbreplication runtimestate
Server Time: Fri Feb 26 09:21:39 EET 2016
Cluster Replication State: Replication status command started at: 2016-02-26-09-11
Replication status command COMPLETED 302 tables checked out of 305
Last Completed Table: batfileinfojobmap
No Errors or Mismatches found.
Use 'file view activelog cm/trace/dbl/sdi/ReplicationStatus.2016_02_26_09_11_39.out' to see the details
DB Version: ccm10_5_2_22900_2
Repltimeout set to: 300s
PROCESS option set to: 1
Cluster Detailed View from IPTPRLXR01 (6 Servers):
PING DB/RPC/ REPL. Replication REPLICATION SETUP
SERVER-NAME IP ADDRESS (msec) DbMon? QUEUE Group ID (RTMT) & Details
----------- ---------- ------ ------- ----- ----------- ------------------
IPTPRLXR01 10.113.154.45 0.016 Y/Y/Y 0 (g_19) (2) Setup Completed
IPTPRLXR02 10.30.154.45 9.288 Y/Y/Y 0 (g_20) (2) Setup Completed
IPTPRLXR03 10.113.154.46 0.410 Y/Y/Y 252 (g_25) (2) Setup Completed
iptprlxr06 10.30.154.46 9.546 Y/Y/Y 252 (g_37) (2) Setup Completed
IPTPRLXR05 10.30.154.48 9.811 Y/Y/Y 252 (g_23) (2) Setup Completed
iptprlxr04 10.113.154.48 0.084 Y/Y/Y 0 (g_36) (2) Setup Completed
Regards,
Baris.
Solved! Go to Solution.
02-26-2016 04:48 AM
Hi Baris,
Try restarting the A Cisco DB service on all the nodes in the IM&P cluster ( cisco Unified IM and Presence Serviceability page ) and see if that helps, do give it a few minutes before you run the report again.
Manish
02-26-2016 04:48 AM
Hi Baris,
Try restarting the A Cisco DB service on all the nodes in the IM&P cluster ( cisco Unified IM and Presence Serviceability page ) and see if that helps, do give it a few minutes before you run the report again.
Manish
02-26-2016 06:29 AM
Thank you Manish,
I just restarted A Cisco DB service "utils service restart A Cisco DB" on only those servers which I got error.
Then I run report again and I see all errors are cleared.
Regards,
Baris.
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