OnTheGo/API: SystemID error ("Service cannot be started")

Issue

The OnTheGo application produces a "Service cannot be started" error with the log indicating a systemID error.

The systemID mismatch error occurs when you move databases between servers. Specifically the API service is being run from a different server than the database expects.

Full error code:

EXCEPTION: System.Exception: SytemId mismatch. This windows installation is not configured to connect to that database.

Solution

To fix the systemID error, delete the contents of the fields SYSTEMID and DBID from GENERAL_INFO table and run the start service again. This should create the fields and insert new values in them.

The OnTheGo DB updates should be on the same server as the API install.

It assumed you have the latest version of the API.