IBM Support

IJ04149: RE-RUNNING SE CONFIGURATIONS MAKES SE RULES NOT VISIBLE IF DOUBLE QUOTES EXISTS IN IDVALUE FIELD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When re-running a SE configuration which events contain double
    quotes, the SE rule are not visible anymore
     Rule is still there but, not mapped in the
    SEASONALITY_RESULT_DATA table.
    

Local fix

  • change the bellow line in seasonalityProcess from
    
    IDVALUE_STR = "IDVALUE = '" + IDVALUE + "'";
    
    to
    
    IDVALUE_STR = "IDVALUE = '" +
    unEscapeSpecialSQLCharacters(IDVALUE) + "'";
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Netcool Operation Insights users                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * On re-running a Seasonality report, previously assigned      *
    * Seasonality rules disappear from the Seasonal Events view.   *
    * This happens if the identity field for the report has a "    *
    * character in it (or any escaped SQL character).              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is contained in the following
    maintenance packages:
    | Fix Pack | 7.1.0-TIV-NCI-FP0013
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ04149

  • Reported component name

    NETCOOL/IMPACT

  • Reported component ID

    5724O59IS

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-02-15

  • Closed date

    2018-02-20

  • Last modified date

    2018-02-20

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • UNKNOWN
    

Fix information

  • Fixed component name

    NETCOOL/IMPACT

  • Fixed component ID

    5724O59IS

Applicable component levels

  • R710 PSY

       UP

[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHYH","label":"Tivoli Netcool\/Impact"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710"}]

Document Information

Modified date:
22 August 2021