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!

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.

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

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