Impossible d'insérer

meye · sam. déc. 20, 2014 9:01 am

Bonjour,
J'ai installé votre version monoposte que j'utilise pour ma petite boutique. Mais depuis 3 jours, le logiciel n'effectue plus aucune insertion. Impossible d'effectuer des mouvements. Voilà le message qui s'affiche:
"Une erreur est survenue
Impossible d'insérer
Impossible d'insérer

unable to insert SQLRowValues on /MOUVEMENT_STOCK/ : {DATE=Sat Dec 20 09:35:56 CET 2014(class java.util.Date), ID_ARTICLE=291(class java.lang.Integer), NOM=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), QTE=1.0(class java.lang.Float)} using {NOM=SQLRowValues.SQL_DEFAULT, ID_ARTICLE=291, DATE=Sat Dec 20 09:35:56 CET 2014, QTE=1.0}
org.openconcerto.utils.ExceptionHandler: Impossible d'insérer
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:112)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:660)
at org.openconcerto.erp.core.supplychain.supplier.component.MouvementStockSQLComponent.insert(MouvementStockSQLComponent.java:110)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:648)
at org.openconcerto.sql.view.EditPanel.ajouter(EditPanel.java:473)
at org.openconcerto.sql.view.EditPanel.actionPerformed(EditPanel.java:437)
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.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.sql.SQLException: unable to insert SQLRowValues on /MOUVEMENT_STOCK/ : {DATE=Sat Dec 20 09:35:56 CET 2014(class java.util.Date), ID_ARTICLE=291(class java.lang.Integer), NOM=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), QTE=1.0(class java.lang.Float)} using {NOM=SQLRowValues.SQL_DEFAULT, ID_ARTICLE=291, DATE=Sat Dec 20 09:35:56 CET 2014, QTE=1.0}
at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1330)
at org.openconcerto.sql.model.SQLRowValuesCluster$Insert.execOn(SQLRowValuesCluster.java:1020)
at org.openconcerto.sql.model.SQLRowValuesCluster$Node.store(SQLRowValuesCluster.java:936)
at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:332)
at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:1)
at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:115)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:769)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:96)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:302)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:255)
at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1300)
at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1284)
at org.openconcerto.sql.request.SQLRowView.insert(SQLRowView.java:301)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:656)
... 30 more
Caused by: java.sql.SQLException: Unable to insert prep40: INSERT INTO "OpenConcerto"."OpenConcerto48"."MOUVEMENT_STOCK" ("MODIFICATION_DATE", "ID_USER_COMMON_MODIFY", "CREATION_DATE", "ID_USER_COMMON_CREATE", "ID_ARTICLE", "DATE", "QTE", "ORDRE") select ?, ?, ?, ?, ?, ?, ?, COALESCE(MAX("ORDRE"), 0) + 1 FROM "OpenConcerto"."OpenConcerto48"."MOUVEMENT_STOCK" {1: TIMESTAMP '2014-12-20 09:36:22.122', 2: 2, 3: TIMESTAMP '2014-12-20 09:36:22.122', 4: 2, 5: 291, 6: TIMESTAMP '2014-12-20 09:35:56.975', 7: 1.0}
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1318)
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:769)
at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1308)
... 44 more
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "[5314] stream data key:800 pos:11 remaining:0". Possible solution: use the recovery tool; SQL statement:
INSERT INTO "OpenConcerto"."OpenConcerto48"."MOUVEMENT_STOCK" ("MODIFICATION_DATE", "ID_USER_COMMON_MODIFY", "CREATION_DATE", "ID_USER_COMMON_CREATE", "ID_ARTICLE", "DATE", "QTE", "ORDRE") select ?, ?, ?, ?, ?, ?, ?, COALESCE(MAX("ORDRE"), 0) + 1 FROM "OpenConcerto"."OpenConcerto48"."MOUVEMENT_STOCK" [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.Insert.insertRows(Insert.java:170)
at org.h2.command.dml.Insert.update(Insert.java:115)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:193)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1699)
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1313)
... 48 more

SVP aidez-moi, j'y avais déja enregistré tout mon stock et mes ventes.
Merci d'avance

dim. déc. 21, 2014 4:56 pm

Bonjour,

La cause est dans votre message :
"File corrupted while reading record: "[5314] stream data key:800 pos:11 remaining:0". Possible solution: use the recovery tool; SQL statement:"

Votre fichier de base de données est corrompu.
Les causes peuvent être variés: problèmes matériel (mémoire, disque dur...), coupure brutale du PC, virus, antivirus, bidouillage des fichiers...

Il faut passer par l'outil de réparation de H2, voir http://h2database.com/

Cordialement,