Direct links to fixes
3.9.0-TIV-ITNMIP-Solaris-FP0005
3.9.0_INSTALL_NLS_FP0005
3.9.0_INSTALL_FP0005
3.9.0-TIV-ITNMIP-Windows-FP0005
3.9.0-TIV-ITNMIP-zLinux-FP0005
3.9.0-TIV-ITNMIP-Linux-FP0005
3.9.0-TIV-ITNMIP-AIX-FP0005
3.9.0.4-TIV-ITNMIP-CORE-OpenSSL-Windows-IF0001
3.9.0.4-TIV-ITNMIP-GUI-Windows-IF0001
3.9.0.4-TIV-ITNMIP-GUI-Window-IF0001
3.9.0.4-TIV-ITNMIP-GUI-Unix-IF0001
3.9.0.4-TIV-ITNMIP-CORE-OpenSSL-zLinux-IF0001
3.9.0.4-TIV-ITNMIP-CORE-OpenSSL-Solaris-IF0001
3.9.0.4-TIV-ITNMIP-CORE-OpenSSL-Linux-IF0001
3.9.0.4-TIV-ITNMIP-CORE-OpenSSL-AIX-IF0001
3.9.0.4-TIV-ITNMIP-zLinux-CORE-IF0001
3.9.0.4-TIV-ITNMIP-Windows-CORE-IF0001
3.9.0.4-TIV-ITNMIP-Solaris-CORE-IF0001
3.9.0.4-TIV-ITNMIP-Linux-CORE-IF0001
3.9.0.4-TIV-ITNMIP-AIX-CORE-IF0001
3.9.0.4_README_NLS_IF0001
3.9.0.4_README_GUI_IF0001
3.9.0.4_README_CORE_OpenSSL_IF0001
3.9.0.4_README_CORE_IF0001
IBM Tivoli Network Manager IP 3.9.0.4 Interim Fix 1, 3.9.0.4-TIV-ITNMIP-IF0001
IBM Tivoli Network Manager IP Edition 3.9.0 Fix Pack 5, 3.9.0-TIV-ITNMIP-FP0005
APAR status
Closed as program error.
Error description
Error in ncp_model.trace ue Nov 18 01:05:18 2014 Warning: A database 'execute' operation has failed found in file CMdlDbPollData.cc at line 805 - : SQLRETURN = -1 CNcpODBCSth.cc line 233 : [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=3, TABLEID=175, COLNO=1" is not allowed. SQLSTATE=23502 ( statement: ' INSERT INTO monitoredChassis ( ENTITYID,ACCESSIPADDRESS ) VALUES (?, ?)' varbinds: [351459,''] )
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * SQL errors in ncp_model.trace for the table insert to * * monitoredChassis with NULL IP: * * Tue Nov 18 01:05:18 2014 Warning: A database 'execute' * * operation has failed found in file CMdlDbPollData.cc at line * * 805 - : SQLRETURN = -1 CNcpODBCSth.cc line 233 : [IBM][CLI * * Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a * * NOT NULL column "TBSPACEID=3, TABLEID=175, COLNO=1" is not * * allowed. SQLSTATE=23502 ( statement: ' INSERT INTO * * monitoredChassis ( * * ENTITYID,ACCESSIPADDRESS ) VALUES (?, ?)' varbinds: * * [351459,''] * * ) * **************************************************************** * RECOMMENDATION: * * The following fixpacks will contain the fix: * * | fix pack | 3.9.0-ITNMIP-FP0005 * * | fix pack | 3.9.4-ITNMIP-IF0001 * ****************************************************************
Problem conclusion
This error was due to the NULL AccessIP insert. A bug existed where devices were copied to ncpolldata even if they did not have an IP address. The fact that manual topology devices can be created without IP addresses. To resolve the issue, we should check to prevent a device being added to the ncpolldata DB if it has no access IP.
Temporary fix
Comments
APAR Information
APAR number
IV67099
Reported component name
TIV NETWK MGR I
Reported component ID
5724S4500
Reported release
390
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-11-19
Closed date
2014-12-10
Last modified date
2015-04-13
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
R390 PSN
UP
R390 PSY
UP
Document Information
Modified date:
13 April 2015