Erreur suite à écriture OD

Répondre
OikoFC
Messages : 1
Enregistré le : ven. juin 18, 2021 7:21 am

lun. juin 21, 2021 1:21 pm

Bonjour à toutes et à tous,

Nous ne comprenons pas l'erreur suivante, ni comment la corriger.
Elle apparait pour chaque compte sur lequels des écritures ont été enregistrées au journal d'OD.
Mais n'ayant pas accès au journal d'OD (d'ailleurs est-ce normal ?), il ne nous ait pas possible de les corriger

erreur 42-49 - Autres Tiers

java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT "COMPTE_PCE"."ID", "COMPTE_PCE"."NUMERO", "COMPTE_PCE"."NOM", SUM("ECRITURE"."DEBIT"), SUM("ECRITURE"."CREDIT")
FROM "OpenConcerto"."OpenConcerto48"."COMPTE_PCE", "OpenConcerto"."OpenConcerto48"."ECRITURE"
WHERE ("ECRITURE"."ID" <> 1) AND (("ECRITURE"."ARCHIVE" = 0) AND (("COMPTE_PCE"."ID" <> 1) AND (("COMPTE_PCE"."ARCHIVE" = 0) AND (("COMPTE_PCE"."NUMERO" REGEXP '^4$|^4[^0-1].*$') AND ("ECRITURE"."ID_COMPTE_PCE" = "COMPTE_PCE"."ID"))))) GROUP BY "COMPTE_PCE"."ID","COMPTE_PCE"."NUMERO","COMPTE_PCE"."NOM" ORDER BY "COMPTE_PCE"."NUMERO"
in jdbc:h2:file:/home/oikocredit/.local/share/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
org.openconcerto.utils.ExceptionHandler: erreur 42-49 - Autres Tiers
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:144)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:151)
at org.openconcerto.erp.core.finance.accounting.ui.GrandLivrePanel$2.done(GrandLivrePanel.java:139)
at java.desktop/javax.swing.SwingWorker$5.run(SwingWorker.java:750)
at java.desktop/javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(SwingWorker.java:847)
at java.desktop/sun.swing.AccumulativeRunnable.run(AccumulativeRunnable.java:112)
at java.desktop/javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(SwingWorker.java:857)
at java.desktop/javax.swing.Timer.fireActionPerformed(Timer.java:317)
at java.desktop/javax.swing.Timer$DoPostEvent.run(Timer.java:249)
at java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:313)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:770)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:740)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:117)
at java.desktop/java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:190)
at java.desktop/java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:235)
at java.desktop/java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:233)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.desktop/java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:233)
at java.desktop/java.awt.Dialog.show(Dialog.java:1070)
at java.desktop/java.awt.Component.show(Component.java:1716)
at java.desktop/java.awt.Component.setVisible(Component.java:1663)
at java.desktop/java.awt.Window.setVisible(Window.java:1031)
at java.desktop/java.awt.Dialog.setVisible(Dialog.java:1005)
at org.openconcerto.utils.ExceptionHandler.showMsg(ExceptionHandler.java:440)
at org.openconcerto.utils.ExceptionHandler.showMsgHardened(ExceptionHandler.java:225)
at org.openconcerto.utils.ExceptionHandler.lambda$0(ExceptionHandler.java:202)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.openconcerto.utils.ExceptionHandler.display(ExceptionHandler.java:205)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:144)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:151)
at org.openconcerto.erp.core.finance.accounting.ui.GrandLivrePanel$2.done(GrandLivrePanel.java:139)
at java.desktop/javax.swing.SwingWorker$5.run(SwingWorker.java:750)
at java.desktop/javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(SwingWorker.java:847)
at java.desktop/sun.swing.AccumulativeRunnable.run(AccumulativeRunnable.java:112)
at java.desktop/javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(SwingWorker.java:857)
at java.desktop/javax.swing.Timer.fireActionPerformed(Timer.java:317)
at java.desktop/javax.swing.Timer$DoPostEvent.run(Timer.java:249)
at java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:313)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:770)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:740)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT "COMPTE_PCE"."ID", "COMPTE_PCE"."NUMERO", "COMPTE_PCE"."NOM", SUM("ECRITURE"."DEBIT"), SUM("ECRITURE"."CREDIT")
FROM "OpenConcerto"."OpenConcerto48"."COMPTE_PCE", "OpenConcerto"."OpenConcerto48"."ECRITURE"
WHERE ("ECRITURE"."ID" <> 1) AND (("ECRITURE"."ARCHIVE" = 0) AND (("COMPTE_PCE"."ID" <> 1) AND (("COMPTE_PCE"."ARCHIVE" = 0) AND (("COMPTE_PCE"."NUMERO" REGEXP '^4$|^4[^0-1].*$') AND ("ECRITURE"."ID_COMPTE_PCE" = "COMPTE_PCE"."ID"))))) GROUP BY "COMPTE_PCE"."ID","COMPTE_PCE"."NUMERO","COMPTE_PCE"."NOM" ORDER BY "COMPTE_PCE"."NUMERO"
in jdbc:h2:file:/home/oikocredit/.local/share/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
at java.desktop/javax.swing.SwingWorker.get(SwingWorker.java:613)
at org.openconcerto.erp.core.finance.accounting.ui.GrandLivrePanel$2.done(GrandLivrePanel.java:130)
... 53 more
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT "COMPTE_PCE"."ID", "COMPTE_PCE"."NUMERO", "COMPTE_PCE"."NOM", SUM("ECRITURE"."DEBIT"), SUM("ECRITURE"."CREDIT")
FROM "OpenConcerto"."OpenConcerto48"."COMPTE_PCE", "OpenConcerto"."OpenConcerto48"."ECRITURE"
WHERE ("ECRITURE"."ID" <> 1) AND (("ECRITURE"."ARCHIVE" = 0) AND (("COMPTE_PCE"."ID" <> 1) AND (("COMPTE_PCE"."ARCHIVE" = 0) AND (("COMPTE_PCE"."NUMERO" REGEXP '^4$|^4[^0-1].*$') AND ("ECRITURE"."ID_COMPTE_PCE" = "COMPTE_PCE"."ID"))))) GROUP BY "COMPTE_PCE"."ID","COMPTE_PCE"."NUMERO","COMPTE_PCE"."NOM" ORDER BY "COMPTE_PCE"."NUMERO"
in jdbc:h2:file:/home/oikocredit/.local/share/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:646)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:554)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:534)
at org.openconcerto.erp.core.finance.accounting.ui.GrandLivrePanel.initClassePanel(GrandLivrePanel.java:206)
at org.openconcerto.erp.core.finance.accounting.ui.GrandLivrePanel.access$0(GrandLivrePanel.java:156)
at org.openconcerto.erp.core.finance.accounting.ui.GrandLivrePanel$2.doInBackground(GrandLivrePanel.java:123)
at org.openconcerto.erp.core.finance.accounting.ui.GrandLivrePanel$2.doInBackground(GrandLivrePanel.java:1)
at java.desktop/javax.swing.SwingWorker$1.call(SwingWorker.java:304)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.desktop/javax.swing.SwingWorker.run(SwingWorker.java:343)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException"; SQL statement:
SELECT "COMPTE_PCE"."ID", "COMPTE_PCE"."NUMERO", "COMPTE_PCE"."NOM", SUM("ECRITURE"."DEBIT"), SUM("ECRITURE"."CREDIT")
FROM "OpenConcerto"."OpenConcerto48"."COMPTE_PCE", "OpenConcerto"."OpenConcerto48"."ECRITURE"
WHERE ("ECRITURE"."ID" <> 1) AND (("ECRITURE"."ARCHIVE" = 0) AND (("COMPTE_PCE"."ID" <> 1) AND (("COMPTE_PCE"."ARCHIVE" = 0) AND (("COMPTE_PCE"."NUMERO" REGEXP '^4$|^4[^0-1].*$') AND ("ECRITURE"."ID_COMPTE_PCE" = "COMPTE_PCE"."ID"))))) GROUP BY "COMPTE_PCE"."ID","COMPTE_PCE"."NUMERO","COMPTE_PCE"."NOM" ORDER BY "COMPTE_PCE"."NUMERO" [50000-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:161)
at org.h2.message.DbException.convert(DbException.java:284)
at org.h2.command.Command.executeQuery(Command.java:208)
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:1180)
Caused by: java.lang.ArrayIndexOutOfBoundsException "


