habe das Ganze noch einmal neu installiert, ganz am Anfang nach den zweiten Start vom Programm, taucht folgende Fehlermeldung in der Logfile auf:

[quote=Logfile: .fakturama2/.metadata/.log.]
!SESSION 2018-04-20 14:11:37.474 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.8.0_162
java.vendor=Oracle Corporation
BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=de_DE
Command-line arguments: -os linux -ws gtk -arch x86_64

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-04-20 14:12:58.766
!MESSAGE create Document list part
!SESSION 2018-04-20 14:12:59.709 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.8.0_162
java.vendor=Oracle Corporation
BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=de_DE
Command-line arguments: -os linux -ws gtk -arch x86_64

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_hu 2 0 2018-04-20 14:13:15.484
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_hu [396]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.osgi.compatibility.state.nl_eu 2 0 2018-04-20 14:13:15.484
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_eu [4]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_tr 2 0 2018-04-20 14:13:15.484
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_tr [401]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.osgi.compatibility.state.nl_hu 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_hu [6]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.osgi.compatibility.state.nl_it 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_it [7]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_ru 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_ru [400]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.osgi.compatibility.state.nl_ru 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_ru [10]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_it 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_it [397]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_pl 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_pl [398]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.osgi.compatibility.state.nl_pl 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_pl [8]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.osgi.compatibility.state.nl_fr 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_fr [5]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.osgi.compatibility.state.nl_es 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_es [3]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_de 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_de [392]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.osgi.compatibility.state.nl_tr 2 0 2018-04-20 14:13:15.485
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_tr [11]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_fr 2 0 2018-04-20 14:13:15.486
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_fr [395]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.osgi.compatibility.state.nl_de 2 0 2018-04-20 14:13:15.486
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_de [2]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.osgi.compatibility.state.nl_ro 2 0 2018-04-20 14:13:15.486
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_ro [9]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_eu 2 0 2018-04-20 14:13:15.486
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_eu [394]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_uk 2 0 2018-04-20 14:13:15.486
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_uk [402]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.osgi.compatibility.state.nl_uk 2 0 2018-04-20 14:13:15.486
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_uk [12]
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_ro 2 0 2018-04-20 14:13:15.486
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_ro [399]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.e4.ui.swt.gtk.nl_es 2 0 2018-04-20 14:13:15.486
!MESSAGE Could not resolve module: org.eclipse.e4.ui.swt.gtk.nl_es [393]
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk
Unresolved requirement: Fragment-Host: org.eclipse.e4.ui.swt.gtk

