Bonjour,
J'ai installé OpenConcerto sur mon mac, puis récupéré la sauvegarde de windows.
Base H2.
J'avais également installé un serveur postgre, et créé une base avec.
J'ai changé la configuration de connexion pour attaquer la base H2.
J'ai réussi à me connecter sans soucis, mais après plusieurs tests, j'ai voulu remettre la sauvegarde de la base H2.
Et depuis, après la connexion du user, j'ai le message d'erreur qui suit.
J'ai essayé d'aller dans les préférences OP, sans problème et sans erreurs d'enregistrement.
Merci de m'indiquer les sources de mon erreur.
Cordialement,
Stéphanie
MESSAGE D'ERREUR :
----------------------------------------------------------------------------
Impossible d'accéder aux préférences
java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'accéder au résultat de CREATE TABLE "OpenConcerto49"."PREF_NODE" (
"ID" integer DEFAULT (NEXT VALUE FOR "OpenConcerto49".SYSTEM_SEQUENCE_B34FE968_28CC_49AE_87BE_CC664FFBCDA7) NOT NULL ,
"ID_PARENT" integer ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_NODE" IS '';
CREATE TABLE "OpenConcerto49"."PREF_VALUE" (
"ID_NODE" integer NOT NULL ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
"VALUE" varchar(8192) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID_NODE","NAME")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_VALUE" IS '';
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_uniqNamePerParent" UNIQUE ("ID_PARENT", "NAME");
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_ID_PARENT_fkey" FOREIGN KEY ( "ID_PARENT" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE "OpenConcerto49"."PREF_VALUE" ADD CONSTRAINT "PREF_VALUE_ID_NODE_fkey" FOREIGN KEY ( "ID_NODE" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT;
in jdbc:h2:mem:
org.openconcerto.utils.ExceptionHandler: Impossible d'accéder aux préférences
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:99)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:103)
at org.openconcerto.erp.action.NouvelleConnexionAction$1.run(NouvelleConnexionAction.java:139)
at org.openconcerto.sql.ui.ConnexionPanel.connect(ConnexionPanel.java:475)
at org.openconcerto.sql.ui.ConnexionPanel.access$4(ConnexionPanel.java:448)
at org.openconcerto.sql.ui.ConnexionPanel$7.run(ConnexionPanel.java:403)
at java.lang.Thread.run(Thread.java:695)
Caused by: java.sql.SQLException: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'accéder au résultat de CREATE TABLE "OpenConcerto49"."PREF_NODE" (
"ID" integer DEFAULT (NEXT VALUE FOR "OpenConcerto49".SYSTEM_SEQUENCE_B34FE968_28CC_49AE_87BE_CC664FFBCDA7) NOT NULL ,
"ID_PARENT" integer ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_NODE" IS '';
CREATE TABLE "OpenConcerto49"."PREF_VALUE" (
"ID_NODE" integer NOT NULL ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
"VALUE" varchar(8192) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID_NODE","NAME")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_VALUE" IS '';
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_uniqNamePerParent" UNIQUE ("ID_PARENT", "NAME");
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_ID_PARENT_fkey" FOREIGN KEY ( "ID_PARENT" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE "OpenConcerto49"."PREF_VALUE" ADD CONSTRAINT "PREF_VALUE_ID_NODE_fkey" FOREIGN KEY ( "ID_NODE" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT;
in jdbc:h2:mem:
at org.openconcerto.sql.preferences.SQLPreferences.startMemCached(SQLPreferences.java:123)
at org.openconcerto.sql.preferences.SQLPreferences.startMemCached(SQLPreferences.java:111)
at org.openconcerto.erp.action.NouvelleConnexionAction$1.run(NouvelleConnexionAction.java:136)
... 4 more
Caused by: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'accéder au résultat de CREATE TABLE "OpenConcerto49"."PREF_NODE" (
"ID" integer DEFAULT (NEXT VALUE FOR "OpenConcerto49".SYSTEM_SEQUENCE_B34FE968_28CC_49AE_87BE_CC664FFBCDA7) NOT NULL ,
"ID_PARENT" integer ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_NODE" IS '';
CREATE TABLE "OpenConcerto49"."PREF_VALUE" (
"ID_NODE" integer NOT NULL ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
"VALUE" varchar(8192) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID_NODE","NAME")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_VALUE" IS '';
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_uniqNamePerParent" UNIQUE ("ID_PARENT", "NAME");
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_ID_PARENT_fkey" FOREIGN KEY ( "ID_PARENT" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE "OpenConcerto49"."PREF_VALUE" ADD CONSTRAINT "PREF_VALUE_ID_NODE_fkey" FOREIGN KEY ( "ID_NODE" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT;
in jdbc:h2:mem:
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
at java.util.concurrent.FutureTask.get(FutureTask.java:83)
at org.openconcerto.sql.replication.MemoryRep.start(MemoryRep.java:164)
at org.openconcerto.sql.preferences.SQLPreferences.startMemCached(SQLPreferences.java:119)
... 6 more
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de CREATE TABLE "OpenConcerto49"."PREF_NODE" (
"ID" integer DEFAULT (NEXT VALUE FOR "OpenConcerto49".SYSTEM_SEQUENCE_B34FE968_28CC_49AE_87BE_CC664FFBCDA7) NOT NULL ,
"ID_PARENT" integer ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_NODE" IS '';
CREATE TABLE "OpenConcerto49"."PREF_VALUE" (
"ID_NODE" integer NOT NULL ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
"VALUE" varchar(8192) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID_NODE","NAME")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_VALUE" IS '';
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_uniqNamePerParent" UNIQUE ("ID_PARENT", "NAME");
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_ID_PARENT_fkey" FOREIGN KEY ( "ID_PARENT" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE "OpenConcerto49"."PREF_VALUE" ADD CONSTRAINT "PREF_VALUE_ID_NODE_fkey" FOREIGN KEY ( "ID_NODE" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT;
in jdbc:h2:mem:
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:540)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:452)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:432)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:361)
at org.openconcerto.sql.replication.MemoryRep.replicateStruct(MemoryRep.java:346)
at org.openconcerto.sql.replication.MemoryRep$3.call(MemoryRep.java:161)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
... 1 more
Caused by: java.sql.SQLException: second exec failed: Impossible d'accéder au résultat de SET SCHEMA "OpenConcerto49"
in jdbc:h2:mem:
at org.openconcerto.sql.model.SQLDataSource.executeTwice(SQLDataSource.java:830)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:508)
... 12 more
Caused by: org.h2.jdbc.JdbcSQLException: Sequence "SYSTEM_SEQUENCE_B34FE968_28CC_49AE_87BE_CC664FFBCDA7" not found; SQL statement:
CREATE TABLE "OpenConcerto49"."PREF_NODE" (
"ID" integer DEFAULT (NEXT VALUE FOR "OpenConcerto49".SYSTEM_SEQUENCE_B34FE968_28CC_49AE_87BE_CC664FFBCDA7) NOT NULL ,
"ID_PARENT" integer ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_NODE" IS '';
CREATE TABLE "OpenConcerto49"."PREF_VALUE" (
"ID_NODE" integer NOT NULL ,
"NAME" varchar(80) DEFAULT '' NOT NULL ,
"VALUE" varchar(8192) DEFAULT '' NOT NULL ,
PRIMARY KEY ("ID_NODE","NAME")) ;
COMMENT ON TABLE "OpenConcerto49"."PREF_VALUE" IS '';
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_uniqNamePerParent" UNIQUE ("ID_PARENT", "NAME");
ALTER TABLE "OpenConcerto49"."PREF_NODE" ADD CONSTRAINT "PREF_NODE_ID_PARENT_fkey" FOREIGN KEY ( "ID_PARENT" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE "OpenConcerto49"."PREF_VALUE" ADD CONSTRAINT "PREF_VALUE_ID_NODE_fkey" FOREIGN KEY ( "ID_NODE" ) REFERENCES "OpenConcerto49"."PREF_NODE" ( "ID" ) ON UPDATE RESTRICT ON DELETE RESTRICT; [90036-168]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.schema.Schema.getSequence(Schema.java:474)
at org.h2.command.Parser.readSequence(Parser.java:4811)
at org.h2.command.Parser.readTerm(Parser.java:2491)
at org.h2.command.Parser.readFactor(Parser.java:2046)
at org.h2.command.Parser.readSum(Parser.java:2033)
at org.h2.command.Parser.readConcat(Parser.java:2006)
at org.h2.command.Parser.readCondition(Parser.java:1871)
at org.h2.command.Parser.readAnd(Parser.java:1852)
at org.h2.command.Parser.readExpression(Parser.java:1844)
at org.h2.command.Parser.readTerm(Parser.java:2558)
at org.h2.command.Parser.readFactor(Parser.java:2046)
at org.h2.command.Parser.readSum(Parser.java:2033)
at org.h2.command.Parser.readConcat(Parser.java:2006)
at org.h2.command.Parser.readCondition(Parser.java:1871)
at org.h2.command.Parser.readAnd(Parser.java:1852)
at org.h2.command.Parser.readExpression(Parser.java:1844)
at org.h2.command.Parser.parseColumnForTable(Parser.java:3535)
at org.h2.command.Parser.parseCreateTable(Parser.java:5208)
at org.h2.command.Parser.parseCreate(Parser.java:3806)
at org.h2.command.Parser.parsePrepared(Parser.java:324)
at org.h2.command.Parser.parse(Parser.java:279)
at org.h2.command.Parser.parse(Parser.java:251)
at org.h2.command.Parser.prepareCommand(Parser.java:217)
at org.h2.engine.Session.prepareLocal(Session.java:415)
at org.h2.engine.Session.prepareCommand(Session.java:364)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:164)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.openconcerto.sql.model.SQLDataSource$ExecutorThread.run(SQLDataSource.java:974)
