bug configuration logiciel
Posté : mar. juil. 02, 2019 2:08 pm
Bonjour,
Je suis débutante avec OPENCONCERTO et depuis 1 semaine j'ai des messages d'erreurs qui apparaissent quelque soit la manipulation.
Exemples :
- le numéro de facture client reste bloqué sur le même chiffre
- impossible de mettre à jour les stock manuellement
- émission de la facture client ne fait pas bougé les stock
Voilà le message :
Update error
Impossible d'accéder au résultat de SELECT "MOUVEMENT_STOCK"."ID", "MOUVEMENT_STOCK"."QTE", "MOUVEMENT_STOCK"."REEL", "MOUVEMENT_STOCK"."ID_ARTICLE", "tAlias__ID_ARTICLE__ARTICLE"."ID", "tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_LIV_ATTENTE"
FROM "OpenConcerto"."OpenConcerto42"."MOUVEMENT_STOCK"
LEFT JOIN "OpenConcerto"."OpenConcerto42"."ARTICLE" "tAlias__ID_ARTICLE__ARTICLE" on (("MOUVEMENT_STOCK"."ID_ARTICLE" = "tAlias__ID_ARTICLE__ARTICLE"."ID") AND ("tAlias__ID_ARTICLE__ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto42"."STOCK" "tAlias__ID_ARTICLE__ID_STOCK__STOCK" on (("tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK" = "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID" <> 1)
WHERE ("MOUVEMENT_STOCK"."ID" <> 1) AND (("MOUVEMENT_STOCK"."ARCHIVE" = 0) AND (("MOUVEMENT_STOCK"."SOURCE" = 'BON_RECEPTION') AND ("MOUVEMENT_STOCK"."IDSOURCE" = 29)))
ORDER BY "MOUVEMENT_STOCK"."ORDRE"
in jdbc:h2:file:C:\Users\AFR Conseils\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto
org.openconcerto.utils.ExceptionHandler: Update error
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:125)
at org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent$5.run(BonReceptionSQLComponent.java:406)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT "MOUVEMENT_STOCK"."ID", "MOUVEMENT_STOCK"."QTE", "MOUVEMENT_STOCK"."REEL", "MOUVEMENT_STOCK"."ID_ARTICLE", "tAlias__ID_ARTICLE__ARTICLE"."ID", "tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_LIV_ATTENTE"
FROM "OpenConcerto"."OpenConcerto42"."MOUVEMENT_STOCK"
LEFT JOIN "OpenConcerto"."OpenConcerto42"."ARTICLE" "tAlias__ID_ARTICLE__ARTICLE" on (("MOUVEMENT_STOCK"."ID_ARTICLE" = "tAlias__ID_ARTICLE__ARTICLE"."ID") AND ("tAlias__ID_ARTICLE__ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto42"."STOCK" "tAlias__ID_ARTICLE__ID_STOCK__STOCK" on (("tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK" = "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID" <> 1)
WHERE ("MOUVEMENT_STOCK"."ID" <> 1) AND (("MOUVEMENT_STOCK"."ARCHIVE" = 0) AND (("MOUVEMENT_STOCK"."SOURCE" = 'BON_RECEPTION') AND ("MOUVEMENT_STOCK"."IDSOURCE" = 29)))
ORDER BY "MOUVEMENT_STOCK"."ORDRE"
in jdbc:h2:file:C:\Users\AFR Conseils\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:640)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:545)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1217)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1150)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1132)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1091)
at org.openconcerto.erp.core.supplychain.stock.element.StockItemsUpdater.clearExistingMvt(StockItemsUpdater.java:224)
at org.openconcerto.erp.core.supplychain.stock.element.StockItemsUpdater.update(StockItemsUpdater.java:118)
at org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent.updateStock(BonReceptionSQLComponent.java:597)
at org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent.access$3(BonReceptionSQLComponent.java:577)
at org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent$5.run(BonReceptionSQLComponent.java:404)
... 3 more
Caused by: java.sql.SQLException: second exec failed: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SELECT "MOUVEMENT_STOCK"."ID", "MOUVEMENT_STOCK"."QTE", "MOUVEMENT_STOCK"."REEL", "MOUVEMENT_STOCK"."ID_ARTICLE", "tAlias__ID_ARTICLE__ARTICLE"."ID", "tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_LIV_ATTENTE"
FROM "OpenConcerto"."OpenConcerto42"."MOUVEMENT_STOCK"
LEFT JOIN "OpenConcerto"."OpenConcerto42"."ARTICLE" "tAlias__ID_ARTICLE__ARTICLE" on (("MOUVEMENT_STOCK"."ID_ARTICLE" = "tAlias__ID_ARTICLE__ARTICLE"."ID") AND ("tAlias__ID_ARTICLE__ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto42"."STOCK" "tAlias__ID_ARTICLE__ID_STOCK__STOCK" on (("tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK" = "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID" <> 1)
WHERE ("MOUVEMENT_STOCK"."ID" <> 1) AND (("MOUVEMENT_STOCK"."ARCHIVE" = 0) AND (("MOUVEMENT_STOCK"."SOURCE" = 'BON_RECEPTION') AND ("MOUVEMENT_STOCK"."IDSOURCE" = 29)))
ORDER BY "MOUVEMENT_STOCK"."ORDRE" [50000-175]
at org.openconcerto.sql.model.SQLDataSource.executeTwice(SQLDataSource.java:965)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:608)
... 13 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SELECT "MOUVEMENT_STOCK"."ID", "MOUVEMENT_STOCK"."QTE", "MOUVEMENT_STOCK"."REEL", "MOUVEMENT_STOCK"."ID_ARTICLE", "tAlias__ID_ARTICLE__ARTICLE"."ID", "tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_LIV_ATTENTE"
FROM "OpenConcerto"."OpenConcerto42"."MOUVEMENT_STOCK"
LEFT JOIN "OpenConcerto"."OpenConcerto42"."ARTICLE" "tAlias__ID_ARTICLE__ARTICLE" on (("MOUVEMENT_STOCK"."ID_ARTICLE" = "tAlias__ID_ARTICLE__ARTICLE"."ID") AND ("tAlias__ID_ARTICLE__ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto42"."STOCK" "tAlias__ID_ARTICLE__ID_STOCK__STOCK" on (("tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK" = "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID" <> 1)
WHERE ("MOUVEMENT_STOCK"."ID" <> 1) AND (("MOUVEMENT_STOCK"."ARCHIVE" = 0) AND (("MOUVEMENT_STOCK"."SOURCE" = 'BON_RECEPTION') AND ("MOUVEMENT_STOCK"."IDSOURCE" = 29)))
ORDER BY "MOUVEMENT_STOCK"."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:1157)
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
Merci d'avance pour votre aide
Je suis débutante avec OPENCONCERTO et depuis 1 semaine j'ai des messages d'erreurs qui apparaissent quelque soit la manipulation.
Exemples :
- le numéro de facture client reste bloqué sur le même chiffre
- impossible de mettre à jour les stock manuellement
- émission de la facture client ne fait pas bougé les stock
Voilà le message :
Update error
Impossible d'accéder au résultat de SELECT "MOUVEMENT_STOCK"."ID", "MOUVEMENT_STOCK"."QTE", "MOUVEMENT_STOCK"."REEL", "MOUVEMENT_STOCK"."ID_ARTICLE", "tAlias__ID_ARTICLE__ARTICLE"."ID", "tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_LIV_ATTENTE"
FROM "OpenConcerto"."OpenConcerto42"."MOUVEMENT_STOCK"
LEFT JOIN "OpenConcerto"."OpenConcerto42"."ARTICLE" "tAlias__ID_ARTICLE__ARTICLE" on (("MOUVEMENT_STOCK"."ID_ARTICLE" = "tAlias__ID_ARTICLE__ARTICLE"."ID") AND ("tAlias__ID_ARTICLE__ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto42"."STOCK" "tAlias__ID_ARTICLE__ID_STOCK__STOCK" on (("tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK" = "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID" <> 1)
WHERE ("MOUVEMENT_STOCK"."ID" <> 1) AND (("MOUVEMENT_STOCK"."ARCHIVE" = 0) AND (("MOUVEMENT_STOCK"."SOURCE" = 'BON_RECEPTION') AND ("MOUVEMENT_STOCK"."IDSOURCE" = 29)))
ORDER BY "MOUVEMENT_STOCK"."ORDRE"
in jdbc:h2:file:C:\Users\AFR Conseils\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto
org.openconcerto.utils.ExceptionHandler: Update error
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:125)
at org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent$5.run(BonReceptionSQLComponent.java:406)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de SELECT "MOUVEMENT_STOCK"."ID", "MOUVEMENT_STOCK"."QTE", "MOUVEMENT_STOCK"."REEL", "MOUVEMENT_STOCK"."ID_ARTICLE", "tAlias__ID_ARTICLE__ARTICLE"."ID", "tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_LIV_ATTENTE"
FROM "OpenConcerto"."OpenConcerto42"."MOUVEMENT_STOCK"
LEFT JOIN "OpenConcerto"."OpenConcerto42"."ARTICLE" "tAlias__ID_ARTICLE__ARTICLE" on (("MOUVEMENT_STOCK"."ID_ARTICLE" = "tAlias__ID_ARTICLE__ARTICLE"."ID") AND ("tAlias__ID_ARTICLE__ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto42"."STOCK" "tAlias__ID_ARTICLE__ID_STOCK__STOCK" on (("tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK" = "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID" <> 1)
WHERE ("MOUVEMENT_STOCK"."ID" <> 1) AND (("MOUVEMENT_STOCK"."ARCHIVE" = 0) AND (("MOUVEMENT_STOCK"."SOURCE" = 'BON_RECEPTION') AND ("MOUVEMENT_STOCK"."IDSOURCE" = 29)))
ORDER BY "MOUVEMENT_STOCK"."ORDRE"
in jdbc:h2:file:C:\Users\AFR Conseils\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:640)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:545)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1217)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1150)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1132)
at org.openconcerto.sql.model.SQLRowValuesListFetcher.fetch(SQLRowValuesListFetcher.java:1091)
at org.openconcerto.erp.core.supplychain.stock.element.StockItemsUpdater.clearExistingMvt(StockItemsUpdater.java:224)
at org.openconcerto.erp.core.supplychain.stock.element.StockItemsUpdater.update(StockItemsUpdater.java:118)
at org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent.updateStock(BonReceptionSQLComponent.java:597)
at org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent.access$3(BonReceptionSQLComponent.java:577)
at org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent$5.run(BonReceptionSQLComponent.java:404)
... 3 more
Caused by: java.sql.SQLException: second exec failed: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SELECT "MOUVEMENT_STOCK"."ID", "MOUVEMENT_STOCK"."QTE", "MOUVEMENT_STOCK"."REEL", "MOUVEMENT_STOCK"."ID_ARTICLE", "tAlias__ID_ARTICLE__ARTICLE"."ID", "tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_LIV_ATTENTE"
FROM "OpenConcerto"."OpenConcerto42"."MOUVEMENT_STOCK"
LEFT JOIN "OpenConcerto"."OpenConcerto42"."ARTICLE" "tAlias__ID_ARTICLE__ARTICLE" on (("MOUVEMENT_STOCK"."ID_ARTICLE" = "tAlias__ID_ARTICLE__ARTICLE"."ID") AND ("tAlias__ID_ARTICLE__ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto42"."STOCK" "tAlias__ID_ARTICLE__ID_STOCK__STOCK" on (("tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK" = "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID" <> 1)
WHERE ("MOUVEMENT_STOCK"."ID" <> 1) AND (("MOUVEMENT_STOCK"."ARCHIVE" = 0) AND (("MOUVEMENT_STOCK"."SOURCE" = 'BON_RECEPTION') AND ("MOUVEMENT_STOCK"."IDSOURCE" = 29)))
ORDER BY "MOUVEMENT_STOCK"."ORDRE" [50000-175]
at org.openconcerto.sql.model.SQLDataSource.executeTwice(SQLDataSource.java:965)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:608)
... 13 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SELECT "MOUVEMENT_STOCK"."ID", "MOUVEMENT_STOCK"."QTE", "MOUVEMENT_STOCK"."REEL", "MOUVEMENT_STOCK"."ID_ARTICLE", "tAlias__ID_ARTICLE__ARTICLE"."ID", "tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_REEL", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_TH", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_RECEPT_ATTENTE", "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."QTE_LIV_ATTENTE"
FROM "OpenConcerto"."OpenConcerto42"."MOUVEMENT_STOCK"
LEFT JOIN "OpenConcerto"."OpenConcerto42"."ARTICLE" "tAlias__ID_ARTICLE__ARTICLE" on (("MOUVEMENT_STOCK"."ID_ARTICLE" = "tAlias__ID_ARTICLE__ARTICLE"."ID") AND ("tAlias__ID_ARTICLE__ARTICLE"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto42"."STOCK" "tAlias__ID_ARTICLE__ID_STOCK__STOCK" on (("tAlias__ID_ARTICLE__ARTICLE"."ID_STOCK" = "tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID") AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ARCHIVE" = 0)) AND ("tAlias__ID_ARTICLE__ID_STOCK__STOCK"."ID" <> 1)
WHERE ("MOUVEMENT_STOCK"."ID" <> 1) AND (("MOUVEMENT_STOCK"."ARCHIVE" = 0) AND (("MOUVEMENT_STOCK"."SOURCE" = 'BON_RECEPTION') AND ("MOUVEMENT_STOCK"."IDSOURCE" = 29)))
ORDER BY "MOUVEMENT_STOCK"."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:1157)
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
Merci d'avance pour votre aide
