Hi all,
This is my first time of posting, I thought I would do so as I have had 3 cases for this same issue and it hasn't really got anywhere.
Before I go into the issue my CUCM version is 10.5.2.16901-1 (cant upgrade any higher right now due to hardware restrictions.
IM&P version: 10.5.2.24900-8.
So the issue:
RTMT is alerting me the follow every 30 minutes or so:
At Tue Oct 08 08:12:34 GMT+00:00 2019 on node <IM&P Primary IP Address>, the following SyslogSeverityMatchFound events generated:
SeverityMatch : Critical
MatchedEvent : Oct 8 08:12:17 <IM&P Primary Hostname> local7 2 Cisco: XCP Router: SDIDBConfigData::Read failed at step=SELECT Name from ProcessNode. ServiceID=121. odbc::SQLException=Failed to connect to datasource: [Informix][Informix ODBC Driver][Informix]Read error occurred during connection attempt.
AppID : Cisco Syslog Agent
ClusterID :
NodeID : <IM&P Primary Hostname>
TimeStamp : Tue Oct 08 08:12:17 GMT+00:00 2019
At Tue Oct 08 07:52:34 GMT+00:00 2019 on node <IM&P Primary IP Address>, the following SyslogSeverityMatchFound events generated:
SeverityMatch : Critical
MatchedEvent : Oct 8 07:51:48 <IM&P Primary Hostname> local7 2 Cisco: XCP Connection Manager: SDIDBConfigData::Read failed at step=SELECT Name from ProcessNode. ServiceID=124. odbc::SQLException=Failed to connect to datasource: [Informix][Informix ODBC Driver][Informix]Read error occurred during connection attempt.
AppID : Cisco Syslog Agent
ClusterID :
NodeID : <IM&P Primary Hostname>
TimeStamp : Tue Oct 08 07:51:48 GMT+00:00 2019
Cisco TAC originally thought it was to do with duplicate hostname entries in DNS, these were removed and it stopped after the services were restarted however I needed to restart the servers months later (CUCM & IM&P) and the alerts restarted.
I checked with the systems team and they confirmed that not duplicate entries existed.
At a loss to what to try next.
Thank you in advance for any assistance you can provide.
