lun. juil. 15, 2019 5:06 pm
J'ai lancé mise à jour 1.5.1 => résultat ok
J'ai lancé mise à jour 1.5.2 => résultat ok
J'ai lancé mise à jour 1.5.3 => résultat ok
J'ai lancé mise à jour 1.5.4 => même erreur que précédemmment
J'ai ajouté une ligne puis lancé mise à jour 1.5.4 => résultat ko
Echec de mise à jour
could not restore state after successful setup : java.sql.SQLException: Couldn't rollback save point
at org.openconcerto.sql.utils.SQLUtils$2.restoreState(SQLUtils.java:184)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:900)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:127)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:99)
at org.openconcerto.sql.model.DBRoot.createTables(DBRoot.java:149)
at org.openconcerto.sql.model.DBRoot.createTables(DBRoot.java:126)
at org.openconcerto.sql.model.DBRoot.createTables(DBRoot.java:122)
at org.openconcerto.erp.config.update.Updater_1_5.update(Updater_1_5.java:1120)
at org.openconcerto.erp.config.InstallationPanel$11.create(InstallationPanel.java:4365)
at org.openconcerto.sql.utils.SQLUtils$1.handle(SQLUtils.java:82)
at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:149)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:883)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:127)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:99)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:79)
at org.openconcerto.erp.config.InstallationPanel.updateDatabase(InstallationPanel.java:4341)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:141)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:767)
at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:1636)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:458)
at org.openconcerto.sql.model.SQLDataSource$TransactionPoolableConnection.rollback(SQLDataSource.java:1564)
at org.openconcerto.sql.utils.SQLUtils$2.restoreState(SQLUtils.java:167)
... 20 more
org.openconcerto.utils.ExceptionHandler: Echec de mise à jour
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:129)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:134)
at org.openconcerto.erp.config.InstallationPanel.updateDatabase(InstallationPanel.java:4406)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:141)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: could not restore state after successful setup : java.sql.SQLException: Couldn't rollback save point
at org.openconcerto.sql.utils.SQLUtils$2.restoreState(SQLUtils.java:184)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:900)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:127)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:99)
at org.openconcerto.sql.model.DBRoot.createTables(DBRoot.java:149)
at org.openconcerto.sql.model.DBRoot.createTables(DBRoot.java:126)
at org.openconcerto.sql.model.DBRoot.createTables(DBRoot.java:122)
at org.openconcerto.erp.config.update.Updater_1_5.update(Updater_1_5.java:1120)
at org.openconcerto.erp.config.InstallationPanel$11.create(InstallationPanel.java:4365)
at org.openconcerto.sql.utils.SQLUtils$1.handle(SQLUtils.java:82)
at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:149)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:883)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:127)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:99)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:79)
at org.openconcerto.erp.config.InstallationPanel.updateDatabase(InstallationPanel.java:4341)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:141)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:767)
at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:1636)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:458)
at org.openconcerto.sql.model.SQLDataSource$TransactionPoolableConnection.rollback(SQLDataSource.java:1564)
at org.openconcerto.sql.utils.SQLUtils$2.restoreState(SQLUtils.java:167)
... 20 more
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:936)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:127)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:99)
at org.openconcerto.sql.model.DBRoot.createTables(DBRoot.java:149)
at org.openconcerto.sql.model.DBRoot.createTables(DBRoot.java:126)
at org.openconcerto.sql.model.DBRoot.createTables(DBRoot.java:122)
at org.openconcerto.erp.config.update.Updater_1_5.update(Updater_1_5.java:1120)
at org.openconcerto.erp.config.InstallationPanel$11.create(InstallationPanel.java:4365)
at org.openconcerto.sql.utils.SQLUtils$1.handle(SQLUtils.java:82)
at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:149)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:883)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:127)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:99)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:79)
at org.openconcerto.erp.config.InstallationPanel.updateDatabase(InstallationPanel.java:4341)
... 2 more
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de CREATE TABLE "OpenConcerto48"."SEPA_DIRECT_DEBIT_MESSAGE" (
"ID" serial PRIMARY KEY,
"MessageIdentification" varchar(35) DEFAULT '' NOT NULL ,
"CreationDateTime" timestamp NOT NULL ,
"NumberOfTransactions" integer DEFAULT 0 NOT NULL ,
"ControlSum" DECIMAL(16,6) DEFAULT 0 NOT NULL ,
"XML" varchar NOT NULL ,
"ARCHIVE" int DEFAULT 0 NOT NULL,
"ORDRE" DECIMAL(16,8) ) ;
in jdbc:postgresql://192.168.1.2:5432/OpenConcerto
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:646)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:554)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:534)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:463)
at org.openconcerto.sql.model.DBRoot$1.handle(DBRoot.java:155)
at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:149)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:883)
... 19 more
Caused by: org.postgresql.util.PSQLException: Une erreur d'entrée/sortie a eu lieu lors d'envoi vers le serveur.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:332)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:1134)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:323)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:1103)
at org.openconcerto.sql.model.SQLDataSource.executeOnce(SQLDataSource.java:1027)
at org.openconcerto.sql.model.SQLDataSource.executeTwice(SQLDataSource.java:950)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:613)
... 26 more
Caused by: java.io.IOException: Séquence UTF-8 illégale: l'octet 2 de la séquence d'octet 3 n'est pas 10xxxxxx: 101
at org.postgresql.core.UTF8Encoding.checkByte(UTF8Encoding.java:27)
at org.postgresql.core.UTF8Encoding.decode(UTF8Encoding.java:113)
at org.postgresql.core.PGStream.receiveString(PGStream.java:341)
at org.postgresql.core.v3.QueryExecutorImpl.receiveNoticeResponse(QueryExecutorImpl.java:2444)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2208)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
... 38 more
Version OC 1.7.1 multiposte / Postgresql 9.5 / Windows serveur 2019
Utilisateur OC depuis janvier 2012