Bonjour
J'ai l'erreur suivante lors d'un test de migration de 1.3b4 vers 1.3
Cordialement.
Echec de mise à jour
Impossible d'accéder au résultat de ALTER TABLE "Default"."IDCC" ALTER COLUMN "ID" int DEFAULT (NEXT VALUE FOR "Default".SYSTEM_SEQUENCE_EED6A562_14AD_4382_AF80_3E64F4E801EF) NOT NULL SEQUENCE "SYSTEM_SEQUENCE_EED6A562_14AD_4382_AF80_3E64F4E801EF";
in jdbc:h2:file:C:\Users\Minh\.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(Unknown Source)
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de ALTER TABLE "Default"."IDCC" ALTER COLUMN "ID" int DEFAULT (NEXT VALUE FOR "Default".SYSTEM_SEQUENCE_EED6A562_14AD_4382_AF80_3E64F4E801EF) NOT NULL SEQUENCE "SYSTEM_SEQUENCE_EED6A562_14AD_4382_AF80_3E64F4E801EF";
in jdbc:h2:file:C:\Users\Minh\.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_EED6A562_14AD_4382_AF80_3E64F4E801EF" not found; SQL statement:
ALTER TABLE "Default"."IDCC" ALTER COLUMN "ID" int DEFAULT (NEXT VALUE FOR "Default".SYSTEM_SEQUENCE_EED6A562_14AD_4382_AF80_3E64F4E801EF) NOT NULL SEQUENCE "SYSTEM_SEQUENCE_EED6A562_14AD_4382_AF80_3E64F4E801EF"; [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
