JR44626: IN REPORT VIEWER WIDGET, DRILLDOWN FAILS FOR A STRING BASED DIMENSION WITH ORACLE DATABASE IF A VALUE IS TOO LONG

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • With Oracle as the database, in the (Cognos-based) Report Viewer
    widget, if a dimension is based on a metric of type String, and
    at least one instance of the monitoring context has a value that
    is sufficiently long (i. e. a dimension value is sufficiently
    long), drilldown on that dimension will fail, with an Oracle
    error being reported.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  Users of IBM Business Monitor Version       *
    *                  7.5.1.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: With Oracle as the database, in the     *
    *                      (Cognos-based) Report Viewer widget,    *
    *                      if a dimension is based on a metric     *
    *                      of type String, and at least one        *
    *                      instance of the monitoring context      *
    *                      has a value that is sufficiently long   *
    *                      (i. e. a dimension value is             *
    *                      sufficiently long), drilldown on that   *
    *                      dimension will fail, with an Oracle     *
    *                      error being reported.                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A Cognos query (in IBM Business Monitor) used to extract values
    for a String metric on drilldown was assuming a maximum string
    length of 32 characters.
    

Problem conclusion

  • The Cognos query was modified to assume a maximum string
    length of 1024 characters.
    
    An interim fix for IBM Business Monitor Version 7.5.1.1 is
    available on Fix Central.  Please refer to the separate
    file that is automatically downloaded with the interim fix
    for prerequisite information and installation/uninstallation
    instructions.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR44626

  • Reported component name

    WEB BUS MONITOR

  • Reported component ID

    5724M2400

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-02

  • Closed date

    2013-01-15

  • Last modified date

    2013-01-15

  • 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

    WEB BUS MONITOR

  • Fixed component ID

    5724M2400

Applicable component levels

  • R750 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Business Monitor

Software version:

750

Reference #:

JR44626

Modified date:

2013-01-15

Translate my page

Machine Translation

Content navigation