APAR status
Closed as program error.
Error description
PROBLEM: Special character searches and operator searches are not working as expected based on the below documentation. i) & operator not working as expected. Searching for filter & oil creates a where clause of: (status != 'OBSOLETE' and contains(description, 'filter && & && oil') = 1 and itemsetid = 'ITEMSET') Searching for filter oil creates a where clause of: (status != 'OBSOLETE' and contains(description, 'filter && oil') = 1 and itemsetid = 'ITEMSET') ii) ~ operator not working at all Searching for filter ~air throws the below error within Maximo. BMXAA6713E - The MBO fetch operation failed in the mboset with the SQL error code -171. The record could not be retrieved from the database. See the log file for more details about the error. Document the client is referencing - https://www.ibm.com/support/knowledgecenter/SSLKT6_7.6.1/com.ibm .mbs.doc/gp_ui/r_wildcard_operator_search.html PERFORMANCE ISSUE: N STEPS TO REPRODUCE: Steps to Reproduce: Login to Maximo Go to Inventory / Item Master in the description field search for pipe & male Hit enter. No results Now go do the same in a Oracle database the search will return results. If you look at the query for the DB2 test the query doesn't look right compared to the Oracle database. CURRENT ERRONEOUS RESULT: EXPECTED RESULT: Filter the same way Orcale does. ADDITIONAL INFO: ENVIRONMENT (SYSTEM INFO): App ServerIBM WebSphere Application Server 8.5.5.5VersionIBM Maximo Transportation 7.6.2.4 Build 20170221-0604 DB Build V7624-02IBM Maximo for Oil And Gas 7.6.1.0 Build 20161020-0803 DB Build V7610-139Tivoli's process automation engine 7.6.0.9-IFIX20180420-1312 Build 20171127-0100 DB Build V7609-45 HFDB Build HF7609-04IBM Maximo Calibration 7.6.0.0 Build 20171127-0100 DB Build V7600-06IBM TPAE Integration Framework 7.6.0.9 Build 20171126-2330 DB Build V7609-32IBM Maximo Linear Management 7.6.0.2 Build 20171127-0100 DB Build V7602-03IBM Maximo Asset Management Scheduler 7.6.7.0 Build 20171127-0100 DB Build V7670-56 HFDB Build HF7670-17IBM Maximo Spatial Asset Management 7.6.0.2 Build 20170518-1103 DB Build V7602-23IBM Maximo for Utilities 7.6.0.2 Build 20171128-1353 DB Build V7602-68IBM Maximo Asset Management Work Centers 7.6.0.3 Build 20171121-0723 DB Build V7603-175IBM Maximo Asset Management 7.6.0.9 Build 20171127-0100 DB Build V7604-01Server OSLinux 2.6.32-754.el6.x86_64Server DBDB2/LINUXX8664 10.5 (SQL1005A) LOCAL FIX: N/A SECURITY IMPACT (Y/N): N
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * MAXIMO * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 TEXT SEARCH SPECIAL CHARACTER SEARCHES ARE NOT WORKING * * AS EXPECTED BASED ON THE BELOW DOCUMENTATION. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is contained in the following maintenance package: | release\fix pack | Interim Fix for Release 7.6.1.2 Product
Temporary fix
Comments
APAR Information
APAR number
IJ16170
Reported component name
SYSTEM CONFIG
Reported component ID
5724R46S1
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-05-15
Closed date
2019-08-06
Last modified date
2019-08-06
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
SYSTEM CONFIG
Fixed component ID
5724R46S1
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
06 August 2019