Bonjour,
Juste pour signaler une erreur depuis le passage à la version 1.3 (multi) ;
Au démarrage, j'ai :
Code : Tout sélectionner
UncaughtException on thread Thread[Cache preload,1,main]
unknown field DEFAULT in TAXE. The table TAXE contains the followins fields: [ID_TAXE, NOM, TAUX, ARCHIVE, CODE, ID_COMPTE_PCE, ORDRE, ID_USER_COMMON_MODIFY, MODIFICATION_DATE, ID_USER_COMMON_CREATE, CREATION_DATE, ID_COMPTE_PCE_DED, ID_COMPTE_PCE_COLLECTE]
org.openconcerto.utils.ExceptionHandler: UncaughtException on thread Thread[Cache preload,1,main]
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:112)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:116)
at org.openconcerto.erp.config.Gestion$2.uncaughtException(Gestion.java:194)
at java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1057)
at java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1052)
at java.lang.Thread.dispatchUncaughtException(Thread.java:1985)
Caused by: java.lang.IllegalArgumentException: unknown field DEFAULT in TAXE. The table TAXE contains the followins fields: [ID_TAXE, NOM, TAUX, ARCHIVE, CODE, ID_COMPTE_PCE, ORDRE, ID_USER_COMMON_MODIFY, MODIFICATION_DATE, ID_USER_COMMON_CREATE, CREATION_DATE, ID_COMPTE_PCE_DED, ID_COMPTE_PCE_COLLECTE]
at org.openconcerto.sql.model.SQLTable.getField(SQLTable.java:789)
at org.openconcerto.erp.core.finance.tax.model.TaxeCache.getSel(TaxeCache.java:42)
at org.openconcerto.erp.core.finance.tax.model.TaxeCache.<init>(TaxeCache.java:52)
at org.openconcerto.erp.core.finance.tax.model.TaxeCache.getCache(TaxeCache.java:66)
at org.openconcerto.erp.action.NouvelleConnexionAction$2.run(NouvelleConnexionAction.java:342)
Et la màj de la table me donne :
Code : Tout sélectionner
Echec de mise à jour
Impossible d'accéder au résultat de ALTER TABLE "Default"."REGLEMENT_PAYE" ALTER COLUMN "ID" int DEFAULT (NEXT VALUE FOR "Default".SYSTEM_SEQUENCE_7DC9BE47_28DE_488D_ABD6_1290FB9A399B) NOT NULL SEQUENCE "SYSTEM_SEQUENCE_7DC9BE47_28DE_488D_ABD6_1290FB9A399B";
in jdbc:h2:file:/home/py/.java/ilm/sql-config/OpenConcerto/DBData/OpenConcerto
org.openconcerto.utils.ExceptionHandler: Echec de mise à jour
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:112)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:116)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:307)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de ALTER TABLE "Default"."REGLEMENT_PAYE" ALTER COLUMN "ID" int DEFAULT (NEXT VALUE FOR "Default".SYSTEM_SEQUENCE_7DC9BE47_28DE_488D_ABD6_1290FB9A399B) NOT NULL SEQUENCE "SYSTEM_SEQUENCE_7DC9BE47_28DE_488D_ABD6_1290FB9A399B";
in jdbc:h2:file:/home/py/.java/ilm/sql-config/OpenConcerto/DBData/OpenConcerto
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:554)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:466)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:446)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:375)
at org.openconcerto.sql.changer.convert.ChangeIDToInt.changeImpl(ChangeIDToInt.java:48)
at org.openconcerto.sql.changer.convert.ChangeIDToInt.changeImpl(ChangeIDToInt.java:1)
at org.openconcerto.sql.changer.Changer.changeAll(Changer.java:106)
at org.openconcerto.erp.config.InstallationPanel.updateToV1Dot3(InstallationPanel.java:1155)
at org.openconcerto.erp.config.InstallationPanel.access$10(InstallationPanel.java:944)
at org.openconcerto.erp.config.InstallationPanel$1$1$5.create(InstallationPanel.java:297)
at org.openconcerto.sql.utils.SQLUtils$1.handle(SQLUtils.java:79)
at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:115)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:769)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:96)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:76)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:285)
... 1 more
Caused by: org.h2.jdbc.JdbcSQLException: Sequence "SYSTEM_SEQUENCE_7DC9BE47_28DE_488D_ABD6_1290FB9A399B" not found; SQL statement:
ALTER TABLE "Default"."REGLEMENT_PAYE" ALTER COLUMN "ID" int DEFAULT (NEXT VALUE FOR "Default".SYSTEM_SEQUENCE_7DC9BE47_28DE_488D_ABD6_1290FB9A399B) NOT NULL SEQUENCE "SYSTEM_SEQUENCE_7DC9BE47_28DE_488D_ABD6_1290FB9A399B"; [90036-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.command.Parser.readSequence(Parser.java:5118)
at org.h2.command.Parser.parseColumnForTable(Parser.java:3780)
at org.h2.command.Parser.parseAlterTableAlterColumnType(Parser.java:5260)
at org.h2.command.Parser.parseAlterTable(Parser.java:5253)
at org.h2.command.Parser.parseAlter(Parser.java:4552)
at org.h2.command.Parser.parsePrepared(Parser.java:325)
at org.h2.command.Parser.parse(Parser.java:298)
at org.h2.command.Parser.parse(Parser.java:270)
at org.h2.command.Parser.prepareCommand(Parser.java:235)
at org.h2.engine.Session.prepareLocal(Session.java:436)
at org.h2.engine.Session.prepareCommand(Session.java:379)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:124)
at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:777)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:323)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:929)
at org.openconcerto.sql.model.SQLDataSource.executeOnce(SQLDataSource.java:854)
at org.openconcerto.sql.model.SQLDataSource.executeTwice(SQLDataSource.java:823)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:522)
... 17 more
Deux erreurs que je n'ai jamais rencontrées dans les versions précédentes... Et empêche de modifier tout ce qui a trait à la TVA

.. Une idée ?
Sinon, vraiment beau travail !