Maximo Open Forum

 View Only

Related Content

  • 1.  Limit when Exporting Records to Excel in PM Application

    Posted 05-29-2025 19:52

    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
    ------------------------------


  • 2.  RE: Limit when Exporting Records to Excel in PM Application

    Posted 06-06-2025 05:45

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



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



  • 3.  RE: Limit when Exporting Records to Excel in PM Application

    Posted 06-09-2025 11:58

    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
    ------------------------------



  • 4.  RE: Limit when Exporting Records to Excel in PM Application

    Posted 06-12-2025 08:44

    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