IV93383: MAXIMO IS APPENDING A LIST OF LABOR CODES / DEFAULT SITE IN PROFILE.

APAR status

• Closed as program error.

Error description

• Maximo Asset Management 7.5.0.11  Labor Application
  
  Appending a list of labor codes that the user has right to only
  occurs if user has default site in their profile.
  
  
  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 error :
  BMXAA409E- The value specified (orgid ='XXXX') and (exists
  (select 1 from dbo.laborcraft
  where ((craft .... exceeds the maximum field lenght.  Enter a
  value that fits into the
  length of this attribute. .
  
  reproduced with latest 7505 IFIX file
  "TPAE_7505_20140301-0800.psi.zip"
  
  Steps to Reproduce
  1) Security groups > duplicate Maxadmin group - call it
  TESTGroup
  2) select newly created group TESTGroup
  3) select Labor tab -  uncheck authorize group for all labor
  4)click new row  add individual labor record  > save.
  5) continue adding all the available  labor records -   note it
  will take approx 272 records before the error occurs
  6) add newly created security group TESTGroup  to user Wilson.
  7) on MAXADMIN group > labor tab > uncheck "authorize group for
  all labor"  save.
  8) logout of MAximo
  9) log back in for the change to take place on the Maxadmin
  group.
  10) go tro Administration >  Labor Application
  11) List tab >  filter "default craft"  enter  > elect  > hit
  enter key #
  12) once results returned >  select save query  >  error
  message BMXAA409E issued.
  
  Error only appears to be happening in the Labor Application.
  
  Note: in Labor Reporting  application  the where clause appends
  the  list of labor records but does not
  through the error message -  it allows the save of the query.
  
  **This only occurs when the user has a default site set in
  their profile**.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Maximo Usres                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Maximo appending a list of over 1000 labor codes to query    *
  * results in BMXAA409E error message.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to latest release                                    *
  ****************************************************************
  Appending a list of labor codes that the user has right to only
  occurs if user has default site in their profile.
  
  When users create a query, Maximo is appending a list of Labor
  Codes that the user has rights to.  This causes the Where Clause
  to be too big to save as a Saved Query and the program displays
  error: BMXAA409E- The value specified (orgid ='XXXX') and
  (exists (select 1 from dbo.laborcraft where ((craft .... exceeds
  the maximum field length.  Enter a value that fits into the
  length of this attribute.
  
  Steps to Reproduce
  1) Security groups > duplicate Maxadmin group - call it
  TESTGroup
  2) select newly created group TESTGroup
  3) select Labor tab -  uncheck authorize group for all labor
  4) click new row  add individual labor record  > save.
  5) continue adding all the available  labor records -   note it
  will take over 1000 records before the error occurs
  6) add newly created security group TESTGroup  to user Wilson.
  7) on MAXADMIN group > labor tab > uncheck "authorize group for
  all labor"  save.
  8) logout of Maximo
  9) log back in for the change to take place on the Maxadmin
  group.
  10) go tro Administration >  Labor Application
  11) List tab >  filter "default craft"  enter  > elect  > hit
  enter key #
  12) once results returned >  select save query  >  error message
  BMXAA409E issued.
  
  Error only appears to be happening in the Labor Application.
  
  Note: in Labor Reporting application the where clause appends
  the list of labor records but does not throw the error message -
  it allows the save of the query.
  
  **This only occurs when the user has a default site set in their
  profile**.
  

Problem conclusion

• Maximo allows user to have rights to over 1000 labor codes.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Fix Pack Release 7.6.0.8 TPAE
  

Temporary fix

Comments

APAR Information

• 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

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels

• R750 PSY

     UP