IBM Support

IJ48020: THE WHERE CONDITIONAL IN WORK QUERIES SHOULD ONLY BE EDITABLE FOR THE USER WHO CREATED IT.

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

  • The Where Conditional can be edited through the Quick Query
    Builder by a different user than the one who created the
    schedule. This shouldn't be possible and the same warning
    message, which pops up when the Where Conditional is changed in
    SQL Expression Builder, should be shown at this time.
    
    BMXAA0019I - The Where Condition field is either read only or
    part of the primary key. You cannot edit this field.
    
    STEPS TO REPLICATE:
    
    Log in as wilson/wilson
    
    1) Go to Graphical Scheduling application and filter for
    schedules that were not created by user Wilson.
    
    2) In the main tab > under Work Queries section > click on the
    arrow next to the Where Condition field > Sql Expression Builder
    
    
    3) Try to modify the expression and hint OK
    
    The following message will pop up as expected:
    
    BMXAA0019I - The Where Condition field is either read only or
    part of the primary key. You cannot edit this field.
    
    OK
    
    4) Again click on the arrow next to the Where Condition field >
    Quick Query Builder
    
    5) Fill in any fields you want, for example:
    Asset: 1140
    Class: WORKORDER
    Site: BEDFORD
    
    OK
    
    CURRENT ERRONEOUS RESULT: The Where Condition field will be
    update with the new attributes and infos
    
    EXPECTED RESULT: The Where Condition field should not be updated
    and neither should be saved with this.
    
    
    Version of Maximo: 7613 - Schedule 7682
    
    Application within Maximo: Graphical Scheduling
    

Local fix

  • na
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Scheduler users                                              *
    ****************************************************************
    

Problem conclusion

  • A fix for this APAR will be included in a future release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ48020

  • Reported component name

    MAXIMO SCHEDULE

  • Reported component ID

    5724R46SE

  • Reported release

    768

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-08-24

  • Closed date

    2023-08-29

  • Last modified date

    2023-08-29

  • 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

    MAXIMO SCHEDULE

  • Fixed component ID

    5724R46SE

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9NUN","label":"Maximo Asset Management Scheduler"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"768","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
29 August 2023