message d'erreur création de facture

[gfrede]

Bonjour
Voila mon probleme lors de la création de "vente"

"

Impossible d'accéder au résultat de SELECT max("SAISIE_VENTE_FACTURE_ELEMENT"."ORDRE")
FROM "OpenConcerto"."OpenConcerto49"."SAISIE_VENTE_FACTURE_ELEMENT"
in jdbc:h2:file:C:\Users\gfred\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto
org.openconcerto.utils.ExceptionHandler:
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:125)
at org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent.commit(SaisieVenteFactureSQLComponent.java:1359)
at org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent.insert(SaisieVenteFactureSQLComponent.java:1094)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:695)
at org.openconcerto.sql.view.EditPanel.ajouter(EditPanel.java:472)
at org.openconcerto.sql.view.EditPanel.actionPerformed(EditPanel.java:436)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT max("SAISIE_VENTE_FACTURE_ELEMENT"."ORDRE")
FROM "OpenConcerto"."OpenConcerto49"."SAISIE_VENTE_FACTURE_ELEMENT"
in jdbc:h2:file:C:\Users\gfred\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:640)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:550)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:530)
at org.openconcerto.sql.model.SQLTable.getMaxOrder(SQLTable.java:1220)
at org.openconcerto.sql.view.list.RowValuesTableModel.commitData(RowValuesTableModel.java:298)
at org.openconcerto.sql.view.list.RowValuesTableModel.updateField(RowValuesTableModel.java:532)
at org.openconcerto.sql.view.list.RowValuesTableModel.updateField(RowValuesTableModel.java:547)
at org.openconcerto.sql.view.list.RowValuesTableModel.updateField(RowValuesTableModel.java:542)
at org.openconcerto.sql.view.list.RowValuesTable.updateField(RowValuesTable.java:270)
at org.openconcerto.erp.core.common.ui.AbstractArticleItemTable.updateField(AbstractArticleItemTable.java:157)
at org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent.commit(SaisieVenteFactureSQLComponent.java:1266)
... 41 more
Caused by: java.sql.SQLException: second exec failed: File corrupted while reading record: "[8073] stream data key:480 pos:11 remaining:0". Possible solution: use the recovery tool; SQL statement:
SELECT max("SAISIE_VENTE_FACTURE_ELEMENT"."ORDRE")
FROM "OpenConcerto"."OpenConcerto49"."SAISIE_VENTE_FACTURE_ELEMENT" [90030-175]
at org.openconcerto.sql.model.SQLDataSource.executeTwice(SQLDataSource.java:965)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:608)
... 51 more
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "[8073] stream data key:480 pos:11 remaining:0". Possible solution: use the recovery tool; SQL statement:
SELECT max("SAISIE_VENTE_FACTURE_ELEMENT"."ORDRE")
FROM "OpenConcerto"."OpenConcerto49"."SAISIE_VENTE_FACTURE_ELEMENT" [90030-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:240)
at org.h2.index.PageDataNode.getNextPage(PageDataNode.java:231)
at org.h2.index.PageDataLeaf.getNextPage(PageDataLeaf.java:396)
at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:93)
at org.h2.index.PageDataCursor.next(PageDataCursor.java:52)
at org.h2.index.IndexCursor.next(IndexCursor.java:274)
at org.h2.table.TableFilter.next(TableFilter.java:359)
at org.h2.command.dml.Select.queryGroup(Select.java:323)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:627)
at org.h2.command.dml.Query.query(Query.java:314)
at org.h2.command.dml.Query.query(Query.java:284)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:91)
at org.h2.command.Command.executeQuery(Command.java:196)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.openconcerto.sql.model.SQLDataSource$ExecutorThread.run(SQLDataSource.java:1157)"

Si quelque avait m'apportez une solution.
Merci d'avance

[guillaume]

Bonjour,

File corrupted while reading record

Le ficher de la base de données est corrompu.

Cordialement,

[gfrede]

Bonjour Guillaume et merci
Mais que dois je faire?
Suppression/ré installation? ou il y a une autre solution?
Merci d'avance

[guillaume]

Bonjour,

3 choix :
- restaurer le fichier depuis une sauvegarde
- faire réparer le fichier par la hotline
- effacer le fichier et donc tout reprendre de zéro.

Cordialement,