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
bug configuration logiciel
Bonjour,
Il y a un problème sur votre fichier de base de données, généralement causé par une coupure du PC lors de l'utilisation d'OpenConcerto.
Restaurez depuis une sauvegarde ou contacter ILM pour réparation du fichier.
Cordialement,
Il y a un problème sur votre fichier de base de données, généralement causé par une coupure du PC lors de l'utilisation d'OpenConcerto.
Restaurez depuis une sauvegarde ou contacter ILM pour réparation du fichier.
Cordialement,