IBM Support

IV07908: MPLS VPN DETAILS REPORT FAILS TO LOAD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Environment:
    
    ITNM 3.8 FP5, RHEL5.5, Oracle 10.2.0.1.0
    
    
    Problem:
    
    The MPLS VPN Details Report (itnm_mpls_vpn_details.rptdesign)
    fails to generate with the browser status shows as loading. The
    NCIM temporary table space's datafile in Oracle was highly
    increased from 100 MB to 33 GB while running the report.  The
    SQL query needs some improvement in order to display the report
    correctly.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The MPLS VPN Details Report                                  *
    * (itnm_mpls_vpn_details.rptdesign)                            *
    * fails to generate with the browser status shows as loading.  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * None                                                         *
    * | fix pack | 3.8.0-ITNMIP-FP0007                             *
    * | fix pack | 3.9.0-ITNMIP-FP0002                             *
    ****************************************************************
    

Problem conclusion

  • One of the dataset queries in the report contains complex tables
    join statements.
    The large size of the tables has impacted the performance of the
    data query.
    Re-wrote the PEPSummary dataset query to improve the
    performance.
    
    The following fixpacks will contain the fix:
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV07908

  • Reported component name

    TIV NETWK MGR I

  • Reported component ID

    5724S4500

  • Reported release

    380

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-19

  • Closed date

    2011-10-21

  • Last modified date

    2012-05-30

  • 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

  • R380 PSY

       UP

  • R390 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"380","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
30 May 2012