IJ01320: BMXAA6713E ERROR IN BROWSER WHEN FILTERING SERVICE ITEMS USING A SECONDARY LANGUAGE

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE:
  1) Log in to Maximo using a Secondary language
  2) Go to Service Items Application
  3) Press Enter to get list of Service Items (this shows that
  records exist)
  4) In Description Field enter search string and press Enter
  
  CURRENT ERRONEOUS RESULT:
  Error Message in Browser
  "BMXAA6713E - Operacija pridobitve MPO-jev ni uspela v naboru
  MPO-jev skodo napake SQL -206. Zapisa ni bilo mogoce priklicati
  iz baze podatkov.
   Za vec podrobnosti o napaki si oglejte datoteko dnevnika. Vec
  informacij"
  
  This example is in Slovenian. Other languages are affected as
  well
  
  Error message in SystemOut.log
  com.ibm.db2.jcc.am.SqlSyntaxErrorException: "NULL.DESCRIPTION"
  is not valid in the context where it is used.. SQLCODE=-206,
  SQLSTATE=42703,
  DRIVER=4.11.69
      at com.ibm.db2.jcc.am.gd.a(gd.java:676)
      at com.ibm.db2.jcc.am.gd.a(gd.java:60)
      at com.ibm.db2.jcc.am.gd.a(gd.java:127)
  
  EXPECTED RESULT:
  Filter should work without error
  
  ENVIRONMENT:
  Tivoli's process automation engine 7.6.0.8 Build 20170512-
  0100 DB Build V7608-63
  IBM TPAE Integration Framework 7.6.0.8 Build 20170510-2330 DB
  Build V7608-43TPAE OSLC Object Structure 7.6.2.0 Build
  20170508_113717-0500 DB Build V7620-01
  IBM Maximo Asset Management Scheduler 7.6.5.0 Build
  20170512-0100 DB Build V7650-98
  IBM Maximo Spatial Asset Management 7.6.0.2-20170807-0935 Build
  20170523-0238 DB Build V7602-23 HFDB Build HF7601-00
  IBM Maximo Anywhere 7.6.2.0 Build 20170508_113729-0500 DB Build
  V7620-03
  IBM Maximo for Utilities 7.6.0.1 Build 20170518-1923 DB Build
  V7601-08
  IBM Maximo Asset Management Work Centers 7.6.0.2 Build
  20170509-0906 DB Build V7602-57
  IBM Maximo Asset Management 7.6.0.8 Build 20170512-0100 DB Build
  V7604-01
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users in multi-language environments                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In the Service Items application, sql error was encountered  *
  * filtering on the Description field on the list tab when user *
  * signed in maximo with a second language.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * none                                                         *
  ****************************************************************
  

Problem conclusion

• This is fixed in code.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.0.10 Product
  

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:

Modules/Macros

• maximo
  

Fix information

• Fixed component name

  ADMINISTRATION

• Fixed component ID

  5724R46A1

Applicable component levels

• R760 PSY

     UP