IBM Support

Polling not working

Troubleshooting


Problem

Poll policies take a long time to update in GUI when enabling them and sometimes they don't become enabled. Other times they become enabled after some time but then there is no polling of discovered devices.

Symptom

The following errors can be seen in the ncp_model.log with debug 4 enabled:
2011-11-01T17:38:56: Warning: W-RIV-002-206: [3954944912t] CPollDataPruner.cc(444) A database 'execute' operation has failed : CNcpOracleSth.cc line 381: (Error 3135) ORA-03135: connection lost contact
Process ID: 18463
Session ID: 139 Serial number: 43722
( statement: ' SELECT COUNT(POLLTIME) AS ROW_COUNT FROM pollData' )
2011-11-01T18:38:56: Warning: W-DB-001-014: [3954944912t] Disconnection state '3114' detected
2011-11-01T18:38:56: Warning: W-DB-001-002: [3954944912t] DB connection to 'ncpolldata' lost
2011-11-01T18:38:56: Information: I-DB-001-003: [3954944912t] Successfully reconnected to DB 'ncpolldata'
2011-11-01T19:54:22: Warning: W-RIV-002-206: [3954944912t] CPollDataPruner.cc(444) A database 'execute' operation has failed : CNcpOracleSth.cc line 381: (Error 3135) ORA-03135: connection lost contact

&

2011-11-15T20:14:44: Information: I-DB-001-003: [3952151440t]
Successfully reconnected to DB 'ncim'
2011-11-15T20:14:44: Warning: W-RIV-002-128: [3952151440t]
CSqlTableCopier.cc(104) Cannot synchronise record - insert failed.
Record is {
ENTITYID=32753,
ACCESSIPADDRESS='10.111.128.35'
}
2011-11-15T20:14:44: Warning: W-RIV-002-206: [3952151440t]
CPollDataMgr.cc(787) A database 'execute' operation has failed :
CNcpOracleSth.cc line 381: (Error 2291) ORA-02291: integrity constraint

[{"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"3.9","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 June 2018

UID

swg21573002

Page Feedback