IBM Support

PH22830: SERVER CAN CRASH IF USER REPEATEDLY SWITCHES BETWEEN FLV AND OBJECT VIEW USING BREADCRUMBS

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

  • If a user opens a Filtered List View and uses a filter that
    contains a condition to check for a user in a multi-user field,
    and then repeatedly opens an object from the list, then returns
    to the FLV using the breadcrumb trail, this can generate a query
    too long for the database to handle, and make the server stop
    responding.
    
    Restarting the server is necessary to resolve the error if it
    occurs.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SERVER CAN CRASH IF USER REPEATEDLY SWITCHES BETWEEN FLV AND *
    * OBJECT VIEW USING BREADCRUMBS                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages 8.1.0.1 Interim Fix 3    *
    * from Passport Advantage. See the following document for      *
    * details on obtaining OpenPages 8.1.0.1 Interim Fix 3:        *
    * https://www.ibm.com/support/pages/openpages-watson-8101-inte *
    * rim-fix-3                                                    *
    ****************************************************************
    

Problem conclusion

  • We had a function that was written that took a single
    SimpleCondition of the form 'alaudit' and added an additional
    SimpleCondition like "%$;alaudit$;%. The problem is that this
    code was being run on cached queries where the logic had already
    been executed. Every time the query was retrieved from the cache
    and executed, the number of SimpleConditions doubled.  We have
    now corrected this from happening.
    
    Customers should download OpenPages 8.1.0.1 Interim Fix 3 from
    Passport Advantage. See the following document for details on
    obtaining OpenPages 8.1.0.1 Interim Fix 3:
    https://www.ibm.com/support/pages/openpages-watson-8101-interim-
    fix-3
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH22830

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-03-02

  • Closed date

    2020-04-07

  • Last modified date

    2020-04-07

  • 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

    OPENPAGES GRC

  • Fixed component ID

    5725D5100

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"800","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 March 2020