IBM Support

IV95094: MID ERRORS IN A QUERY SECTION IF QUERY HAS A 'GROUP BY' AND A RECORD IS REMOVED AFTER APPLYING FILTER CRITERIA

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • If a query section exists in a record, that query section
    has a "Find' and a 'Remove,' and if that query has a 'Group By'
    in it, the 'Remove' will issue a MID error (even though the
    removal actually takes place) if filter criteria is applied
    prior to clicking 'Remove.'
    
    The problem does not happen if no filter criteria is applied
    prior to clicking 'Remove' or if the query associated with the
    query section does not have a 'Group By.'
    
    This problem has been seen in multiple platform releases
    including, most recently, 3.4.2.5 as well and 3.5.2.1.
    

Local fix

  • If you refresh the record after getting the MID error, you will
    see that the record listed in the query section was actually
    removed.
    
    To avoid the MID error happening, modify the query section's
    query and rwmove the 'Group By' or instruct users not to apply
    any filter criteria before clicking 'Remove.'
    

Problem summary

  • Need to change the submit of page method to "Get" for non state
    changing actions like "refresh" or "Clear Filter"
    

Problem conclusion

  • De-Associate action on GroupBy report no more throws any
    exception after applying filter to the query.
    This is targeted to the 1h2017 release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV95094

  • Reported component name

    TRI APPLCATION

  • Reported component ID

    5725F26AB

  • Reported release

    342

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-13

  • Closed date

    2017-04-20

  • Last modified date

    2017-04-23

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

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

Modules/Macros

  • 999
    

Fix information

Applicable component levels

  • R352 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCWLWM","label":"IBM TRIRIGA Application builder"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"342","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
23 April 2017