IJ44620: MAXIMO ANYWHERE REFRESH LOOKUP DATA DELTA ERROR WITH NON EN USER

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 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