!ENTRY org.eclipse.osgi 4 0 2018-04-20 14:13:15.487
!MESSAGE Anwendungsfehler
!STACK 1
org.eclipse.e4.core.di.InjectionException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@fb4620de[file =/home/harald/SyncThing-Office/Fakturama/Database/Database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-04-20 12:13:14 heartbeat - read: -4513 ms.
Error Code: -451
at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:65)
at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:305)
at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:233)
at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:107)
at org.eclipse.e4.ui.internal.workbench.swt.E4Application.createE4Workbench(E4Application.java:274)
at org.eclipse.e4.ui.internal.workbench.swt.E4Application.start(E4Application.java:149)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
at org.eclipse.equinox.launcher.Main.run(Main.java:1499)
at org.eclipse.equinox.launcher.Main.main(Main.java:1472)
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@fb4620de[file =/home/harald/SyncThing-Office/Fakturama/Database/Database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-04-20 12:13:14 heartbeat - read: -4513 ms.
Error Code: -451
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:844)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:216)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:324)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:348)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:311)
at org.eclipse.gemini.ext.di.impl.GeminiEMSupplier.get(GeminiEMSupplier.java:31)
at org.eclipse.e4.core.internal.di.InjectorImpl.resolveArgs(InjectorImpl.java:516)
at org.eclipse.e4.core.internal.di.InjectorImpl.resolveRequestorArgs(InjectorImpl.java:457)
at org.eclipse.e4.core.internal.di.InjectorImpl.inject(InjectorImpl.java:113)
at org.eclipse.e4.core.internal.di.InjectorImpl.internalMake(InjectorImpl.java:399)
at org.eclipse.e4.core.internal.di.InjectorImpl.make(InjectorImpl.java:318)
at org.eclipse.e4.core.contexts.ContextInjectionFactory.make(ContextInjectionFactory.java:162)
at com.sebulli.fakturama.migration.MigrationManager.migrateOldData(MigrationManager.java:304)
at com.sebulli.fakturama.startup.ConfigurationManager.checkAndUpdateConfiguration(ConfigurationManager.java:175)
at com.sebulli.fakturama.LifecycleManager.processAdditions(LifecycleManager.java:441)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:55)
... 18 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@fb4620de[file =/home/harald/SyncThing-Office/Fakturama/Database/Database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-04-20 12:13:14 heartbeat - read: -4513 ms.
Error Code: -451
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:316)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:147)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:228)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:804)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:254)
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:757)
... 37 more
Caused by: java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@fb4620de[file =/home/harald/SyncThing-Office/Fakturama/Database/Database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-04-20 12:13:14 heartbeat - read: -4513 ms.
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
at org.eclipse.gemini.jpa.datasource.PlainDriverDataSource.getConnection(PlainDriverDataSource.java:56)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:144)
... 42 more
Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@fb4620de[file =/home/harald/SyncThing-Office/Fakturama/Database/Database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-04-20 12:13:14 heartbeat - read: -4513 ms.
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)
at org.hsqldb.persist.Logger.acquireLock(Unknown Source)
at org.hsqldb.persist.Logger.open(Unknown Source)
at org.hsqldb.Database.reopen(Unknown Source)
at org.hsqldb.Database.open(Unknown Source)
at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
at org.hsqldb.DatabaseManager.newSession(Unknown Source)
... 47 more

Hallo Harry,
ab der Version 2.0.1 gibt es wieder ein Backup der Datenbank. Dort müßten jetzt mehrere Sicherungen liegen. Gibt es da evtl. noch eine ältere, in der das funktioniert hat?
Der Fehler, den Du hier beschreibst, liegt an der HSQL-Datenbank. Die hat ein Problem mit den vergrößerten Feldern, die ich aber der Version 2 eingeführt habe (z. B. für die Beschreibungstexte).
Wenn Du Fakturama mit "-clean" startest, wird die Konfiguration für das programm nochmal neu geladen, das dürfte zumindest zeitweise helfen.
Ich glaube, langfristig hilft hier tatsächlich nur ein Wechsel auf MySQL.

Hallo miteinander!
Bei mir tauchte das Problem ebenfalls auf, ich konnte ab Kundennummer 40 - ca, nichts mehr speichern, bis dahin funktionierte Fakturama aber einwandfrei!
Ich stieg wieder auf 1.9.6. um und bleib einstweilen dabei!

Freundliche Grüße!

Hallo Ralf,
leider nichts mehr vorhanden, alles deinstalliert, tut mir leid!
Freundliche Grüße!

rheydenr schrieb:
-------------------------------------------------------
> Hallo Harry,
> ab der Version 2.0.1 gibt es wieder ein Backup der
> Datenbank. Dort müßten jetzt mehrere Sicherungen
> liegen. Gibt es da evtl. noch eine ältere, in der
> das funktioniert hat?
> Der Fehler, den Du hier beschreibst, liegt an der
> HSQL-Datenbank. Die hat ein Problem mit den
> vergrößerten Feldern, die ich aber der Version 2
> eingeführt habe (z. B. für die
> Beschreibungstexte).
> Wenn Du Fakturama mit "-clean" startest, wird die
> Konfiguration für das programm nochmal neu
> geladen, das dürfte zumindest zeitweise helfen.
> Ich glaube, langfristig hilft hier tatsächlich
> nur ein Wechsel auf MySQL.

Bei 2.0.0 hat das Speichern noch funktioniert, erst ab 2.0.1 nicht mehr.