Cannot launch HO 8.1/ Startup error

[tordy78]

After update I'm unable to launch HO. This message is displayed:

java.sql.SQLException: IO error: RowInputBinary 4615476

Guessing this is a software deficiency on my computer, but can't figure out what it is?

Full message as follows:

java.sql.SQLException: IO error: RowInputBinary 4615476
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source)
at core.db.ConnectionManager.executePreparedQuery(ConnectionManager.kt:73)
at core.db.ConnectionManager.executePreparedQuery(ConnectionManager.kt:63)
at core.db.SpielerTable.loadAllPlayers(SpielerTable.java:160)
at core.db.DBManager.loadAllPlayers(DBManager.java:366)
at core.model.HOModel.(HOModel.java:116)
at core.model.HOVerwaltung.loadModel(HOVerwaltung.java:193)
at core.model.HOVerwaltung.loadLatestHoModel(HOVerwaltung.java:117)
at core.HO.main(HO.java:197)
at core.HOLauncher.main(HOLauncher.java:81)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:84)
at com.exe4j.runtime.WinLauncher.main(WinLauncher.java:94)
at com.install4j.runtime.launcher.WinLauncher.main(WinLauncher.java:25)
Caused by: org.hsqldb.HsqlException: IO error: RowInputBinary 4615476
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
at org.hsqldb.rowio.RowInputBinaryDecode.readData(Unknown Source)
at org.hsqldb.RowAVLDisk.(Unknown Source)
at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)
at org.hsqldb.persist.DataFileCache.get(Unknown Source)
at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)
at org.hsqldb.index.NodeAVLDisk.getRight(Unknown Source)
at org.hsqldb.index.IndexAVL.next(Unknown Source)
at org.hsqldb.index.IndexAVL.next(Unknown Source)
at org.hsqldb.index.IndexAVL$IndexRowIterator.getNextRow(Unknown Source)
at org.hsqldb.index.IndexAVL$IndexRowIterator.next(Unknown Source)
at org.hsqldb.RangeVariable$RangeIteratorMain.findNext(Unknown Source)
at org.hsqldb.RangeVariable$RangeIteratorMain.next(Unknown Source)
at org.hsqldb.QuerySpecification.buildResult(Unknown Source)
at org.hsqldb.QuerySpecification.getResult(Unknown Source)
at org.hsqldb.TableDerived.materialise(Unknown Source)
at org.hsqldb.StatementDMQL.materializeSubQueries(Unknown Source)
at org.hsqldb.StatementDMQL.execute(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 18 more
Caused by: java.io.UTFDataFormatException
at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
... 45 more

[wsbrenk]

first guess is, that is a corrupt database - please try to restore one of your backups. they are in %APPDATA%/Ho/db. PLease restore the database files of one of the zip files.

[tordy78]

That was probably it. Did a "hard reset" and I'm up and running again 👍

Thank you very much!