IV67370: NCP_DISCO LOG/TRACE UNIQUE CONSTRAINT VIOLATION WARNING ON INSERTING TABLE NETWORKPIPE

4.1.1-TIV-ITNMIP-Linux-FP0002
4.1.1_README_NLS_FP0002
4.1.1_README_FP0002
IBM Tivoli Network Manager IP Edition 4.1.1 Fix Pack 2, 4.1.1-TIV-ITNMIP-FP0002

APAR status

• Closed as program error.

Error description

• 2014-11-06T07:22:16: Warning: W-RIV-002-206: [150678384t]
  CDiscoStitcherRuleDncimInsert.cc(438) A database 'execute'
  operation has failed : CNcpSolidODBCSth.cc line 210 : SOLID
  Database Error 10033: Primary key (NETWORKPIPE_PK) unique
  constraint violation.( statement: 'INSERT INTO networkPipe (
  entityId, connectionId, aggregationType ) values ( ?, ?, ? )'
  varbinds: [360612,148477,2] )
  2014-11-06T07:22:16: Warning: W-RIV-002-139: [150678384t]
  CRivStitcherRuleIf.cc(212) The following stitcher rule failed
  to complete correctly. Error in stitcher  whilst evaluating
  rule within if clause
  2014-11-06T07:22:16: Warning: W-RIV-002-139: [150678384t]
  CRivStitcherRuleIf.cc(212) The following stitcher rule failed
  to complete correctly. Error in stitcher  whilst evaluating
  rule within if clause
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * User with MPLS devices                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * nco_disco trace shows warning about unique constraint        *
  * violation for networkPipe table insert:                      *
  * 2014-11-06T07:22:16: Warning: W-RIV-002-206: [150678384t]    *
  * CDiscoStitcherRuleDncimInsert.cc(438) A database 'execute'   *
  * operation has failed : CNcpSolidODBCSth.cc line 210 : SOLID  *
  * Database Error 10033: Primary key (NETWORKPIPE_PK) unique    *
  * constraint violation.( statement: 'INSERT INTO networkPipe ( *
  * entityId, connectionId, aggregationType ) values ( ?, ?, ?   *
  * )' varbinds: [360612,148477,2] )                             *
  * 2014-11-06T07:22:16: Warning: W-RIV-002-139: [150678384t]    *
  * CRivStitcherRuleIf.cc(212) The following stitcher rule       *
  * failed to complete correctly. Error in stitcher  whilst      *
  * evaluating rule within if clause                             *
  * 2014-11-06T07:22:16: Warning: W-RIV-002-139: [150678384t]    *
  * CRivStitcherRuleIf.cc(212) The following stitcher rule       *
  * failed to complete correctly. Error in stitcher  whilst      *
  * evaluating rule within if clause                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * The following fixpacks will contain the fix:                 *
  * | fix pack | 4.1.0-ITNMIP-FP0001                             *
  * | fix pack | 4.1.1-ITNMIP-FP0002                             *
  ****************************************************************
  

Problem conclusion

• The issue is that selectConnection call at line 528 in
  PopulateDNCIM_MPLSTEPipeHop.stch does a query of connectionId
  JOINED with the topology type. i.e. there may already be a
  connection there but just in a different topology. This is fine
  as the connectionId isn't dependent on a topology. However that
  causes a problem in that the query returns null even when there
  may already be a connection and maybe even a network pipe using
  that connection, just in a different topology.
  The PopulateDNCIM_Connection.stch already checks if a connection
  already exists for a link before creating so the
  selectConnection call is redundant and it should just be a call
  to check if the networkPipe already exists.
  

Temporary fix

Comments

APAR Information

• 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

  TIV NETWK MGR I

• Fixed component ID

  5724S4500

Applicable component levels

• R410 PSN

     UP

• R410 PSY

     UP

• R411 PSN

     UP

• R411 PSY

     UP