IBM Support

PH26735: CALCULATION THAT UPDATES OBJECT BASED ON THE GRANDCHILDREN THAT HAVE A FILTER CONDITION ON GRANDCHILD FIELD DOES NOT UPDATE

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

  • Description:
    An 8.2 calculation that updates an object based on grandchild
    objects (that have a filter-by condition on grand-child
    /descendant input fields) is not updated when the grandchild
    object changes.
    
    Create a calc definition which has an input field.
    
    Scenario:
    Risk Object = KRI Value Aggregation field
    Key Risk Indicator (KRI) associated to Risk
    Key Risk Indicator Value (KRIV) associated to KRI
    
    Calcs
    Input Field = KRI Value  = 2020
    
    Calculation sums this input field if Risk YR=2020 and Risk
    Month=Jan:
    
    Calc expression for KRI Value:
    if ([$Yr$]=='2020' and [$Month$]=='Jan' ) then SUM ([$KRI Value
    2020 Jan$])
    elif ([$Yr$]=='2020' and [$Month$]=='Feb' ) then SUM ([$KRI
    Value 2020 Feb$])
    elif ([$Yr$]=='2020' and [$Month$]=='Mar' ) then SUM ([$KRI
    Value 2020 Mar$]) //
    remaining calcs to be coded covering each yr / month
    else 0
    endif
    
    The calculation works fine for adding KRI Values and updating
    the Risk Year/Month fields. But it doesn?t work if updating an
    existing KRI value to change the Yr/Month ? the previous value
    remains.
    
    
     Prerequisites:
    
    1.      Create a calc definition which has an input field. The
    input field refers to the grand child object and with Filter-By
    condition.
    For example, a calc definition on Risk object. An input field
    refers KRI Value with path Risk/KRI/KRI Value . It has Filter-By
    condition where the Collection Status has to be Awaiting
    Collection. Then the second operation of the calc sets the count
    of the KRI Values on a text or integer field ( such as General
    Guidance )
    
    Steps to Reproduce:
    
    1.      Add grand child object that meets the filter criteria
    and change the input field
    2.      Open the object that has calc definition and check that
    the expected field has not been updated
    
    
    
    Expected Results:
    The grand child object addition is reflected to the calc output
    field.
    
    Actual Results:
    The grand child object addition is not reflected to the calc
    output field.
    
    Error Message:
    
    2020-06-14 22:37:35,617
    ERROR TBCalcLogUtil on opapp
    TBCalcQueueProcessor     run         Exception
    
    [Default Executor-thread-43](LogUtils.java:438)
    
    java.lang.NullPointerException
                  at
    com.ibm.openpages.api.service.ejb.calc.impl.TBCalcManager.revers
    eResolve(TBCalcManager.java:1174)
                  at
    com.ibm.openpages.api.service.ejb.calc.impl.TBCalcManager.buildQ
    ueueRecursively(TBCalcManager.java:625)
                  at
    com.ibm.openpages.api.service.ejb.calc.impl.TBCalcManager.buildQ
    ueue(TBCalcManager.java:300)
                  at
    com.ibm.openpages.api.service.ejb.calc.impl.TBCalcQueueProcessor
    .run(TBCalcQueueProcessor.java:72)
                  at
    com.ibm.ws.threading.internal.PolicyTaskFutureImpl.run(PolicyTas
    kFutureImpl.java:715)
                  at
    com.ibm.ws.threading.internal.PolicyExecutorImpl.runTask(PolicyE
    xecutorImpl.java:1135)
                  at
    com.ibm.ws.threading.internal.PolicyExecutorImpl$GlobalPoolTask.
    run(PolicyExecutorImpl.java:189)
                  at
    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
    utor.java:1160)
                  at
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
    cutor.java:635)
                  at java.lang.Thread.run(Thread.java:820)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * CALCULATION THAT UPDATES OBJECT BASED ON THE GRANDCHILDREN   *
    * THAT HAVE A FILTER CONDITION ON GRANDCHILD FIELD DOES NOT    *
    * UPDATE                                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages with Watson 8.2 Fix Pack *
    * 1 (8.2.0.1). See the following document for details on       *
    * obtaining OpenPages 8.2.0.1:                                 *
    * https://www.ibm.com/support/pages/openpages-watson-82-fix-pa *
    * ck-1                                                         *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH26735

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-06-23

  • Closed date

    2020-11-23

  • Last modified date

    2020-11-23

  • 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

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

Document Information

Modified date:
24 November 2020