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 number
IJ01320
Reported component name
ADMINISTRATION
Reported component ID
5724R46A1
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-11-07
Closed date
2017-11-27
Last modified date
2017-11-27
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPP5","label":"System Related"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
27 November 2017