IJ37704: 7.6.1.2 - RELATIONSHIP QUERY.MAXUSER FINDS CURRENT USER INSTEAD OF QUERY OWNER

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION
  
  The where clause for relationship QUERY.MAXUSER finds the
  MAXUSER record for the current user, but the description says it
  finds the owner of the query.
  This problem has been around for many versions.
  
  STEPS TO REPRODUCE
  
  n Maximo 7.6.1.2, navigate to the Database Configuration
  application.
  Load the QUERY object.
  Go to the Relationships tab.
  Find the MAXUSER row in the Relationships table.
  Observe the Remarks say "The user who owns this query record"
  
  RESULTS
  
  Where Clause is "userid = :userid" where :userid is a special
  substitution variable that will be replaced with the current
  user's USERID.
  
  EXPECTED RESULTS
  
  
  Expected outcome Where Clause should be "userid = :owner"
  
  PRODUCT VERSION
  
  7.6.1.2-IFIX20210407-1524
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The where clause for relationship QUERY.MAXUSER finds the    *
  * MAXUSER record for the current user, but the description     *
  * says it finds the owner of the query.                        *
  ****************************************************************
  STEPS TO REPRODUCE
  Navigate to the Database Configuration application.
  Load the QUERY object.
  Go to the Relationships tab.
  Find the MAXUSER row in the Relationships table.
  Observe the Remarks say "The user who owns this query record"
  RESULTS
  Where Clause is "userid = :userid". However, :userid is a
  special
  substitution variable that will be replaced with the current
  user's USERID. As a result, MAXUSER info returned using this
  relationship will be for the current user, not for the QUERY
  OWNER as it should be.
  EXPECTED RESULTS
  Expected outcome Where Clause should be "userid = :owner"
  

Problem conclusion

• The update of the relationship identified by relationship
  name='MAXUSER', parent='QUERY' executed only if WHERECLAUSE is
  out-of-box "userid = :userid". If customer has modified this
  relationship, it will not be updated.
  The fix for this APAR will be contained in a future release.
  

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:

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels