Troubleshooting
Problem
Cannot see all items or standard service Items in Item look-up.
Resolving The Problem
You can change two properties in System Properties application for the item to show up in the Lookup:
mxe.db.lookupMaxRow (default is 1000)
mxe.db.lookupMultiplier (default is 5)
By default, user could see 5000 ITEM records (lookupMaxRow (1000) * lookupMultiplier (5)).
By changing lookupMaxRow and lookupMultiplier, user could see larger set of ITEM records.
Case 1 – Cannot see all the items in Item Lookup
For example, if the database has 20000 items, changing
mxe.db.lookupMaxRow to 4000 or a bigger number can display see all items in the item lookup.
It is possible to try different numbers on both properties to get the best performance on Item Lookup.
Case 2 – Cannot see Items of Standard Service Item Type in the Lookup
For example, if the database has 10000 items and 100 of Standard Services items.
Solution: change mxe.db.lookupMaxRow to 2000.
Reason: Depends on database, Standard Service Items (ITEMTYPE=STDSERVICE) could be in the later part of Item table.
Increase one or both properties could solve the problem.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"Purchase Requisitions","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
23 December 2019
UID
swg21625217