cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2345
Views
10
Helpful
2
Replies

CUP: the sqlhosts file does not match the publisher node

Bar1s
Level 1
Level 1

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. 

1 Accepted Solution

Accepted Solutions

Manish Gogna
Cisco Employee
Cisco Employee

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

View solution in original post

2 Replies 2

Manish Gogna
Cisco Employee
Cisco Employee

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

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.