IV60125: NCP_VALIDATE_NCIM_TABLES.PL NEWLY INTRODUCED IN FP4 FAILS RUNNING AGAINST MYSQL DB.

4.1.1-TIV-ITNMIP-Linux-FP0002
4.1.1_README_NLS_FP0002
4.1.1_README_FP0002
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
4.1.1_README_NLS_FP0001
4.1.1_README_FP0001
4.1.1-TIV-ITNMIP-Linux-FP0001
IBM Tivoli Network Manager IP Edition 3.9.0 Fix Pack 5, 3.9.0-TIV-ITNMIP-FP0005
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

• When running the script against mysql db the following errors
  are listed:
  
  > ncp_perl ncp_validate_ncim_tables.pl -domain <domain>
  
  Error: Table POLLER not found in NCMONITOR schema
  Error: Table SCOPE not found in NCMONITOR schema
  Error: Table SCOPEFILTER not found in NCMONITOR schema
  ...
  ...
  ...
  (209 tables total)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Those using the install (ncim) validation script             *
  * ncp_validate_ncim_tables.pl during 3.9 FP3+ upgrades against *
  * a mySQL or Informix database.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The script returns failure indicating that none of the       *
  * tables are found.                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Use the updated script with next FP delivery or manually     *
  * patch script at upgrade point.                               *
  * Official fix will be delivered with                          *
  * 3.9.0-ITNMIP-FP0005                                          *
  * 4.1.0-ITNMIP-FP0001                                          *
  * 4.1.1-ITNMIP-FP0001                                          *
  ****************************************************************
  

Problem conclusion

• The ncp_validate_ncim_tables.pl script as part of the FP
  installation has been updated to work correctly against mySQL
  and Infomix databases.
  

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

• R390 PSN

     UP

• R390 PSY

     UP

• R401 PSN

     UP

• R401 PSY

     UP

• R410 PSN

     UP

• R410 PSY

     UP

• R411 PSN

     UP

• R411 PSY

     UP