MxLoader

 View Only
  • 1.  MXLoader Update Row Limitation

    Posted 08-13-2024 16:28

    Hi,  Our Maximo Admins have run into issues updating a field for a table with 250,000+ rows.  Is there something in MXLoader configuration to accommodate large number of records to update?  I have "heard" there is.

    Thank you,

    Claudia Cox



    ------------------------------
    Claudia Cox
    City of Henderson
    ------------------------------



  • 2.  RE: MXLoader Update Row Limitation

    Posted 08-16-2024 16:29

    Hi @Claudia Cox 

    I see 2 parameters that are: 

    Maximum objects: Maximum number of rows that can be retrieved with a Query request. Set to 0 to disable (not recommended).

    Batch size: If you want to split the updates that MxLoader sends to the server you can set this value to 1 or more. Set it to 0 to disable (default). This setting is used only for Sync and Delete operations.

    Since there are 250,000, you could create batches of 10,000 each (25 batches).

    Regards!



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