IBM Support

PH23284: ERROR OP-00700 WHEN USING USER PROVISIONING ROLE ASSIGNMENT TOOL

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 using the user provisioning page to assign roles, the error
    message "The requested operation could not be
    completed.UGJVYHC1OY3M - OP-00700" can be displayed.
    Aurora log shows the issue is with the query executed and the
    specific error is "ORA-01795: maximum number of expressions in a
    list is 1000"
    
    This is due to overlapping privilege groups creating too many
    conditions for the database to handle.
    

Local fix

  • Reduce the number of groups and roles assigned to users to only
    the necessary ones
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ERROR OP-00700 WHEN USING USER PROVISIONING ROLE ASSIGNMENT  *
    * TOOL                                                         *
    ****************************************************************
    * 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 hit an Oracle limit so we changed our code to break the SQL
    into smaller amounts.
    
    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

    PH23284

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

  • 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":"810","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 March 2020