Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG]Third team won't open #2205

Open
007Mike1 opened this issue Dec 21, 2024 · 4 comments
Open

[BUG]Third team won't open #2205

007Mike1 opened this issue Dec 21, 2024 · 4 comments
Labels
scope: database issues related to HO hsql database

Comments

@007Mike1
Copy link

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Screenshots
If applicable, add screenshots to help explain your problem.

Platform information:

  • OS: [Windows / macOS / Linux]
  • Version (including build number)

Additional context
Add any other context about the problem here.

Copy link

Hey, thanks for opening your first issue! 🙂
Be sure to check out the wiki and the HT forum for support.

@007Mike1
Copy link
Author

I got three teams in my HO database. With the first two I don't have any problems to open it.
But when I wan't to open my third team, I get next error.

java.sql.SQLException: General error
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.HRFTable.loadHRF(HRFTable.java:156)
at core.db.HRFTable.loadHRF(HRFTable.java:142)
at core.db.DBManager.loadHRF(DBManager.java:826)
at core.model.HOModel.(HOModel.java:107)
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: General error
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.result.Result.newErrorResult(Unknown Source)
at org.hsqldb.result.Result.newErrorResult(Unknown Source)
at org.hsqldb.StatementDMQL.execute(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 19 more

I don't had that problem past week, it worked perfect.
Greetings,

@007Mike1
Copy link
Author

007Mike1 commented Dec 21, 2024

Windows
HO 8.1

@wsbrenk
Copy link
Collaborator

wsbrenk commented Dec 21, 2024

This could be a corrupted database - this can happen if the ho application is killed during a database action.
Please try to restore a backup which is located in your database folder. On windows most propably in %APPDATA%/HO/dbn (with n=3 for your third team!??). There you'll find three zip files. Try to override your existing database files with the contents of one of your backups.

If that does not work, please load the backup zip to this thread, if you want us to debug this error.

@wsbrenk wsbrenk added the scope: database issues related to HO hsql database label Dec 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
scope: database issues related to HO hsql database
Projects
None yet
Development

No branches or pull requests

2 participants