Hallo miteinander,
Habe vor einigen Tagen neues Profil angelegt und alles hat ohne Probleme funktioniert.
Urplötzlich kann ich mir die Umsätze nicht mehr anzeigen lassen, folgende Meldung wird ausgegeben:
[Sun Jan 25 18:40:01 CET 2009][ERROR][de.willuhn.jameica.messaging.LogMessageConsumer.handleMessage] Fehler beim Öffnen des Dialogs
[Sun Jan 25 18:40:02 CET 2009][ERROR][de.willuhn.jameica.gui.GUI$2.run] error while loading view de.willuhn.jameica.hbci.gui.views.KontoauszugList
java.rmi.RemoteException: unable to init iterator. statement: prep45: select * from UMSATZ where valuta >= ? and valuta <= ? ORDER BY datum ASC, id ASC {1: DATE '2007-01-01', 2: DATE '2009-01-31'};; nested exception is:
org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0
General error: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0; SQL statement:
select * from UMSATZ where valuta >= ? and valuta <= ? ORDER BY datum ASC, id ASC [50000-79]
at de.willuhn.datasource.db.DBIteratorImpl.init(DBIteratorImpl.java:225)
at de.willuhn.datasource.db.DBIteratorImpl.hasNext(DBIteratorImpl.java:240)
at de.willuhn.jameica.hbci.gui.parts.KontoauszugList.paint(KontoauszugList.java:164)
at de.willuhn.jameica.hbci.gui.views.KontoauszugList.bind(KontoauszugList.java:45)
at de.willuhn.jameica.gui.GUI$2.run(GUI.java:456)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at de.willuhn.jameica.gui.GUI$3.run(GUI.java:643)
at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:152)
at org.eclipse.swt.widgets.Display.syncExec(Display.java:3763)
at de.willuhn.jameica.gui.GUI.startSync(GUI.java:639)
at de.willuhn.jameica.gui.GUI.startView(GUI.java:374)
at de.willuhn.jameica.gui.GUI.startView(GUI.java:545)
at de.willuhn.jameica.hbci.gui.action.KontoauszugRpt.handleAction(KontoauszugRpt.java:29)
at de.willuhn.jameica.gui.Navigation$MyActionListener.handleEvent(Navigation.java:327)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at de.willuhn.jameica.gui.GUI.loop(GUI.java:660)
at de.willuhn.jameica.gui.GUI.init(GUI.java:213)
at de.willuhn.jameica.system.Application.init(Application.java:144)
at de.willuhn.jameica.system.Application.newInstance(Application.java:86)
at de.willuhn.jameica.Main.main(Main.java:78)
Caused by: org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0
General error: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0; SQL statement:
select * from UMSATZ where valuta >= ? and valuta <= ? ORDER BY datum ASC, id ASC [50000-79]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.convert(Message.java:257)
at org.h2.message.Message.convert(Message.java:228)
at org.h2.command.Command.executeQueryLocal(Command.java:142)
at org.h2.command.Command.executeQuery(Command.java:121)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
at de.willuhn.datasource.db.DBIteratorImpl.init(DBIteratorImpl.java:198)
... 22 more
Caused by: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0
at org.h2.message.Message.getInternalError(Message.java:179)
at org.h2.store.DiskFile.getRecord(DiskFile.java:581)
at org.h2.store.Storage.getRecord(Storage.java:94)
at org.h2.index.ScanIndex.getNextRow(ScanIndex.java:258)
at org.h2.index.ScanCursor.next(ScanCursor.java:71)
at org.h2.table.TableFilter.next(TableFilter.java:317)
at org.h2.command.dml.Select.queryFlat(Select.java:479)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:547)
at org.h2.command.dml.Query.query(Query.java:233)
at org.h2.command.CommandContainer.query(CommandContainer.java:79)
at org.h2.command.Command.executeQueryLocal(Command.java:140)
... 25 more
[Sun Jan 25 18:40:02 CET 2009][ERROR][de.willuhn.jameica.messaging.LogMessageConsumer.handleMessage] Fehler beim Öffnen des Dialogs
Das Synchronisieren der Konten funktioniert weiterhin.
Erkennt man an den Logs das Problem?
Danke.
Gruß
Adrian
Habe vor einigen Tagen neues Profil angelegt und alles hat ohne Probleme funktioniert.
Urplötzlich kann ich mir die Umsätze nicht mehr anzeigen lassen, folgende Meldung wird ausgegeben:
Code
[Sun Jan 25 18:40:01 CET 2009][ERROR][de.willuhn.jameica.messaging.LogMessageConsumer.handleMessage] Fehler beim Öffnen des Dialogs
[Sun Jan 25 18:40:02 CET 2009][ERROR][de.willuhn.jameica.gui.GUI$2.run] error while loading view de.willuhn.jameica.hbci.gui.views.KontoauszugList
java.rmi.RemoteException: unable to init iterator. statement: prep45: select * from UMSATZ where valuta >= ? and valuta <= ? ORDER BY datum ASC, id ASC {1: DATE '2007-01-01', 2: DATE '2009-01-31'};; nested exception is:
org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0
General error: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0; SQL statement:
select * from UMSATZ where valuta >= ? and valuta <= ? ORDER BY datum ASC, id ASC [50000-79]
at de.willuhn.datasource.db.DBIteratorImpl.init(DBIteratorImpl.java:225)
at de.willuhn.datasource.db.DBIteratorImpl.hasNext(DBIteratorImpl.java:240)
at de.willuhn.jameica.hbci.gui.parts.KontoauszugList.paint(KontoauszugList.java:164)
at de.willuhn.jameica.hbci.gui.views.KontoauszugList.bind(KontoauszugList.java:45)
at de.willuhn.jameica.gui.GUI$2.run(GUI.java:456)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at de.willuhn.jameica.gui.GUI$3.run(GUI.java:643)
at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:152)
at org.eclipse.swt.widgets.Display.syncExec(Display.java:3763)
at de.willuhn.jameica.gui.GUI.startSync(GUI.java:639)
at de.willuhn.jameica.gui.GUI.startView(GUI.java:374)
at de.willuhn.jameica.gui.GUI.startView(GUI.java:545)
at de.willuhn.jameica.hbci.gui.action.KontoauszugRpt.handleAction(KontoauszugRpt.java:29)
at de.willuhn.jameica.gui.Navigation$MyActionListener.handleEvent(Navigation.java:327)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at de.willuhn.jameica.gui.GUI.loop(GUI.java:660)
at de.willuhn.jameica.gui.GUI.init(GUI.java:213)
at de.willuhn.jameica.system.Application.init(Application.java:144)
at de.willuhn.jameica.system.Application.newInstance(Application.java:86)
at de.willuhn.jameica.Main.main(Main.java:78)
Caused by: org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0
General error: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0; SQL statement:
select * from UMSATZ where valuta >= ? and valuta <= ? ORDER BY datum ASC, id ASC [50000-79]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.convert(Message.java:257)
at org.h2.message.Message.convert(Message.java:228)
at org.h2.command.Command.executeQueryLocal(Command.java:142)
at org.h2.command.Command.executeQuery(Command.java:121)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
at de.willuhn.datasource.db.DBIteratorImpl.init(DBIteratorImpl.java:198)
... 22 more
Caused by: java.lang.RuntimeException: File ID mismatch got=0 expected=49 pos=2050 true org.h2.store.DiskFile:C:\Users\Adrian\Daten\.jameica\hibiscus\h2db\hibiscus.data.db blockCount:0
at org.h2.message.Message.getInternalError(Message.java:179)
at org.h2.store.DiskFile.getRecord(DiskFile.java:581)
at org.h2.store.Storage.getRecord(Storage.java:94)
at org.h2.index.ScanIndex.getNextRow(ScanIndex.java:258)
at org.h2.index.ScanCursor.next(ScanCursor.java:71)
at org.h2.table.TableFilter.next(TableFilter.java:317)
at org.h2.command.dml.Select.queryFlat(Select.java:479)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:547)
at org.h2.command.dml.Query.query(Query.java:233)
at org.h2.command.CommandContainer.query(CommandContainer.java:79)
at org.h2.command.Command.executeQueryLocal(Command.java:140)
... 25 more
[Sun Jan 25 18:40:02 CET 2009][ERROR][de.willuhn.jameica.messaging.LogMessageConsumer.handleMessage] Fehler beim Öffnen des Dialogs
Das Synchronisieren der Konten funktioniert weiterhin.
Erkennt man an den Logs das Problem?
Danke.
Gruß
Adrian