Fixes are available
APAR status
Closed as program error.
Error description
Product: Tivoli Network Manager Version: 3.9 Component: ModelNcim.cfg Symptoms: During Topology updates the following errors are observed in the ncp_model.<domain>.log Warning: W-RIV-002-206: [4117887888t] CMdlDbEntityMgr.cc(540) A database 'execute' operation has failed : SQLRETURN = -1 CNcpODBCSth.cc line 233 : [Informix][Informix ODBC Driver][Informix]Unique constraint (ncim.entitydata_pk) violated.(statement: 'INSERT INTO entityData (entityId,entityName,mainNodeEntityId,entityType,createTime,chan geTime,displayLabel,description,cdmAdminState,manual) VALUES (?,?,?,?,?,?,?,?,?,?)' Warning: W-RIV-002-206: [4117887888t] CMdlDbEntityMgr.cc(540) A database 'execute' operation has failed : SQLRETURN = -1 CNcpODBCSth.cc line 233 : [Informix][Informix ODBC Driver][Informix]Unique constraint (ncim.ipendpoint_pk) violated.(statement: 'INSERT INTO ipEndPoint (entityId,address,ipNumber,netNumber,protocol) VALUES (?,?,?,?,?)' Warning: W-RIV-002-128: [4117887888t] CMdlCore.cc(1587) CMdlDbInterface::RecordToExternalDb: Failed to update Cause: The default dbModel.entityMap.EntityFilter values in ModelNcimDb.cfg file allow for duplicate matching. Filters in this file should not match more than one record.
Local fix
IBM Support carry a copy of ModelNcimDb.cfg that has altered EntityFilters in it. If the Fix Pack containing the fix to this APAR has not been release yet, raise a Service Request with IBM Support and send a copy of NCHOME/var/precision/Store.Cache.kernel.activeModel.DOMAIN (where DOMAIN is your ITNM Discovery Domain name).
Problem summary
**************************************************************** * USERS AFFECTED: * * All ITNN 3.9 users * **************************************************************** * PROBLEM DESCRIPTION: * * ENTITYFILTER IN MODELNCIMDB.CFG ALLOW FOR DUPLICATE MATCHES. * **************************************************************** * RECOMMENDATION: * * Upgrade to ITNM-IP | fix pack | 3.9.0-ITNMIP-FP0004 * ****************************************************************
Problem conclusion
The default dbModel.entityMap.EntityFilter values in ModelNcimDb.cfg file allow for duplicate matching. Filters in this file should not match more than one record. Fix will be available in FP0004
Temporary fix
Comments
APAR Information
APAR number
IV51240
Reported component name
NC/PREC DISCOVY
Reported component ID
5724O52DS
Reported release
390
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-10-24
Closed date
2013-12-09
Last modified date
2013-12-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
NC/PREC DISCOVY
Fixed component ID
5724O52DS
Applicable component levels
R390 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.9","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
09 December 2013