IJ40096: THE RELATIONSHIP FOR WORKLOG.PERSON IS INCORRECT

APAR status

• Closed as program error.

Error description

• Problem description:
  
  The relationship for WORKLOG.PERSON is incorrect
  
  Currently the relationship says:
    personid = :createby
  
  but it should be:
    personid = (select personid from maxuser where
  userid=:createby)
  
  
  Steps to reproduce:
  
  1. Go to Database Configuration application
  2. Search and open WORKLOG object
  
  Current results:
  
  In the Relationship tab, the PERSON relationships has the Where
  Clause set as personid=:createby
  
  Expected results:
  
  The relationship is based on personid, but the code is based on
  userid.
  
  Environment:
  
  Tivoli's process automation engine 7.6.1.1
  
  Tivoli's process automation engine 7.6.1.2
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * THE RELATIONSHIP FOR WORKLOG.PERSON IS INCORRECT             *
  ****************************************************************
  The relationship for WORKLOG.PERSON is incorrect
  Currently the relationship says:
  personid = :createby
  but it should be:
  personid = (select personid from maxuser where
  userid=:createby)
  Steps to reproduce:
  1. Go to Database Configuration application
  2. Search and open WORKLOG object
  Current results:
  In the Relationship tab, the PERSON relationships has the Where
  Clause set as personid=:createby
  Expected results:
  The relationship is based on personid and the field help on
  WORKLOG.CREATEBY mentions 'person', but the code is based on
  userid. Need new relationship to ensure value displayed is
  PERSONID in the event that PERSONID is not the same as USERID.
  

Problem conclusion

• The update of the relationship identified by relationship
  name='PERSON', parent='WORKLOG' executed only if WHERECLAUSE is
  out-of-box "personid=:createby". If customer has modified this
  relationship, it will not be updated.
  The fix for this APAR is contained in the following maintenance
  package:  Release 7.6.1.3 of Base Services
  

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