IBM Support

PH30513: OP-08531 OR OP-08563 WHEN WORKFLOW VALIDATION USE ?NOT IN? OPERATOR AGAINST MULTI VALUED USER SELECTOR FIELDS

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:
    When for a workflow you configure the following validation:
    Compare a field (Multi Valued User Selector) in the current
    object using ?not in? operator to a field (Multi Valued User
    Selector) in the current object.
    
    If you left blank (do not select a user) the related fields, the
    workflow validation fails with error OP-08531: The action could
    not be completed: invalid comparison of the value ?[Compliance
    Owner]:[]? to ?[Executive Owner]:[]? for the condition ?in?.
    
    If you only select one user and not the same user for both
    fields, the workflow validation fails with error OP-08563: The
    action could not be completed: [Compliance Owner] should not be
    in ?ORM User ? orm?
    
    Workaround:
    Not found
    
    Prerequisites:
    A.	OpenPages with solutions installed and default example data
    
    B.	Change the Display Type for two fields
    1.	Log in to OpenPages as OpenPagesAdministrator
    2.	Switch to Standard UI
    3.	Navigate to Administration > Profiles > OpenPages Modules
    Master > SOXBusEntity
    4.	Under Object Fields section, click Executive Owner
    5.	Under Object Field Information section, click Edit button
    6.	For Display Type drop-down, select Multi Valued User Selector
    
    a.	Note: You cannot reverse the display type to single value
    7.	Click Save
    8.	Repeat steps 4-7 selecting Compliance Owner field
    
    C.	Create a workflow for SOXBusEntity
    1.	Log in to OpenPages as OpenPagesAdministrator
    2.	Click cogwheel icon > Manage Workflows
    3.	Click Add New
    4.	Select:
    a.	Name= SOXBusEntity WF
    b.	Object type= Business Entity
    c.	Type= Manual Start
    5.	Click Add and then add a new Stage with name End
    6.	Change its type to End
    7.	Add an action from Start stage to End stage with name Action1
    and click Add
    8.	Under Action Properties click Add Validation
    9.	Under Compare section:
    a.	Tick A field in the current object option
    b.	Select Compliance Owner (OPSS-BusEnt:Compliance Owner) as
    Object Field
    10.	Under Using section select not in as Operator
    11.	Under To section select:
    a.	Tick A field in the current object
    b.	Select Executive Owner (OPSS-BusEnt:Executive Owner) as
    Object Field
    12.	Click Done and then click Publish
    
    Steps to Reproduce:
    1.	Log in to OpenPages as an admin user
    2.	At top-left side, click the primary menu icon > Organization
    > Business Entities
    3.	Click Add New
    4.	Provide any name, fill in any other required field and click
    Save
    5.	Click Action > Start SOXBusEntity WF and then click Continue
    6.	Error OP-08531 is shown
    7.	Select a user for Compliance Owner field
    8.	Select a user for Executive Owner field and click Save
    9.	Click Action > Start SOXBusEntity WF and then click Continue
    10.	Error OP-08563 is shown
    
    Expected Results:
    The validation should work to validate Multi Valued fields
    
    Actual Results:
    The validation fails for Multi Valued User Selector fields no
    matter the selection in the fields
    
    Error Message:
    ?	In TFUI:
    OP-08563: The action could not be completed: [Compliance Owner]
    should not be in ?ORM User ? orm?.
    
    OP-08531: The action could not be completed: invalid comparison
    of the value ?[Compliance Owner]:[]? to ?[Executive Owner]:[]?
    for the condition ?in?.
    
    ?	In arora log:
    2020-10-08 11:30:52
    CODE       : OP-08531
    LEVEL      : 4
    NAME       :
    com.ibm.openpages.api.service.ejb.workflow.impl.WFServiceExcepti
    on
    ERROR #    : UQA9KAOZP0CC
    TOKEN ID   : 5562
    USER       : OpenPagesAdministrator
    IP         : 9.163.46.2
    HOST       : 9.163.46.2
    PARAMETERS : [[Compliance Owner]:[], [Executive Owner]:[], in]
    MESSAGE    : The action could not be completed: invalid
    comparison of the value "[Compliance Owner]:[]" to "[Executive
    Owner]:[]" for the condition "in".
            at
    com.ibm.openpages.api.service.ejb.workflow.impl.WFProcessManager
    .processActions(WFProcessManager.java:1403)
            at
    com.ibm.openpages.api.service.ejb.workflow.impl.WFProcessManager
    .processTransition(WFProcessManager.java:378)
            ?
            at
    com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.jav
    a:205)
            at
    com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
    -- nested by --
    2020-10-08 11:30:53
    CODE       : OP-08531
    LEVEL      : 4
    NAME       : com.openpages.apps.common.util.ApplicationException
    ERROR #    : UQA9KAXKLWOA
    TOKEN ID   : 5562
    USER       : OpenPagesAdministrator
    IP         : 9.163.46.2
    HOST       : 9.163.46.2
    PARAMETERS : [[Compliance Owner]:[], [Executive Owner]:[], in]
    MESSAGE    : The action could not be completed: invalid
    comparison of the value "[Compliance Owner]:[]" to "[Executive
    Owner]:[]" for the condition "in".
            at
    com.openpages.apps.common.util.LoggingHelper.logError(LoggingHel
    per.java:116)
            at
    com.ibm.openpages.app.service.taskView.TaskViewService.startWork
    flow(TaskViewService.java:260)
            ?
            at
    com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.jav
    a:205)
            at
    com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
    
    ******
    
    2020-10-01 16:01:53
    CODE       : OP-08563
    LEVEL      : 4
    NAME       :
    com.ibm.openpages.api.service.ejb.workflow.impl.WFServiceExcepti
    on
    ERROR #    : UP1I5ULOMC25
    TOKEN ID   : 5095
    USER       : OpenPagesAdministrator
    IP         : 9.163.86.91
    HOST       : 9.163.86.91
    PARAMETERS : [[Compliance Owner], "ORM User - orm"]
    MESSAGE    : The action could not be completed: [Compliance
    Owner] should not be in "ORM User - orm".
            at
    com.ibm.openpages.api.service.ejb.workflow.impl.WFProcessManager
    .processActions(WFProcessManager.java:1403)
            at
    com.ibm.openpages.api.service.ejb.workflow.impl.WFProcessManager
    .processTransition(WFProcessManager.java:378)
            ...
            at
    com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
            at
    com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
    -- nested by --
    2020-10-01 16:01:53
    CODE       : OP-08563
    LEVEL      : 4
    NAME       : com.openpages.apps.common.util.ApplicationException
    ERROR #    : UP1I5UM6K9EQ
    TOKEN ID   : 5095
    USER       : OpenPagesAdministrator
    IP         : 9.163.86.91
    HOST       : 9.163.86.91
    PARAMETERS : [[Compliance Owner], "ORM User - orm"]
    MESSAGE    : The action could not be completed: [Compliance
    Owner] should not be in "ORM User - orm".
            at
    com.openpages.apps.common.util.LoggingHelper.logError(LoggingHel
    per.java:116)
            at
    com.ibm.openpages.app.service.taskView.TaskViewService.startWork
    flow(TaskViewService.java:260)
            ...
            at
    com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
            at
    com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * OP-08531 OR OP-08563 WHEN WORKFLOW VALIDATION USE ?NOT IN?   *
    * OPERATOR AGAINST MULTI VALUED USER SELECTOR FIELDS           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages with Watson 8.2 Fix Pack *
    * 2 (8.2.0.2). See the following document for details on       *
    * obtaining OpenPages 8.2.0.2:                                 *
    * https://www.ibm.com/support/pages/openpages-watson-82-fix-pa *
    * ck-2                                                         *
    ****************************************************************
    

Problem conclusion

  • There are 2 issues listed on this APAR.
    1.  "[empty field] not in [empty field]", the error is correct;
    this is not a valid comparison. To avoid this, customers can add
    an advanced logic validation to support cases where one or both
    of the fields is empty.
    2.  In the case where a multi-value field has one value, it was
    being handled as a String instead of a List, thereby failing the
    condition.  We have fixed this.
    
    Customers should download OpenPages with Watson 8.2 Fix Pack 2
    (8.2.0.2). See the following document for details on obtaining
    OpenPages 8.2.0.2:
    https://www.ibm.com/support/pages/openpages-watson-82-fix-pack-2
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH30513

  • 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-10-13

  • Closed date

    2021-04-01

  • Last modified date

    2021-04-01

  • 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:
02 April 2021