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 number
IJ37704
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-02-08
Closed date
2022-10-08
Last modified date
2022-10-08
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
[{"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","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
08 October 2022