IBM Support

Ncpolldata insert or update failing on foreign key

Troubleshooting


Problem

 Ncpolldata inserts and updates are failing because the value for ENTITYID (the MONINST_CHASSIS_FK) does not match MAINNODEENTITYID (parent key) in any rows in monitoredInstance. This is causing warnings like the one below to fill up the poller_default logs and traces:
2022-10-28T14:45:29: Warning: W-RIV-002-206: [904066816t] CPollDataMgr.cc(595) A database 'execute' operation has failed : SQLRETURN = -1 CNcpODBCSth.cc line 239 : [IBM][CLI Driver][DB2/LINUXX8664] SQL0530N  The insert or update value of the FOREIGN KEY "NCPOLLDATA.MONITOREDINSTANCE.MONINST_CHASSIS_FK" is not equal to any value of the parent key of the parent table.  SQLSTATE=23503
( statement: 'SELECT MONITOREDINSTID FROM FINAL TABLE ( INSERT INTO monitoredInstance (MAINNODEENTITYID, ENTITYID, INSTANCETYPE, INSTANCESTR) VALUES ( ?, ?, ?, ? ) ) ORDER BY INPUT SEQUENCE' varbinds: [163175,169485,'ifIndex','565'] )
--------------------------------------------------------------------------------------------------

I removed the device using removenode.pl and waited for disco to rediscover it at the next disco cycle .
I checked the poller_default log the next morning after disco ran and the insert for the entityID is still failing.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"ARM Category":[{"code":"a8m500000008bHwAAI","label":"ITNM-\u003EGUI-\u003ENetwork Polling"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"4.2.0"}]

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:
23 June 2026

UID

ibm17029675