BMXAA7387E - While Attempting to Retrieve 5001 of MULTIASSETLOCCI

June 7, 2016 MayOn

"BMXAA7387E - While attempting to retrieve 5001 of MULTIASSETLOCCI, the operation was terminated because the preset limit 5000 was exceeded for retrieving MULTIASSETLOCCI into a single set. Reduce the number of selected objects for the operation."

 

This error could happen to a large database.

 

We can use the  (mxe.db.fetchResultStopLimit) in the system properties application to set an upper limit on the number of objects that can be fetched from the database and constructed on the server into a single set.   For example, change the default from 5000 to 12000.

 

Changing the global value for fetch stop limit property would affect the entire application though.  If it only errors out on a particular object and that particular mxe.db.fetchResultStopLimit.OBJECTNAME property does not exist, you can a add a custom property.

For example, if there are a lot of records in multiassetlocci, we can a create property called mxe.db.fetchResultStopLimit.multiassetlocci

 

We can also set the value to "-1" so that the stop limit will not apply to a particular object.

 

Another option is to set the mxe.db.fetchStopExclusion with a comma separated list of objects that are excluded from fetch stop check.

 

 

Previous Article
Installing content item using Content Installer in IBM Control Desk 7.6
Installing content item using Content Installer in IBM Control Desk 7.6

In this blog, I will give an overview on the steps to install content item using Content Installer which is...

Next Article
IBM Decision Optimization Center - setting up the application server for SSL connections from Maximo Scheduler
IBM Decision Optimization Center - setting up the application server for SSL connections from Maximo Scheduler

While my colleague was working on installing and setting up Maximo Scheduler to connect to and use IBM Deci...

×

Want our latest news? Subscribe to our blog!

Last Name
First Name
Thank you!
Error - something went wrong!