erreur lancement logiciel de caisse

Répondre
aucoindujeu
Messages : 7
Enregistré le : ven. déc. 18, 2020 9:14 pm

sam. juil. 24, 2021 2:16 pm

Bonjour à vous.

J'ai un souci sur ma caisse qui est intervenu en plein milieu de journée.
J'avoue n'avoir aucune idée de ce qui a pu provoquer le problème.

Erreur d'initialisation de la caisse (main)

Impossible d'accéder au résultat de SELECT "ARTICLE"."ID", "ARTICLE"."ARCHIVE", "ARTICLE"."ID_FAMILLE_ARTICLE", "ARTICLE"."NOM", "ARTICLE"."CODE", "ARTICLE"."CODE_BARRE", "ARTICLE"."ID_TAXE", "ARTICLE"."PV_HT", "ARTICLE"."PV_TTC", "ARTICLE"."ADDITIONAL_TICKET_COPY", "ARTICLE"."ID_UNITE_VENTE"
FROM "OpenConcerto"."OpenConcerto49"."ARTICLE"
WHERE ("ARTICLE"."ID" <> 1) AND (("ARTICLE"."ARCHIVE" = 0) AND (("ARTICLE"."OBSOLETE" = false) AND ("ARTICLE"."MASQUE_CAISSE" = false)))
in jdbc:h2:file:C:\Users\Ponan\AppData\Roaming\OpenConcerto\Data\DBData/OpenConcerto;DATABASE_TO_UPPER=false
org.openconcerto.utils.ExceptionHandler: Erreur d'initialisation de la caisse (main)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:144)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:151)
at org.openconcerto.erp.core.sales.pos.ui.CaisseFrame$3.run(CaisseFrame.java:252)
at java.awt.event.InvocationEvent.dispatch(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.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 "ARTICLE"."ID", "ARTICLE"."ARCHIVE", "ARTICLE"."ID_FAMILLE_ARTICLE", "ARTICLE"."NOM", "ARTICLE"."CODE", "ARTICLE"."CODE_BARRE", "ARTICLE"."ID_TAXE", "ARTICLE"."PV_HT", "ARTICLE"."PV_TTC", "ARTICLE"."ADDITIONAL_TICKET_COPY", "ARTICLE"."ID_UNITE_VENTE"
FROM "OpenConcerto"."OpenConcerto49"."ARTICLE"
WHERE ("ARTICLE"."ID" <> 1) AND (("ARTICLE"."ARCHIVE" = 0) AND (("ARTICLE"."OBSOLETE" = false) AND ("ARTICLE"."MASQUE_CAISSE" = false)))
in jdbc:h2:file:C:\Users\Ponan\AppData\Roaming\OpenConcerto\Data\DBData/OpenConcerto;DATABASE_TO_UPPER=false
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:650)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:558)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:538)
at org.openconcerto.sql.model.SQLSelectHandlerBuilder.execute(SQLSelectHandlerBuilder.java:85)
at org.openconcerto.sql.model.SQLRowListRSH.execute(SQLRowListRSH.java:181)
at org.openconcerto.sql.model.SQLRowListRSH.execute(SQLRowListRSH.java:177)
at org.openconcerto.erp.core.sales.pos.ui.CaissePanel.loadArticles(CaissePanel.java:246)
at org.openconcerto.erp.core.sales.pos.ui.CaissePanel.<init>(CaissePanel.java:88)
at org.openconcerto.erp.core.sales.pos.ui.CaisseFrame.<init>(CaisseFrame.java:82)
at org.openconcerto.erp.core.sales.pos.ui.CaisseFrame$3.run(CaisseFrame.java:228)
... 14 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SELECT "ARTICLE"."ID", "ARTICLE"."ARCHIVE", "ARTICLE"."ID_FAMILLE_ARTICLE", "ARTICLE"."NOM", "ARTICLE"."CODE", "ARTICLE"."CODE_BARRE", "ARTICLE"."ID_TAXE", "ARTICLE"."PV_HT", "ARTICLE"."PV_TTC", "ARTICLE"."ADDITIONAL_TICKET_COPY", "ARTICLE"."ID_UNITE_VENTE"
FROM "OpenConcerto"."OpenConcerto49"."ARTICLE"
WHERE ("ARTICLE"."ID" <> 1) AND (("ARTICLE"."ARCHIVE" = 0) AND (("ARTICLE"."OBSOLETE" = false) AND ("ARTICLE"."MASQUE_CAISSE" = false))) [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:1243)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 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
aucoindujeu
Messages : 7
Enregistré le : ven. déc. 18, 2020 9:14 pm

sam. juil. 24, 2021 3:23 pm

