IV68467: ITNM MONITORING POLICY SUMMARY REPORT PRODUCES ERRORS

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
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

• ENV: ITNM 3.9
  TCR 3.1
  TDW
  Attempting to run the Monitoring Policy Summary report provides
  data for each query, but does produce an error in HTML format:
  
  ReportDesign (id = 1):
  + Cannot execute the statement.
  SQL statement does not return a ResultSet object.
  SQL error #1: DB2 SQL Error: SQLCODE=-802, SQLSTATE=22003,
  SQLERRMC=null, DRIVER=3.63.75
  

Local fix

• Modify the rptdesign file
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Client attempting to run ITNM Monitoring Policy Summary      *
  * report and getting an error message in the HTML output.      *
  *                                                              *
  * ReportDesign (id = 1):                                       *
  * + Cannot execute the statement.                              *
  * SQL statement does not return a ResultSet object.            *
  * SQL error #1: DB2 SQL Error: SQLCODE=-802, SQLSTATE=22003,   *
  * SQLERRMC=null, DRIVER=3.63.75                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * The following fixpacks will contain the fix:                 *
  * | fix pack | 3.9.0-ITNMIP-FP0005                             *
  * | fix pack | 4.1.0-ITNMIP-FP0001                             *
  * | fix pack | 4.1.1-ITNMIP-FP0002                             *
  ****************************************************************
  

Problem conclusion

• The failure was in  the DevicesBeingMonitored dataset query.
  Modify the query to add join of poll table and replace the
  fields of POLLINTERVAL and storeData to retrieve from that
  table.
  

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

• R410 PSN

     UP

• R410 PSY

     UP

• R411 PSN

     UP

• R411 PSY

     UP