message d'erreur

marika · ven. août 04, 2017 10:04 pm

Help !

Depuis peu des messages d'erreur apparaissent lorsque j'enregistre une facture. J'ai dû mal enregistré un fournisseur ou une facture mais je n'arrive pas à trouver le ou les erreurs...
Merci de votre aide !!!

Erreur lors de la génération des écritures.

unable to insert SQLRowValues on /ECRITURE/ : {COMPTE_NUMERO=512(class java.lang.String), DATE=2016-08-12(class java.sql.Date), ID_MOUVEMENT=336(class java.lang.Integer), CREDIT=41071(class java.lang.Long), DEBIT=0(class java.lang.Long), JOURNAL_CODE=BA(class java.lang.String), ID_COMPTE_PCE=279(class java.lang.Integer), NOM=Règlement Achat : Metro Facture : 1563 (Virement)(class java.lang.String), ID_JOURNAL=4(class java.lang.Integer), COMPTE_NOM=Banques(class java.lang.String), JOURNAL_NOM=Banque(class java.lang.String), IDUSER_CREATE=2(class java.lang.Integer)} using {COMPTE_NUMERO=512, ID_MOUVEMENT=336, CREDIT=41071, JOURNAL_CODE=BA, ID_COMPTE_PCE=279, NOM=Règlement Achat : Metro Facture : 1563 (Virement), ID_JOURNAL=4, JOURNAL_NOM=Banque, DATE=2016-08-12, DEBIT=0, IDUSER_CREATE=2, COMPTE_NOM=Banques}
org.openconcerto.utils.ExceptionHandler: Erreur lors de la génération des écritures.
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:125)
at org.openconcerto.erp.generationEcritures.GenerationEcritures$1.run(GenerationEcritures.java:184)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
at java.awt.Dialog.show(Dialog.java:1084)
at java.awt.Component.show(Component.java:1671)
at java.awt.Component.setVisible(Component.java:1623)
at java.awt.Window.setVisible(Window.java:1014)
at java.awt.Dialog.setVisible(Dialog.java:1005)
at org.openconcerto.utils.ExceptionHandler.showMsg(ExceptionHandler.java:444)
at org.openconcerto.utils.ExceptionHandler.showMsgHardened(ExceptionHandler.java:197)
at org.openconcerto.utils.ExceptionHandler.display(ExceptionHandler.java:168)
at org.openconcerto.utils.ExceptionHandler.<init>(ExceptionHandler.java:473)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:125)
at org.openconcerto.erp.generationEcritures.GenerationEcritures$1.run(GenerationEcritures.java:184)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
at java.awt.Dialog.show(Dialog.java:1084)
at java.awt.Component.show(Component.java:1671)
at java.awt.Component.setVisible(Component.java:1623)
at java.awt.Window.setVisible(Window.java:1014)
at java.awt.Dialog.setVisible(Dialog.java:1005)
at org.openconcerto.utils.ExceptionHandler.showMsg(ExceptionHandler.java:444)
at org.openconcerto.utils.ExceptionHandler.showMsgHardened(ExceptionHandler.java:197)
at org.openconcerto.utils.ExceptionHandler.display(ExceptionHandler.java:168)
at org.openconcerto.utils.ExceptionHandler.<init>(ExceptionHandler.java:473)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:125)
at org.openconcerto.erp.generationEcritures.GenerationEcritures$1.run(GenerationEcritures.java:184)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
at java.awt.Dialog.show(Dialog.java:1084)
at java.awt.Component.show(Component.java:1671)
at java.awt.Component.setVisible(Component.java:1623)
at java.awt.Window.setVisible(Window.java:1014)
at java.awt.Dialog.setVisible(Dialog.java:1005)
at org.openconcerto.utils.ExceptionHandler.showMsg(ExceptionHandler.java:444)
at org.openconcerto.utils.ExceptionHandler.showMsgHardened(ExceptionHandler.java:197)
at org.openconcerto.utils.ExceptionHandler.display(ExceptionHandler.java:168)
at org.openconcerto.utils.ExceptionHandler.<init>(ExceptionHandler.java:473)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:125)
at org.openconcerto.erp.generationEcritures.GenerationEcritures$1.run(GenerationEcritures.java:184)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
at java.awt.Dialog.show(Dialog.java:1084)
at java.awt.Component.show(Component.java:1671)
at java.awt.Component.setVisible(Component.java:1623)
at java.awt.Window.setVisible(Window.java:1014)
at java.awt.Dialog.setVisible(Dialog.java:1005)
at org.openconcerto.utils.ExceptionHandler.showMsg(ExceptionHandler.java:444)
at org.openconcerto.utils.ExceptionHandler.showMsgHardened(ExceptionHandler.java:197)
at org.openconcerto.utils.ExceptionHandler.display(ExceptionHandler.java:168)
at org.openconcerto.utils.ExceptionHandler.<init>(ExceptionHandler.java:473)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:125)
at org.openconcerto.erp.generationEcritures.GenerationEcritures$1.run(GenerationEcritures.java:184)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.sql.SQLException: unable to insert SQLRowValues on /ECRITURE/ : {COMPTE_NUMERO=512(class java.lang.String), DATE=2016-08-12(class java.sql.Date), ID_MOUVEMENT=336(class java.lang.Integer), CREDIT=41071(class java.lang.Long), DEBIT=0(class java.lang.Long), JOURNAL_CODE=BA(class java.lang.String), ID_COMPTE_PCE=279(class java.lang.Integer), NOM=Règlement Achat : Metro Facture : 1563 (Virement)(class java.lang.String), ID_JOURNAL=4(class java.lang.Integer), COMPTE_NOM=Banques(class java.lang.String), JOURNAL_NOM=Banque(class java.lang.String), IDUSER_CREATE=2(class java.lang.Integer)} using {COMPTE_NUMERO=512, ID_MOUVEMENT=336, CREDIT=41071, JOURNAL_CODE=BA, ID_COMPTE_PCE=279, NOM=Règlement Achat : Metro Facture : 1563 (Virement), ID_JOURNAL=4, JOURNAL_NOM=Banque, DATE=2016-08-12, DEBIT=0, IDUSER_CREATE=2, COMPTE_NOM=Banques}
at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1882)
at org.openconcerto.sql.model.SQLRowValuesCluster$Insert.execOn(SQLRowValuesCluster.java:1636)
at org.openconcerto.sql.model.SQLRowValuesCluster$Node.store(SQLRowValuesCluster.java:1540)
at org.openconcerto.sql.model.SQLRowValuesCluster$Node.store(SQLRowValuesCluster.java:1535)
at org.openconcerto.sql.model.SQLRowValuesCluster$Node.access$3(SQLRowValuesCluster.java:1534)
at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:486)
at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:1)
at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:149)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:883)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:127)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:99)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:453)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:372)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:367)
at org.openconcerto.sql.model.SQLRowValues.store(SQLRowValues.java:1853)
at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1833)
at org.openconcerto.erp.generationEcritures.GenerationEcritures.ajoutEcriture(GenerationEcritures.java:170)
at org.openconcerto.erp.generationEcritures.GenerationMvtReglementFactureFournisseur.genereReglement(GenerationMvtReglementFactureFournisseur.java:135)
at org.openconcerto.erp.generationEcritures.GenerationMvtReglementFactureFournisseur.run(GenerationMvtReglementFactureFournisseur.java:232)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Unable to insert prep50: INSERT INTO "OpenConcerto"."OpenConcerto48"."ECRITURE" ("MODIFICATION_DATE", "ID_USER_COMMON_MODIFY", "CREATION_DATE", "ID_USER_COMMON_CREATE", "COMPTE_NUMERO", "ID_MOUVEMENT", "CREDIT", "JOURNAL_CODE", "ID_COMPTE_PCE", "NOM", "ID_JOURNAL", "JOURNAL_NOM", "DATE", "DEBIT", "IDUSER_CREATE", "COMPTE_NOM", "ORDRE") select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, COALESCE(MAX("ORDRE"), 0) + 1 FROM "OpenConcerto"."OpenConcerto48"."ECRITURE" {1: TIMESTAMP '2017-08-04 23:52:12.081', 2: 2, 3: TIMESTAMP '2017-08-04 23:52:12.081', 4: 2, 5: '512', 6: 336, 7: 41071, 8: 'BA', 9: 279, 10: STRINGDECODE('R\u00e8glement Achat : Metro Facture : 1563 (Virement)'), 11: 4, 12: 'Banque', 13: DATE '2016-08-12', 14: 0, 15: 2, 16: 'Banques'}
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1870)
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:883)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1860)
... 21 more
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "[6704] stream data key:94 pos:11 remaining:0". Possible solution: use the recovery tool; SQL statement:
INSERT INTO "OpenConcerto"."OpenConcerto48"."ECRITURE" ("MODIFICATION_DATE", "ID_USER_COMMON_MODIFY", "CREATION_DATE", "ID_USER_COMMON_CREATE", "COMPTE_NUMERO", "ID_MOUVEMENT", "CREDIT", "JOURNAL_CODE", "ID_COMPTE_PCE", "NOM", "ID_JOURNAL", "JOURNAL_NOM", "DATE", "DEBIT", "IDUSER_CREATE", "COMPTE_NOM", "ORDRE") select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, COALESCE(MAX("ORDRE"), 0) + 1 FROM "OpenConcerto"."OpenConcerto48"."ECRITURE" [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:2330)
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1865)
... 26 more

doc · ven. août 04, 2017 11:19 pm

Bonjour,

A priori votre base de donnée est endommagée :

Code : Tout sélectionner

Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "[6704] stream data key:94 pos:11 remaining:0". Possible solution: use the recovery tool;

Essayez de la restaurer si vous avez fait une sauvegarde.

marika · dim. août 06, 2017 9:34 am

Damned non pas fait de sauvegarde. Suis sur la route donc pas de sauvegarde possible. Je recommencerai une fois rentrée. Merci pour votre aide !

marika · ven. août 18, 2017 5:24 am

Rebonjour,
L'installation est faite sur un serveur Postgresql.
Comment restaurer la base via avec les fichiers qui ont été générés par OpenConcerto avec la commande de sauvergarde?
Merci d'avance.

doc · ven. août 18, 2017 8:16 am

Bonjour,

Vous avez créée une nouvelle installation ou l'installation d'origine était sur PostgreSQL ?? Dans les logs il semble que l'installation soit configurée pour utiliser une base H2.

Si c'est une nouvelle installation, vous ne pouvez pas importer les données de la base H2 (elle est corrompue), je vous conseille de passer par ILM qui pourra peut être faire quelque chose.