Hi Can you help me fix this issue in windows Failed Updating database.
Image below for your reference.
[Solved] Failed to Start Unimus for Windows
Greetings,
This issue usually occurs if Unimus is restarted or stopped during startup (or during an already running DB upgrade).
If you are running on Windows and using the HSQL file database, you can solve this by doing the following steps:
- stop Unimus
- navigate to C:\ProgramData\Unimus\hsql\db and open the file db.script (you can open it in a text editor, e.g. Notepad or Notepad++, if you have it installed)
- search for the string INSERT INTO DATABASECHANGELOGLOCK
- replace the TRUE with FALSE in the brackets in the matched line
INSERT INTO DATABASECHANGELOGLOCK VALUES(1,TRUE,NULL,NULL)
to
INSERT INTO DATABASECHANGELOGLOCK VALUES(1,FALSE,NULL,NULL)
note, in your case the last two values in the brackets won't be NULL, but one will be a timestamp and another will be your computer name - you can safely ignore them and change TRUE to FALSE.
- restart Unimus.
This issue usually occurs if Unimus is restarted or stopped during startup (or during an already running DB upgrade).
If you are running on Windows and using the HSQL file database, you can solve this by doing the following steps:
- stop Unimus
- navigate to C:\ProgramData\Unimus\hsql\db and open the file db.script (you can open it in a text editor, e.g. Notepad or Notepad++, if you have it installed)
- search for the string INSERT INTO DATABASECHANGELOGLOCK
- replace the TRUE with FALSE in the brackets in the matched line
INSERT INTO DATABASECHANGELOGLOCK VALUES(1,TRUE,NULL,NULL)
to
INSERT INTO DATABASECHANGELOGLOCK VALUES(1,FALSE,NULL,NULL)
note, in your case the last two values in the brackets won't be NULL, but one will be a timestamp and another will be your computer name - you can safely ignore them and change TRUE to FALSE.
- restart Unimus.