IBM Support

MobileDbGeneration cron task fails with error "table SCHEMAS already exists"

Troubleshooting


Problem

MobileDbGeneration cron task fails with error:
Error message: [SQLITE_ERROR] SQL error or missing database (table SCHEMAS already exists);

Symptom

  • Open the Maximo Cron Task Setup application.
  • Select the MobileDbGeneration cron task.
  • View the history of the cron task. 
  • In the Runtime Error column of the history, the error displays:
Crontask instance ID: MobileDbGeneration.mobiledb;
Template user: maximouser;
Template user insert site: ABCD;
Person groups associated: MOBILEDBGROUP;
--------------------------------------
Error list:
--------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error message: [SQLITE_ERROR] SQL error or missing database (table SCHEMAS already exists);
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m0z0000001iYjAAI","label":"Crontask"},{"code":"a8m0z000000boKKAAY","label":"Mobility-\u003EConfiguration"}],"ARM Case Number":"TS015557561","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
23 June 2026

UID

ibm17145451

Page Feedback