APAR status
Closed as program error.
Error description
PROBLEM DESCRIPTION: 7612 - Query issue with large number of location type synonyms. Problem description: When user have a large number of synonyms for location types other than storeroom (e.g. OPERATING), in LOCTYPE domain, about 275 synounms, the filter appended to the locations search can grow to the point you can no longer save a query. When trying to save the query, you get an error due to the size of the where clause that reached more than 4,000 characters. exceeding the size of the CLAUSE field in the QUERY table, where the record should be saved. Issue replicted in house in latest 7612 latest IFIX. http://mx1-docker.fyre.ibm.com:9080/maximo/webclient/login/logi n.jsp?welcome=true User - maxadmin pass - maxadmin To replicate the issue in house, a where clause was created with more than 4,000 characters, simulating what happens in the client environment with the growth of the LOCTYPE domain. Query runs successfully but cannot be saved. Steps to replicate: 1 - Go to Locations application. 2 - Press enter and maximo, by default, will rum a query with where caluse as below: ((siteid = 'BEDFORD')) and (type in ( 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR' )) 3 - change the default query below to: ((siteid = 'BEDFORD')) and (type in ( 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'REPAIR' , 'SALVAGE' , 'TEST', 'TEST', 'VENDOR' )) Maximo will procede with results. 4 - Click in Save query option. Erroneos behavior; Maximo shows the error Below: BMXAA4049E - The value specified exceeds the maximum field length that is allowed for this attribute: Value = (((siteid = 'BEDFORD')) and (type in ( 'COURIER' , 'HOLDING' , 'LABOR' , 'OP..., Object Name=QUERY, Attribute Name=CLAUSE, Maximum Length=4,000. As seid before it's because the current query exceeding the size of the CLAUSE field in the QUERY table. Expected Behavior: Once current Query worked fine, User should be able to save the query. Reported in Version: Maximo Asset Management 7.6.1.2
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * MAXIMO users * **************************************************************** * PROBLEM DESCRIPTION: * * When a large number of synonyms exist in the LOCTYPE domain * * (~275 in this case), the filter appended to the locations * * search can grow to the point where you can no longer save a * * query. * **************************************************************** Steps to replicate: 1 - Go to Locations application. 2 - Press enter and maximo, by default, will run a query with where caluse as below: ((siteid = 'BEDFORD')) and (type in ( 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR' )) 3 - In the Advanced Search - Where Clause dialog, change the default query to: ------------------------------------------- ((siteid = 'BEDFORD')) and (type in ( 'COURIER' , 'HOLDING' ,'LABOR' , 'OPERATING' , 'COURIER' , 'HOLDING', 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR','COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' ,'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR','COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' ,'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' ,'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' ,'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' ,'REPAIR' , 'COURIER' , 'HOLDING' , 'LABOR' ,'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' ,'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' ,'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR','COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' ,'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' ,'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' ,'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' ,'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' ,'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' , 'LABOR' ,'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR','COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' ,'LABOR' , 'OPERATING' , 'REPAIR' , 'SALVAGE' ,'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' , 'COURIER' ,'HOLDING' , 'LABOR' , 'OPERATING' , 'REPAIR' ,'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR' ,'COURIER' , 'HOLDING' , 'LABOR' , 'OPERATING' ,'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' , 'HOLDING' , 'LABOR', 'COURIER' , 'HOLDING' , 'LABOR' ,'OPERATING' , 'REPAIR' , 'SALVAGE' , 'VENDOR', 'COURIER' ,'HOLDING' , 'LABOR' , 'COURIER' , 'HOLDING' ,'LABOR' , 'OPERATING' , 'VENDOR', 'COURIER' , 'HOLDING' ,'LABOR' , 'REPAIR' , 'SALVAGE' , 'TEST', 'TEST', 'VENDOR' )) ------------------------------------------- 4. Click 'Find' to close the Where Clause dialog and execute the query. Maximo will return the set of locations. This is not the problem. 5 - Go to Save Query - Save Current Query and attempt to save this query. The following error is encountered: BMXAA4049E - The value specified exceeds the maximum field length that is allowed for this attribute.
Problem conclusion
The fix for this APAR is contained in the following maintenance package: Release 7.6.1.3 of Base Services
Temporary fix
Comments
APAR Information
APAR number
IJ36053
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
2021-11-09
Closed date
2022-03-18
Last modified date
2022-03-18
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
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"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"}]
Document Information
Modified date:
19 March 2022