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 number
IJ40096
Reported component name
MAXIMO ASST MGM
Reported component ID
5724R46AM
Reported release
761
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-05-17
Closed date
2022-05-25
Last modified date
2022-05-25
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
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761"}]
Document Information
Modified date:
26 May 2022