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!

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!

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

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!