APAR status
Closed as program error.
Error description
Users that have Language and Locale in Maximo set to non-English receive an error when downloading delta Lookup Data only in Anywhere Technician. STEPS TO REPRODUCE: - In Maximo open Default Information and set locale and language to any other language than English - Log in with the same user to Maximo Anywhere - Download all lookup data first: Settings > Refresh Lookup Data - download successfully finishes - Refresh lookup data and select "Changes" only - an error is displayed: Lookup data could not be downloaded Error in Maximo SystemOut.log : [12/6/22 6:02:18:152 PST] 000002b0 SystemOut O 06 Dec 2022 06:02:17:559 [ERROR] [ALNDOMAIN] select count(*) from l_alndomain right outer join alndomain on (l_alndomain.ownerid=alndomain.alndomainid and l_alndomain.langcode='SV') where ((rowstamp>1051)) and ((domainid = 'PLUSCDSENGUNIT')) for read only com.ibm.db2.jcc.am.SqlSyntaxErrorException: A reference to column "ROWSTAMP" is ambiguous.. SQLCODE=-203, SQLSTATE=42702, DRIVER=4.26.14 RESULT: Lookup data, Changes only cannot be downloaded EXPECTED RESULT: Lookup data, Changes should be downloaded without any error REPORTED IN VERSION: Tivoli's process automation engine 7.6.1.2 IBM Maximo Anywhere 7.6.4.0
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Maximo users * **************************************************************** * PROBLEM DESCRIPTION: * * Users that have Language and Locale in Maximo set to * * non-English * * receive an error when downloading delta Lookup Data only in * * Anywhere Technician. * **************************************************************** STEPS TO REPRODUCE: - In Maximo open Default Information and set locale and language to any other language than English - Log in with the same user to Maximo Anywhere - Download all lookup data first: Settings > Refresh Lookup Data - download successfully finishes - Refresh lookup data and select "Changes" only - an error is displayed: Lookup data could not be downloaded Error in Maximo SystemOut.log : [12/6/22 6:02:18:152 PST] 000002b0 SystemOut O 06 Dec 2022 06:02:17:559 [ERROR] [ALNDOMAIN] select count(*) from l_alndomain right outer join alndomain on (l_alndomain.ownerid=alndomain.alndomainid and l_alndomain.langcode='SV') where ((rowstamp>1051)) and ((domainid = 'PLUSCDSENGUNIT')) for read only com.ibm.db2.jcc.am.SqlSyntaxErrorException: A reference to column "ROWSTAMP" is ambiguous.. SQLCODE=-203, SQLSTATE=42702, DRIVER=4.26.14 RESULT: Lookup data, Changes only cannot be downloaded EXPECTED RESULT: Lookup data, Changes should be downloaded without any error
Problem conclusion
The fix for this APAR will be contained in a future release.
Temporary fix
Comments
APAR Information
APAR number
IJ44620
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-12-14
Closed date
2022-12-16
Last modified date
2022-12-16
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:
16 December 2022