par ailleurs, j'ai un problème sur la liste des articles : je peux les consulter si je recherche parmi les catégories mais je ne peux pas voir l'intégralité des articles.
UncaughtException on thread Thread[UpdateQueue on ITableModel@27728287 for /ARTICLE/1627140085043,1,main]

java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT "ARTICLE"."ID", "ARTICLE"."CODE", "ARTICLE"."NOM", "ARTICLE"."PA_HT", "ARTICLE"."PV_HT", "ARTICLE"."ID_TAXE", "ARTICLE"."PV_TTC", "ARTICLE"."ID_FAMILLE_ARTICLE", "ARTICLE"."ID_FOURNISSEUR", "ARTICLE"."SKU", "ARTICLE"."GESTION_STOCK", "ARTICLE"."ID_STOCK", "ARTICLE"."CREATION_DATE", "ARTICLE"."ID_USER_COMMON_CREATE", "ARTICLE"."MODIFICATION_DATE", "ARTICLE"."ID_USER_COMMON_MODIFY", "ARTICLE"."ORDRE", "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID", "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."NOM", "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR", "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."NOM", "tAlias__ID_STOCK__STOCK"."ID", "tAlias__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_STOCK__STOCK"."QTE_MIN", "tAlias__ID_STOCK__STOCK"."QTE_LIV_ATTENTE", "tAlias__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_STOCK__STOCK"."ID_DEPOT_STOCK", "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID", "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."NOM", "tAlias__ID_TAXE__TAXE"."ID_TAXE", "tAlias__ID_TAXE__TAXE"."TAUX", "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_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID_ARTICLE_PARENT", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."QTE"
FROM "OpenConcerto"."OpenConcerto49"."ARTICLE"
LEFT JOIN "OpenConcerto"."OpenConcerto49"."FAMILLE_ARTICLE" "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE" on (("ARTICLE"."ID_FAMILLE_ARTICLE" = "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID") AND ("tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."FOURNISSEUR" "tAlias__ID_FOURNISSEUR__FOURNISSEUR" on (("ARTICLE"."ID_FOURNISSEUR" = "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR") AND ("tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ARCHIVE" = 0)) AND ("tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."STOCK" "tAlias__ID_STOCK__STOCK" on (("ARTICLE"."ID_STOCK" = "tAlias__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_STOCK__STOCK"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."DEPOT_STOCK" "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK" on (("tAlias__ID_STOCK__STOCK"."ID_DEPOT_STOCK" = "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID") AND ("tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."TAXE" "tAlias__ID_TAXE__TAXE" on (("ARTICLE"."ID_TAXE" = "tAlias__ID_TAXE__TAXE"."ID_TAXE") AND ("tAlias__ID_TAXE__TAXE"."ARCHIVE" = 0)) AND ("tAlias__ID_TAXE__TAXE"."ID_TAXE" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_CREATE__USER_COMMON" on (("ARTICLE"."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 (("ARTICLE"."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"."OpenConcerto49"."ARTICLE_ELEMENT" "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT" on (("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID_ARTICLE_PARENT" = "ARTICLE"."ID") AND ("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID" <> 1)
WHERE ("ARTICLE"."ID" <> 1) AND (("ARTICLE"."ARCHIVE" = 0) AND ("ARTICLE"."OBSOLETE" = false))
ORDER BY "ARTICLE"."ORDRE", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ORDRE"
in jdbc:h2:file:C:\Users\Ponan\AppData\Roaming\OpenConcerto\Data\DBData/OpenConcerto;DATABASE_TO_UPPER=false
org.openconcerto.utils.ExceptionHandler: UncaughtException on thread Thread[UpdateQueue on ITableModel@27728287 for /ARTICLE/1627140085043,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:226)
at java.lang.ThreadGroup.uncaughtException(Unknown Source)
at java.lang.ThreadGroup.uncaughtException(Unknown Source)
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 "ARTICLE"."ID", "ARTICLE"."CODE", "ARTICLE"."NOM", "ARTICLE"."PA_HT", "ARTICLE"."PV_HT", "ARTICLE"."ID_TAXE", "ARTICLE"."PV_TTC", "ARTICLE"."ID_FAMILLE_ARTICLE", "ARTICLE"."ID_FOURNISSEUR", "ARTICLE"."SKU", "ARTICLE"."GESTION_STOCK", "ARTICLE"."ID_STOCK", "ARTICLE"."CREATION_DATE", "ARTICLE"."ID_USER_COMMON_CREATE", "ARTICLE"."MODIFICATION_DATE", "ARTICLE"."ID_USER_COMMON_MODIFY", "ARTICLE"."ORDRE", "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID", "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."NOM", "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR", "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."NOM", "tAlias__ID_STOCK__STOCK"."ID", "tAlias__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_STOCK__STOCK"."QTE_MIN", "tAlias__ID_STOCK__STOCK"."QTE_LIV_ATTENTE", "tAlias__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_STOCK__STOCK"."ID_DEPOT_STOCK", "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID", "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."NOM", "tAlias__ID_TAXE__TAXE"."ID_TAXE", "tAlias__ID_TAXE__TAXE"."TAUX", "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_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID_ARTICLE_PARENT", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."QTE"
FROM "OpenConcerto"."OpenConcerto49"."ARTICLE"
LEFT JOIN "OpenConcerto"."OpenConcerto49"."FAMILLE_ARTICLE" "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE" on (("ARTICLE"."ID_FAMILLE_ARTICLE" = "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID") AND ("tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."FOURNISSEUR" "tAlias__ID_FOURNISSEUR__FOURNISSEUR" on (("ARTICLE"."ID_FOURNISSEUR" = "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR") AND ("tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ARCHIVE" = 0)) AND ("tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."STOCK" "tAlias__ID_STOCK__STOCK" on (("ARTICLE"."ID_STOCK" = "tAlias__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_STOCK__STOCK"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."DEPOT_STOCK" "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK" on (("tAlias__ID_STOCK__STOCK"."ID_DEPOT_STOCK" = "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID") AND ("tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."TAXE" "tAlias__ID_TAXE__TAXE" on (("ARTICLE"."ID_TAXE" = "tAlias__ID_TAXE__TAXE"."ID_TAXE") AND ("tAlias__ID_TAXE__TAXE"."ARCHIVE" = 0)) AND ("tAlias__ID_TAXE__TAXE"."ID_TAXE" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_CREATE__USER_COMMON" on (("ARTICLE"."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 (("ARTICLE"."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"."OpenConcerto49"."ARTICLE_ELEMENT" "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT" on (("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID_ARTICLE_PARENT" = "ARTICLE"."ID") AND ("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID" <> 1)
WHERE ("ARTICLE"."ID" <> 1) AND (("ARTICLE"."ARCHIVE" = 0) AND ("ARTICLE"."OBSOLETE" = false))
ORDER BY "ARTICLE"."ORDRE", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ORDRE"
in jdbc:h2:file:C:\Users\Ponan\AppData\Roaming\OpenConcerto\Data\DBData/OpenConcerto;DATABASE_TO_UPPER=false
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
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 "ARTICLE"."ID", "ARTICLE"."CODE", "ARTICLE"."NOM", "ARTICLE"."PA_HT", "ARTICLE"."PV_HT", "ARTICLE"."ID_TAXE", "ARTICLE"."PV_TTC", "ARTICLE"."ID_FAMILLE_ARTICLE", "ARTICLE"."ID_FOURNISSEUR", "ARTICLE"."SKU", "ARTICLE"."GESTION_STOCK", "ARTICLE"."ID_STOCK", "ARTICLE"."CREATION_DATE", "ARTICLE"."ID_USER_COMMON_CREATE", "ARTICLE"."MODIFICATION_DATE", "ARTICLE"."ID_USER_COMMON_MODIFY", "ARTICLE"."ORDRE", "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID", "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."NOM", "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR", "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."NOM", "tAlias__ID_STOCK__STOCK"."ID", "tAlias__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_STOCK__STOCK"."QTE_MIN", "tAlias__ID_STOCK__STOCK"."QTE_LIV_ATTENTE", "tAlias__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_STOCK__STOCK"."ID_DEPOT_STOCK", "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID", "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."NOM", "tAlias__ID_TAXE__TAXE"."ID_TAXE", "tAlias__ID_TAXE__TAXE"."TAUX", "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_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID_ARTICLE_PARENT", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."QTE"
FROM "OpenConcerto"."OpenConcerto49"."ARTICLE"
LEFT JOIN "OpenConcerto"."OpenConcerto49"."FAMILLE_ARTICLE" "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE" on (("ARTICLE"."ID_FAMILLE_ARTICLE" = "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID") AND ("tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."FOURNISSEUR" "tAlias__ID_FOURNISSEUR__FOURNISSEUR" on (("ARTICLE"."ID_FOURNISSEUR" = "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR") AND ("tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ARCHIVE" = 0)) AND ("tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."STOCK" "tAlias__ID_STOCK__STOCK" on (("ARTICLE"."ID_STOCK" = "tAlias__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_STOCK__STOCK"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."DEPOT_STOCK" "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK" on (("tAlias__ID_STOCK__STOCK"."ID_DEPOT_STOCK" = "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID") AND ("tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."TAXE" "tAlias__ID_TAXE__TAXE" on (("ARTICLE"."ID_TAXE" = "tAlias__ID_TAXE__TAXE"."ID_TAXE") AND ("tAlias__ID_TAXE__TAXE"."ARCHIVE" = 0)) AND ("tAlias__ID_TAXE__TAXE"."ID_TAXE" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_CREATE__USER_COMMON" on (("ARTICLE"."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 (("ARTICLE"."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"."OpenConcerto49"."ARTICLE_ELEMENT" "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT" on (("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID_ARTICLE_PARENT" = "ARTICLE"."ID") AND ("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID" <> 1)
WHERE ("ARTICLE"."ID" <> 1) AND (("ARTICLE"."ARCHIVE" = 0) AND ("ARTICLE"."OBSOLETE" = false))
ORDER BY "ARTICLE"."ORDRE", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ORDRE"
in jdbc:h2:file:C:\Users\Ponan\AppData\Roaming\OpenConcerto\Data\DBData/OpenConcerto;DATABASE_TO_UPPER=false
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:650)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:553)
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.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at org.openconcerto.utils.SleepingQueue$SingleThreadedExecutor.process(SleepingQueue.java:653)
... 2 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SELECT "ARTICLE"."ID", "ARTICLE"."CODE", "ARTICLE"."NOM", "ARTICLE"."PA_HT", "ARTICLE"."PV_HT", "ARTICLE"."ID_TAXE", "ARTICLE"."PV_TTC", "ARTICLE"."ID_FAMILLE_ARTICLE", "ARTICLE"."ID_FOURNISSEUR", "ARTICLE"."SKU", "ARTICLE"."GESTION_STOCK", "ARTICLE"."ID_STOCK", "ARTICLE"."CREATION_DATE", "ARTICLE"."ID_USER_COMMON_CREATE", "ARTICLE"."MODIFICATION_DATE", "ARTICLE"."ID_USER_COMMON_MODIFY", "ARTICLE"."ORDRE", "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID", "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."NOM", "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR", "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."NOM", "tAlias__ID_STOCK__STOCK"."ID", "tAlias__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_STOCK__STOCK"."QTE_MIN", "tAlias__ID_STOCK__STOCK"."QTE_LIV_ATTENTE", "tAlias__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_STOCK__STOCK"."ID_DEPOT_STOCK", "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID", "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."NOM", "tAlias__ID_TAXE__TAXE"."ID_TAXE", "tAlias__ID_TAXE__TAXE"."TAUX", "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_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID_ARTICLE_PARENT", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."QTE"
FROM "OpenConcerto"."OpenConcerto49"."ARTICLE"
LEFT JOIN "OpenConcerto"."OpenConcerto49"."FAMILLE_ARTICLE" "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE" on (("ARTICLE"."ID_FAMILLE_ARTICLE" = "tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID") AND ("tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_FAMILLE_ARTICLE__FAMILLE_ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."FOURNISSEUR" "tAlias__ID_FOURNISSEUR__FOURNISSEUR" on (("ARTICLE"."ID_FOURNISSEUR" = "tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR") AND ("tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ARCHIVE" = 0)) AND ("tAlias__ID_FOURNISSEUR__FOURNISSEUR"."ID_FOURNISSEUR" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."STOCK" "tAlias__ID_STOCK__STOCK" on (("ARTICLE"."ID_STOCK" = "tAlias__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_STOCK__STOCK"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."DEPOT_STOCK" "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK" on (("tAlias__ID_STOCK__STOCK"."ID_DEPOT_STOCK" = "tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID") AND ("tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_STOCK__ID_DEPOT_STOCK__DEPOT_STOCK"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."TAXE" "tAlias__ID_TAXE__TAXE" on (("ARTICLE"."ID_TAXE" = "tAlias__ID_TAXE__TAXE"."ID_TAXE") AND ("tAlias__ID_TAXE__TAXE"."ARCHIVE" = 0)) AND ("tAlias__ID_TAXE__TAXE"."ID_TAXE" <> 1)
LEFT JOIN "OpenConcerto"."Common"."USER_COMMON" "tAlias__ID_USER_COMMON_CREATE__USER_COMMON" on (("ARTICLE"."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 (("ARTICLE"."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"."OpenConcerto49"."ARTICLE_ELEMENT" "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT" on (("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID_ARTICLE_PARENT" = "ARTICLE"."ID") AND ("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."ID" <> 1)
WHERE ("ARTICLE"."ID" <> 1) AND (("ARTICLE"."ARCHIVE" = 0) AND ("ARTICLE"."OBSOLETE" = false))
ORDER BY "ARTICLE"."ORDRE", "tAlias__ID_ARTICLE_PARENT__ARTICLE_ELEMENT"."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:1243)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 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
Répondre