IV26842: WRONG FORMAT OF TIME IN EXCEL REPORT.

ITNMIP_Patch_V3.8.0.89_AIXPPC32
3.8.0-TIV-ITNMIP-Linux-REF-FP0007
3.8.0-TIV-ITNMIP-Solaris-REF-FP0007
ITNMIP_Patch_V3.8.0.89_Win32
IBM Tivoli Network Manager IP 3.9.0 Fix Pack 3, 3.9.0-TIV-ITNMIP-FP0003
IBM Tivoli Network Manager IP 3.9.0 Fix Pack 4, 3.9.0-TIV-ITNMIP-FP0004
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

• When a report is exported as Excel file, then format of date in
  the exported file is "yyyy-m-d hh:ss:mm", though it should be
  "yyyy-m-d hh:mm:ss".  *ss* and *mm* should be reversed.
  

Local fix

• Using BIRT designer to modify the data typy "date-type" to
  "string".
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * The users that convert ITNM reports to excel format. The     *
  * reports like the performance reports that shows fields with  *
  * date and time can show a wrong time.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Some of the ITNM reports that have dates like the            *
  * performance reports can have a wrong formatted time when     *
  * report is converted to Excel                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update the report package with fixed version.                *
  * fix pack | 3.9.0-ITNMIP-FP0003                               *
  * fix pack | 3.8.0-ITNMIP-FP0007                               *
  ****************************************************************
  

Problem conclusion

• The data field where the time was shown incorrectly was fixed
  and now it shows the right time when a report is converted to
  excel format
  

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