Maximo

 View Only

 MobileDbGeneration cron task error to query filter INVBALANCES_BINNUM

Michael Odera's profile image
Michael Odera posted Tue January 13, 2026 01:09 PM

Hi,

This error is generated with the MobileDbGeneration cron task runs to create the preload database. Any ideas on possible root causes? Thanks in advance. 

Error to query filter INVBALANCES_BINNUM page 1: BMXAA4107E - Because of an implementation or customization problem, 
the system cannot determine how the attributes of object INVBALANCES correspond to the attributes INVBALANCESID of object INVBALANCES. 
You might need to populate the MAXLOOKUPMAP table and restart the server.

Steven Shull's profile image
Steven Shull

Do you have your own table domain on INVBALANCES.BINNUM in database configuration or a retrieve list automation script on the attribute? This never used to have a lookup but for Maximo Mobile, a java class (psdi.app.inventory.FldInvBalancesBinNum) was added to provide a list of distinct binnum values. There have been some problems with the implementation of the getList (like hitting the fetch stop limit) but this is the first I've seen the MAXLOOKUPMAP error. 

Michael Odera's profile image
Michael Odera

Thanks Steve. We do not have a table domain for INVBALANCES.BINNUM.

I did get a while back, the getList limit and changed the system property mxe.db.fetchResultStopLimit.INVBALANCES global value to -1. 

I am checking on the automation scripts at the moment. I included below the full error from the cron task for context. 

Template user: MAXIMO-ADMIN;
Template user insert site: XYZ;
Person groups associated: XYZPRELOAD;
--------------------------------------
Error list:
--------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Object structure: MXAPIINVBAL;
Table name: INVBALANCES;
Select attributes: invbalancesid,siteid,itemnum,location,binnum,curbal,lotnum,conditioncode;
Saved query: ACTIVEITEMSITE;
**************************************
Error to query filter INVBALANCES_BINNUM page 1: BMXAA4107E - Because of an implementation or customization problem, the system cannot determine how the attributes of object INVBALANCES correspond to the attributes INVBALANCESID of object INVBALANCES. You might need to populate the MAXLOOKUPMAP table and restart the server.
**************************************
Error to query filter INVBALANCES_LOTNUM page 1: BMXAA4107E - Because of an implementation or customization problem, the system cannot determine how the attributes of object INVBALANCES correspond to the attributes INVBALANCESID of object INVBALANCES. You might need to populate the MAXLOOKUPMAP table and restart the server.
**************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Michael Odera's profile image
Michael Odera

This has been resolved by adding the following look up to BINNUM and LOTNUM

Target Attribute: BINNUM
Source Object: INVBALANCES
Source Key: BINNUM