IBM Support

PH20395: SUBQUERY RETURNED MORE THAN 1 VALUE. THIS IS NOT PERMITTED WHEN THE SUBQUERY FOLLOWS =, !=, <, <= , >, >= OR WHEN THE SUBQUERY

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

  • OPEN

Error description

  • User clicks "Maintain - Period locking - Change-Period locking".
    User selects any period, and locks (or unlocks) one of the
    companies in the list.
    User clicks 'Save' (to save changes). An error appears.
    
    Subquery returned more than 1 value. This is not permitted when
    the subquery follows =, !=, <, <= , >, >= or when the subquery
    is used as an expression
    
    Difference between this and  APAR PH12550 is that the problem
    can be reproduced when multiple users lock\unlock companies and
    multiple values are put into sactrlinfo at the same time.
    Need to refactor the tracking in audit trail for period locking
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH20395

  • Reported component name

    COG CONTROLLER

  • Reported component ID

    5724W24CO

  • Reported release

    A40

  • Status

    OPEN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-12-17

  • Closed date

  • Last modified date

    2020-02-11

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSC7SN5","label":"Controller"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
21 April 2020