Maximo

Maximo

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

 View Only

  • 1.  MAS 9 – Mobile preload DB cron failing with SQLite errors

    Posted Wed September 17, 2025 09:02 AM

    Hi,

    When I am trying to generate a preload DB for Maximo Mobile in MAS 9, the cron task is failing with an error.

    When I check the preload DB status using:

    

    

    

    

    

    

    https://<our hostname>/maximo/oslc/graphite/mobile/db?info=1&user=userid

    I see the following in the browser output:

    

    

    

    

    

    

    "STATUS": "ERROR",
"BUILDTIMESTAMP": "17/09/2025 12:44 PM",
"LANGCODE": "EN",
"STATUSINFO": {
  "LOCATIONS": {
    "ERRORMESSAGE": {
      "Error to query filter LOCATIONS_STATUS page 1": "[SQLITE_ERROR] SQL error or missing database (no such table: SCHEMAS)",
      "Error to populate page 1": "[SQLITE_BUSY] The database file is locked (database is locked)",
      "Error to query filter LOCATIONS_SITEID page 1": "[SQLITE_ERROR] SQL error or missing database (no such table: SCHEMAS)",
      "Error to query filter LOCATIONS_ORGID page 1": "[SQLITE_ERROR] SQL error or missing database (no such table: SCHEMAS)",
      "Error to query filter LOCATIONS_TYPE page 1": "[SQLITE_ERROR] SQL error or missing database (no such table: SCHEMAS)",
      "Error to store metrics": "[SQLITE_ERROR] SQL error or missing database (no such table: METRICS)"
    },
    "TABLENAME": "LOCATIONS",
    "USERID": "MOBILE",
    "SAVEDQUERY": "MOBILELOCATION",
    "OBJECTSTRUCTURE": "MXAPIOPERLOC"
  }
}

    Has anyone faced this issue before? How can we resolve it and get the preload DB to generate successfully?

    Thanks in advance for any guidance!



    -------------------------------------------


  • 2.  RE: MAS 9 – Mobile preload DB cron failing with SQLite errors

    Posted Thu September 18, 2025 12:10 PM

    Hi Sarath,

    Have you tried checking the mobile schema whether there is any error. If not, please try the below url in a browser to generate mobile schema.

    -> https://<mashost>/maximo/oslc/graphite/mobile/schema?regenerate=1

    Please verify if output has any error. if yes, please fix them first.



    ------------------------------
    Ritesh Ranjan
    ------------------------------

    Original Message


  • 3.  RE: MAS 9 – Mobile preload DB cron failing with SQLite errors

    Posted Fri November 14, 2025 10:42 AM

    Hi Sarath,

    We are also facing the same issue, did you got the any solution for the above issue please. 

    If yes, please help us on work around or fix.

    Thank you,

    Bhupal M



    ------------------------------
    Chinna BHupal Mekala
    ------------------------------

    Original Message


  • 4.  RE: MAS 9 – Mobile preload DB cron failing with SQLite errors

    Posted Fri November 14, 2025 10:48 AM

    Hi Chinna,

    I have regenerated the mobile schema and found that there are some errors. I have fixed those and the issue is sorted.

    Thanks,
    Sarath



    ------------------------------
    Sarath T
    Maximo Consultant
    ECCS Ltd
    Bristol
    ------------------------------

    Original Message


Related Content