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.

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

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