erreur lancement logiciel de caisse
Posté : 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.
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