IBM Support

IJ48576: DATA ITEMS WITH SQL FILTER (LIKE OPERATOR)

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When we are trying to search DataItem with Like operator and
    regular expression, he is getting "Unexpected end of JSON input"
    error
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Impact Users                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * View data items with SQL filter did not work when query was  *
    * run using 'LIKE' statements.                                 *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * NONE                                                         *
    ****************************************************************
    The SQL query did not sanitize the input string correctly,
    resulting in error when special characters, such as "%", was
    used in query.
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IJ48576

  • 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

    2023-09-14

  • Closed date

    2023-11-14

  • Last modified date

    2023-11-14

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSSHYH","label":"Tivoli Netcool\/Impact"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710","Line of Business":{"code":"LOB67","label":"IT Automation \u0026 App Modernization"}}]

Document Information

Modified date:
11 September 2024