IBM Support

IV27819: MAXIMO IS APPENDING A LIST OF LABOR CODES THAT THE USER HAS RIGHTS TO

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When users create a query, Maximo is appending a list of Labor
    Codes that the user has rights to.Sometimes it appends the list
    more than once.This causes the Where Clause to be too big to
    save as a Saved Query and the program displays the BMXAA4049E
    error.
    
    I have one security group that has rights to all labor and so
    there are no records in the LABORAUTH table for this group and
    they do not get the error above when saving a query.
    
    Normal users belong to security groups that specify the Labor
    Records they have access to.For each Labor / Group combination
    there is a record in LABORAUTH.
    
    Maximo is appending this list in the Where Clause and this is
    causing the problem. In any case a normal user cannot create
    Saved Queries in Work Order Tracking, Quick Reporting,
    Assignment Manager or any of the Labor related applications.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: all                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: When users create a query, Maximo is    *
    *                      appending a list of Labor               *
    *                                                              *
    *                      Codes that the user has rights          *
    *                      to.Sometimes it appends the list        *
    *                                                              *
    *                      more than once.This causes the Where    *
    *                      Clause to be too big to                 *
    *                                                              *
    *                      save as a Saved Query and the program   *
    *                      displays the BMXAA4049E                 *
    *                                                              *
    *                      error.                                  *
    *                                                              *
    *                      I have one security group that has      *
    *                      rights to all labor and so              *
    *                                                              *
    *                      there are no records in the LABORAUTH   *
    *                      table for this group and                *
    *                                                              *
    *                      they do not get the error above when    *
    *                      saving a query.                         *
    *                                                              *
    *                      Normal users belong to security groups  *
    *                      that specify the Labor                  *
    *                                                              *
    *                      Records they have access to.For each    *
    *                      Labor / Group combination               *
    *                                                              *
    *                      there is a record in LABORAUTH.         *
    *                                                              *
    *                      Maximo is appending this list in the    *
    *                      Where Clause and this is                *
    *                                                              *
    *                      causing the problem. In any case a      *
    *                      normal user cannot create               *
    *                                                              *
    *                      Saved Queries in Work Order Tracking,   *
    *                      Quick Reporting,                        *
    *                                                              *
    *                      Assignment Manager or any of the Labor  *
    *                      related applications.                   *
    *                                                              *
    *                      LOCAL FIX:                              *
    *                                                              *
    *                      N/A                                     *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    ****************************************************************
    MAXIMO IS APPENDING A LIST OF LABOR CODES THAT THE USER HAS
    RIGHTS TO
    

Problem conclusion

  • Two problems are fixed:
    
    
    
    
    
    1. the labor related security where clause should not be saved
    as part of the query (when you do save query)
    
    2. Fixed sql error when there are more than 1000 individual
    labors authorized
    
    
    
    
    
    The fix for this APAR is contained in the following maintenance
    package:
    
      | release\fix pack | Release 7.5.0.4 of Base Services
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV27819

  • Reported component name

    ADMINISTRATION

  • Reported component ID

    5724R46A1

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-09-11

  • Closed date

    2012-09-14

  • Last modified date

    2012-09-14

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

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

Modules/Macros

  • MAXIMO
    

Fix information

  • Fixed component name

    ADMINISTRATION

  • Fixed component ID

    5724R46A1

Applicable component levels

  • R750 PSY

       UP



Document information

More support for: Maximo Asset Management
System Related

Software version: 750

Reference #: IV27819

Modified date: 14 September 2012