OpenConcerto

Official forum about OpenConcerto
https://www.openconcerto.org/forum/

message d'erreur

https://www.openconcerto.org/forum/viewtopic.php?f=2&t=1950

Page 1 sur 1

message d'erreur

Posté : ven. août 04, 2017 10:04 pm
par marika
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

Re: message d'erreur

Posté : ven. août 04, 2017 11:19 pm
par doc
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.

Re: message d'erreur

Posté : dim. août 06, 2017 9:34 am
par marika
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 !

Re: message d'erreur

Posté : ven. août 18, 2017 5:24 am
par marika
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.

Re: message d'erreur

Posté : ven. août 18, 2017 8:16 am
par doc
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.
Heures au format UTC
Page 1 sur 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/