Maximo Open Forum

Hi everyone,

I need some help to solve an issue that's taking me quite some time and I can't find the root cause.
In the PM application, I can see 1876 records in the list view. When I click "Export" to send them to Excel, I only get 400 records in the file.
I have another application, cloned from PM for a different department, and when I export, it works as expected-if there are 2000, 3000 records, all are exported correctly. This also works fine in other applications, but in PM it's always 400.

I checked that both applications use the same beans, and reviewing the XML I didn't find any reason for this behavior. I also checked the properties files, but since reports work well, I ruled that out.

Where could this limit be coming from? Can anyone point me in the right direction?

Thank you in advance!

#MaximoApplicationSuite

------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
------------------------------

Are you using Export application or the Download to excel option?

------------------------------
Niv Geo
------------------------------

Check in your system properties for entries that start with "mxe.db.fetchresult"

Example

(This sets the default value for all the Maixmo Objects)

Property Name: mxe.db.fetchResultStopLimit

Description: Default fetch stop limit for the objects.

Current Value: 5000

(This sets the value for fetch limit on PM. It will over-ride the default for objects.)

Property Name: mxe.db.fetchResultStopLimit.PM

Description: Default fetch stop limit for the PM object

Current Value: 8000

IBM artricle:

BMXAA7387E - While Attempting to Retrieve 5001 of MULTIASSETLOCCI

https://www.ibm.com/support/pages/bmxaa7387e-while-attempting-retrieve-5001-multiassetlocci

------------------------------
Christopher Barefield
Bechtel
------------------------------

If the fetchResultStopLimit is stopping the operation then there should be a WARN entry in the logs.

It is always worth checking the logs for clues in situations like this

------------------------------
mark robbins
Cohesive
IBM Champion 2017-2024 Inclusive
See my blog on Maximo support related topics here:
https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
------------------------------

Original Message:
Sent: 06-09-2025 11:58
From: Christopher Barefield
Subject: Limit when Exporting Records to Excel in PM Application

Check in your system properties for entries that start with "mxe.db.fetchresult"

Example

(This sets the default value for all the Maixmo Objects)

Property Name: mxe.db.fetchResultStopLimit

Description: Default fetch stop limit for the objects.

Current Value: 5000

(This sets the value for fetch limit on PM. It will over-ride the default for objects.)

Property Name: mxe.db.fetchResultStopLimit.PM

Description: Default fetch stop limit for the PM object

Current Value: 8000

IBM artricle:

BMXAA7387E - While Attempting to Retrieve 5001 of MULTIASSETLOCCI

https://www.ibm.com/support/pages/bmxaa7387e-while-attempting-retrieve-5001-multiassetlocci

------------------------------
Christopher Barefield
Bechtel
------------------------------