Nous avons essayé d'y accéder via la liste des écritures, mais une nouvelle erreur apparait

UncaughtException on thread Thread[UpdateQueue on ITableModel@1342901032 for /ECRITURE/1624281169251,1,main]

java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT "ECRITURE"."ID", "ECRITURE"."VALIDE", "ECRITURE"."ID_MOUVEMENT", "ECRITURE"."NOM_PIECE", "ECRITURE"."COMPTE_NUMERO", "ECRITURE"."COMPTE_NOM", "ECRITURE"."JOURNAL_NOM", "ECRITURE"."NOM", "ECRITURE"."DATE", "ECRITURE"."DEBIT", "ECRITURE"."CREDIT", "ECRITURE"."CREATION_DATE", "ECRITURE"."ID_USER_COMMON_CREATE", "ECRITURE"."MODIFICATION_DATE", "ECRITURE"."ID_USER_COMMON_MODIFY", "ECRITURE"."ORDRE", "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID", "tAlias__ID_MOUVEMENT__MOUVEMENT"."NUMERO", "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID_PIECE", "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID", "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."NOM", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."NOM", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."PRENOM", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."NOM", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."PRENOM", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_ECRITURE", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_POSTE_ANALYTIQUE", "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID", "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."NOM"
FROM "OpenConcerto"."OpenConcerto48"."ECRITURE"
LEFT JOIN "OpenConcerto"."OpenConcerto48"."MOUVEMENT" "tAlias__ID_MOUVEMENT__MOUVEMENT" on (("ECRITURE"."ID_MOUVEMENT" = "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID") AND ("tAlias__ID_MOUVEMENT__MOUVEMENT"."ARCHIVE" = 0)) AND ("tAlias__ID_MOUVEMENT__MOUVEMENT"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."PIECE" "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE" on (("tAlias__ID_MOUVEMENT__MOUVEMENT"."ID_PIECE" = "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID") AND ("tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ARCHIVE" = 0)) AND ("tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_CREATE__USER_COMMON" on (("ECRITURE"."ID_USER_COMMON_CREATE" = "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID") AND ("tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ARCHIVE" = 0)) AND ("tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON" on (("ECRITURE"."ID_USER_COMMON_MODIFY" = "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID") AND ("tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ARCHIVE" = 0)) AND ("tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."ASSOCIATION_ANALYTIQUE" "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE" on (("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_ECRITURE" = "ECRITURE"."ID") AND ("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ARCHIVE" = 0)) AND ("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."POSTE_ANALYTIQUE" "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE" on (("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_POSTE_ANALYTIQUE" = "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID") AND ("tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ARCHIVE" = 0)) AND ("tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID" <> 1)
WHERE ("ECRITURE"."ID" <> 1) AND (("ECRITURE"."ARCHIVE" = 0) AND ("ECRITURE"."DATE" BETWEEN CAST( '2020-01-01' AS date ) AND CAST( '2021-12-31' AS date )))
ORDER BY "ECRITURE"."ORDRE", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ORDRE"
in jdbc:h2:file:/home/oikocredit/.local/share/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
org.openconcerto.utils.ExceptionHandler: UncaughtException on thread Thread[UpdateQueue on ITableModel@1342901032 for /ECRITURE/1624281169251,1,main]
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:144)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:151)
at org.openconcerto.erp.config.Gestion$2.uncaughtException(Gestion.java:222)
at java.base/java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1055)
at java.base/java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1050)
at org.openconcerto.utils.SleepingQueue.exceptionThrown(SleepingQueue.java:363)
at org.openconcerto.utils.SleepingQueue$SingleThreadedExecutor.afterExecute(SleepingQueue.java:681)
at org.openconcerto.utils.SleepingQueue$SingleThreadedExecutor.process(SleepingQueue.java:655)
at org.openconcerto.utils.SleepingQueue$SingleThreadedExecutor.process(SleepingQueue.java:1)
at org.openconcerto.utils.DropperQueue.run(DropperQueue.java:193)
Caused by: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT "ECRITURE"."ID", "ECRITURE"."VALIDE", "ECRITURE"."ID_MOUVEMENT", "ECRITURE"."NOM_PIECE", "ECRITURE"."COMPTE_NUMERO", "ECRITURE"."COMPTE_NOM", "ECRITURE"."JOURNAL_NOM", "ECRITURE"."NOM", "ECRITURE"."DATE", "ECRITURE"."DEBIT", "ECRITURE"."CREDIT", "ECRITURE"."CREATION_DATE", "ECRITURE"."ID_USER_COMMON_CREATE", "ECRITURE"."MODIFICATION_DATE", "ECRITURE"."ID_USER_COMMON_MODIFY", "ECRITURE"."ORDRE", "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID", "tAlias__ID_MOUVEMENT__MOUVEMENT"."NUMERO", "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID_PIECE", "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID", "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."NOM", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."NOM", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."PRENOM", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."NOM", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."PRENOM", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_ECRITURE", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_POSTE_ANALYTIQUE", "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID", "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."NOM"
FROM "OpenConcerto"."OpenConcerto48"."ECRITURE"
LEFT JOIN "OpenConcerto"."OpenConcerto48"."MOUVEMENT" "tAlias__ID_MOUVEMENT__MOUVEMENT" on (("ECRITURE"."ID_MOUVEMENT" = "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID") AND ("tAlias__ID_MOUVEMENT__MOUVEMENT"."ARCHIVE" = 0)) AND ("tAlias__ID_MOUVEMENT__MOUVEMENT"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."PIECE" "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE" on (("tAlias__ID_MOUVEMENT__MOUVEMENT"."ID_PIECE" = "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID") AND ("tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ARCHIVE" = 0)) AND ("tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_CREATE__USER_COMMON" on (("ECRITURE"."ID_USER_COMMON_CREATE" = "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID") AND ("tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ARCHIVE" = 0)) AND ("tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON" on (("ECRITURE"."ID_USER_COMMON_MODIFY" = "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID") AND ("tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ARCHIVE" = 0)) AND ("tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."ASSOCIATION_ANALYTIQUE" "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE" on (("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_ECRITURE" = "ECRITURE"."ID") AND ("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ARCHIVE" = 0)) AND ("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."POSTE_ANALYTIQUE" "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE" on (("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_POSTE_ANALYTIQUE" = "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID") AND ("tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ARCHIVE" = 0)) AND ("tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID" <> 1)
WHERE ("ECRITURE"."ID" <> 1) AND (("ECRITURE"."ARCHIVE" = 0) AND ("ECRITURE"."DATE" BETWEEN CAST( '2020-01-01' AS date ) AND CAST( '2021-12-31' AS date )))
ORDER BY "ECRITURE"."ORDRE", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ORDRE"
in jdbc:h2:file:/home/oikocredit/.local/share/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
at org.openconcerto.utils.SleepingQueue$SingleThreadedExecutor.afterExecute(SleepingQueue.java:674)
... 3 more
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT "ECRITURE"."ID", "ECRITURE"."VALIDE", "ECRITURE"."ID_MOUVEMENT", "ECRITURE"."NOM_PIECE", "ECRITURE"."COMPTE_NUMERO", "ECRITURE"."COMPTE_NOM", "ECRITURE"."JOURNAL_NOM", "ECRITURE"."NOM", "ECRITURE"."DATE", "ECRITURE"."DEBIT", "ECRITURE"."CREDIT", "ECRITURE"."CREATION_DATE", "ECRITURE"."ID_USER_COMMON_CREATE", "ECRITURE"."MODIFICATION_DATE", "ECRITURE"."ID_USER_COMMON_MODIFY", "ECRITURE"."ORDRE", "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID", "tAlias__ID_MOUVEMENT__MOUVEMENT"."NUMERO", "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID_PIECE", "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID", "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."NOM", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."NOM", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."PRENOM", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."NOM", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."PRENOM", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_ECRITURE", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_POSTE_ANALYTIQUE", "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID", "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."NOM"
FROM "OpenConcerto"."OpenConcerto48"."ECRITURE"
LEFT JOIN "OpenConcerto"."OpenConcerto48"."MOUVEMENT" "tAlias__ID_MOUVEMENT__MOUVEMENT" on (("ECRITURE"."ID_MOUVEMENT" = "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID") AND ("tAlias__ID_MOUVEMENT__MOUVEMENT"."ARCHIVE" = 0)) AND ("tAlias__ID_MOUVEMENT__MOUVEMENT"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."PIECE" "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE" on (("tAlias__ID_MOUVEMENT__MOUVEMENT"."ID_PIECE" = "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID") AND ("tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ARCHIVE" = 0)) AND ("tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_CREATE__USER_COMMON" on (("ECRITURE"."ID_USER_COMMON_CREATE" = "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID") AND ("tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ARCHIVE" = 0)) AND ("tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON" on (("ECRITURE"."ID_USER_COMMON_MODIFY" = "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID") AND ("tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ARCHIVE" = 0)) AND ("tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."ASSOCIATION_ANALYTIQUE" "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE" on (("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_ECRITURE" = "ECRITURE"."ID") AND ("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ARCHIVE" = 0)) AND ("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."POSTE_ANALYTIQUE" "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE" on (("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_POSTE_ANALYTIQUE" = "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID") AND ("tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ARCHIVE" = 0)) AND ("tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID" <> 1)
WHERE ("ECRITURE"."ID" <> 1) AND (("ECRITURE"."ARCHIVE" = 0) AND ("ECRITURE"."DATE" BETWEEN CAST( '2020-01-01' AS date ) AND CAST( '2021-12-31' AS date )))
ORDER BY "ECRITURE"."ORDRE", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ORDRE"
in jdbc:h2:file:/home/oikocredit/.local/share/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:646)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:549)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1372)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1245)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1241)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1223)
at org.openconcerto.sql.request.FilteredFillSQLRequest.getValues(FilteredFillSQLRequest.java:197)
at org.openconcerto.sql.request.FilteredFillSQLRequest.getValues(FilteredFillSQLRequest.java:193)
at org.openconcerto.sql.view.list.SQLTableModelLinesSourceOnline.getAll(SQLTableModelLinesSourceOnline.java:79)
at org.openconcerto.sql.view.list.UpdateAllRunnable.getList(UpdateAllRunnable.java:32)
at org.openconcerto.sql.view.list.ChangeAllRunnable.run(ChangeAllRunnable.java:32)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.openconcerto.utils.SleepingQueue$SingleThreadedExecutor.process(SleepingQueue.java:653)
... 2 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0"; SQL statement:
SELECT "ECRITURE"."ID", "ECRITURE"."VALIDE", "ECRITURE"."ID_MOUVEMENT", "ECRITURE"."NOM_PIECE", "ECRITURE"."COMPTE_NUMERO", "ECRITURE"."COMPTE_NOM", "ECRITURE"."JOURNAL_NOM", "ECRITURE"."NOM", "ECRITURE"."DATE", "ECRITURE"."DEBIT", "ECRITURE"."CREDIT", "ECRITURE"."CREATION_DATE", "ECRITURE"."ID_USER_COMMON_CREATE", "ECRITURE"."MODIFICATION_DATE", "ECRITURE"."ID_USER_COMMON_MODIFY", "ECRITURE"."ORDRE", "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID", "tAlias__ID_MOUVEMENT__MOUVEMENT"."NUMERO", "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID_PIECE", "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID", "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."NOM", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."NOM", "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."PRENOM", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."NOM", "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."PRENOM", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_ECRITURE", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_POSTE_ANALYTIQUE", "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID", "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."NOM"
FROM "OpenConcerto"."OpenConcerto48"."ECRITURE"
LEFT JOIN "OpenConcerto"."OpenConcerto48"."MOUVEMENT" "tAlias__ID_MOUVEMENT__MOUVEMENT" on (("ECRITURE"."ID_MOUVEMENT" = "tAlias__ID_MOUVEMENT__MOUVEMENT"."ID") AND ("tAlias__ID_MOUVEMENT__MOUVEMENT"."ARCHIVE" = 0)) AND ("tAlias__ID_MOUVEMENT__MOUVEMENT"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."PIECE" "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE" on (("tAlias__ID_MOUVEMENT__MOUVEMENT"."ID_PIECE" = "tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID") AND ("tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ARCHIVE" = 0)) AND ("tAlias__ID_MOUVEMENT__ID_PIECE__PIECE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_CREATE__USER_COMMON" on (("ECRITURE"."ID_USER_COMMON_CREATE" = "tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID") AND ("tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ARCHIVE" = 0)) AND ("tAlias__ID_USER_COMMON_CREATE__USER_COMMON"."ID" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON" on (("ECRITURE"."ID_USER_COMMON_MODIFY" = "tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID") AND ("tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ARCHIVE" = 0)) AND ("tAlias__ID_USER_COMMON_MODIFY__USER_COMMON"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."ASSOCIATION_ANALYTIQUE" "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE" on (("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_ECRITURE" = "ECRITURE"."ID") AND ("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ARCHIVE" = 0)) AND ("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto48"."POSTE_ANALYTIQUE" "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE" on (("tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ID_POSTE_ANALYTIQUE" = "tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID") AND ("tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ARCHIVE" = 0)) AND ("tAlias__ID_ECRITURE__ID_POSTE_ANALYTIQUE__POSTE_ANALYTIQUE"."ID" <> 1)
WHERE ("ECRITURE"."ID" <> 1) AND (("ECRITURE"."ARCHIVE" = 0) AND ("ECRITURE"."DATE" BETWEEN CAST( '2020-01-01' AS date ) AND CAST( '2021-12-31' AS date )))
ORDER BY "ECRITURE"."ORDRE", "tAlias__ID_ECRITURE__ASSOCIATION_ANALYTIQUE"."ORDRE" [50000-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:161)
at org.h2.message.DbException.convert(DbException.java:284)
at org.h2.command.Command.executeQuery(Command.java:208)
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:1180)
Caused by: java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:329)
at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:100)
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.queryFlat(Select.java:527)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:632)
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)
... 4 more


Merci de nous aider à y voir plus clair
Avatar du membre
guillaume
Messages : 2429
Enregistré le : ven. févr. 11, 2011 7:15 pm

lun. juin 21, 2021 8:25 pm

Bonjour,

Votre fichier de base de données est corrompu.

Restaurez depuis une sauvegarde ou passez par notre hotline (pour restauration ou réparation) .

Cordialement,
Directeur technique d'OpenConcerto qui dans son temps libre s'occupe du forum.
Pour une assistance pro, nous sommes joignables à ILM Informatique contre quelques jetons.
Pensez aussi à lire le manuel !
Répondre