Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Maximo Mobile-9.1.2 Preloaded db issue

    Posted Thu April 16, 2026 07:18 AM
      |   view attached

    Hi All,

    I have configured the Technician application to use mobile prelaoded db using Person group. This is working as expected in Dev and QA. application download the db and moves on to download transaction data. However in Prod, after downloading the preloaded db, app is trying to download support data again and gets struck there. All configurations seems to be same. I don' t see any error in cron history.



    ------------------------------
    PRASAD PANDARI
    ------------------------------


  • 2.  RE: Maximo Mobile-9.1.2 Preloaded db issue

    Posted Mon April 20, 2026 07:01 AM
    Edited by Liliana Malaescu Wed April 22, 2026 04:47 AM

    Hi @PRASAD PANDARI,

    We had an issue with the Mobile Pre-loaded database cron task with Production data on a POC for one of our customers. The cron task seemed to be stuck, it did not finish running. It was giving Java Out of memory errors in the log files. The issue was solved by setting maximo.mobile.imglib.disableImagesFromLookup system property to 1, thanks to my colleagues @Steven Shull and @Ivan Lagunov.

    It would really help to check the log files (like here: https://www.ibm.com/support/pages/collecting-data-maximo-mobile-assets-application?view=full), to see what the error is in your case.

    Hope this helps!



    ------------------------------
    Liliana Malaescu
    Naviam (formerly known as ZNAPZ)
    Senior Maximo Technical Consultant
    Romania
    ------------------------------



  • 3.  RE: Maximo Mobile-9.1.2 Preloaded db issue

    Posted Mon April 20, 2026 01:30 PM
     
    Thanks to @Liliana Malaescu post, you know how to verify whether issues with pre-loaded database generation are related to IMGLIB by temporarily excluding images from the pre-loaded database.
    Please also check your MobileDBGeneration cron task history, if you hit the maximum size limit of a byte[] array, you will likely see an error similar to the following:
     
    Required array length 2147483639 + 507 is too large
     
    In this scenario I suggest, for production environments, consider using the MobileImgLibGeneration cron task while keeping the maximo.mobile.imglib.disableImagesFromLookup system property set to 0.
    Setting maximo.mobile.imglib.disableImagesFromLookup to 1 has a side effect: when users log into the MAS Mobile application, the app will still attempt to download image libraries, which can increase loading time.
    In my opinion a better approach is to keep images included in the pre-loaded database, but resize them beforehand.  IBM provides the MobileImgLibGeneration cron task for this purpose.
     
    Configuration steps:
    1. Set MAS Manage system properties
    maximo.mobile.imglib.disableImagesFromLookup = 0
    maximo.mobile.imglib.resizeatserver = 1
    maximo.mobile.imglib.resize.width = 400 (default value - adjust as needed)
    maximo.mobile.imglib.resize.height = 400
     
    2. Configure a new MobileImgLibGeneration cron task instance. Example parameters:
     
    ThreadCount = 1
    WhereClauseCond = IMGLIB.REFOBJECT in ('ASSET') AND IMGLIB.IMAGE IS NOT NULL
     
    3. Run the MobileImgLibGeneration cron task. Monitor the results in the MOBILEIMGLIB table:
     
    SELECT * FROM MOBILEIMGLIB;
     
    You can also compare the original and resized image sizes:
     
    SELECT 
        IMGLIB.IMGLIBID, 
        IMGLIB.REFOBJECT, 
        IMGLIB.IMAGENAME, 
        IMGLIB.MIMETYPE, 
        DATALENGTH(IMGLIB.IMAGE) AS IMGLIB_IMAGE_LENGTH,  
        DATALENGTH(MOBILEIMGLIB.IMAGE) AS MOBILEIMGLIB_IMAGE_LENGTH  
    FROM IMGLIB
    LEFT JOIN MOBILEIMGLIB 
        ON IMGLIB.IMGLIBID = MOBILEIMGLIB.IMGLIBID;
    
     
    4. Regenerate the mobile database - Once the image processing is complete, run the MobileDbGeneration cron task again and review the results.


    ------------------------------
    Bartosz Marchewka
    IBM Maximo Consultant
    AFRY
    ------------------------------