Bonjour,
heureux de voir une nouvelle version arrivé.
de ce faite je le télécharge et je le lance
et voila le résultat:
"Erreur de connexion à la base de données
org.h2.jdbc.JdbcSQLException: Table "FWK_SCHEMA_METADATA" already exists; SQL statement:
CREATE TABLE "Common"."FWK_SCHEMA_METADATA" (
"NAME" varchar(100) default '' NOT NULL,
"VALUE" varchar(250) default '' NOT NULL,
PRIMARY KEY ("NAME")) ;
INSERT INTO "Common"."FWK_SCHEMA_METADATA"("NAME", "VALUE") VALUES ('VERSION', FORMATDATETIME(CURRENT_TIMESTAMP, 'yyyyMMdd''T''HHmmss.SSS000')) [42101-175]
org.openconcerto.utils.ExceptionHandler: Erreur de connexion à la base de données
at org.openconcerto.utils.ExceptionHandler.die(ExceptionHandler.java:132)
at org.openconcerto.erp.config.Gestion.main(Gestion.java:331)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at apple.launcher.LaunchRunner.run(LaunchRunner.java:116)
at apple.launcher.LaunchRunner.callMain(LaunchRunner.java:51)
at apple.launcher.JavaApplicationLauncher.launch(JavaApplicationLauncher.java:52)
Caused by: org.openconcerto.sql.model.StructureSource$PrechangeException: org.h2.jdbc.JdbcSQLException: Table "FWK_SCHEMA_METADATA" already exists; SQL statement:
CREATE TABLE "Common"."FWK_SCHEMA_METADATA" (
"NAME" varchar(100) default '' NOT NULL,
"VALUE" varchar(250) default '' NOT NULL,
PRIMARY KEY ("NAME")) ;
INSERT INTO "Common"."FWK_SCHEMA_METADATA"("NAME", "VALUE") VALUES ('VERSION', FORMATDATETIME(CURRENT_TIMESTAMP, 'yyyyMMdd''T''HHmmss.SSS000')) [42101-175]
at org.openconcerto.sql.model.StructureSource.init(StructureSource.java:134)
at org.openconcerto.sql.model.SQLBase.refreshTables(SQLBase.java:276)
at org.openconcerto.sql.model.SQLBase.fetchTablesP(SQLBase.java:252)
at org.openconcerto.sql.model.SQLBase.loadTables(SQLBase.java:207)
at org.openconcerto.sql.model.SQLBase.refresh(SQLBase.java:168)
at org.openconcerto.sql.model.SQLBase.init(SQLBase.java:147)
at org.openconcerto.sql.model.SQLServer.putBase(SQLServer.java:494)
at org.openconcerto.sql.model.SQLServer.createBase(SQLServer.java:422)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:409)
at org.openconcerto.sql.model.SQLServer.createSystemRoot(SQLServer.java:468)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:446)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:426)
at org.openconcerto.sql.PropsConfiguration.createSystemRoot(PropsConfiguration.java:682)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createSystemRoot(ComptaPropsConfiguration.java:665)
at org.openconcerto.sql.PropsConfiguration.getSystemRoot(PropsConfiguration.java:1096)
at org.openconcerto.erp.config.Gestion.main(Gestion.java:301)
... 7 more
Caused by: org.h2.jdbc.JdbcSQLException: Table "FWK_SCHEMA_METADATA" already exists; SQL statement:
CREATE TABLE "Common"."FWK_SCHEMA_METADATA" (
"NAME" varchar(100) default '' NOT NULL,
"VALUE" varchar(250) default '' NOT NULL,
PRIMARY KEY ("NAME")) ;
INSERT INTO "Common"."FWK_SCHEMA_METADATA"("NAME", "VALUE") VALUES ('VERSION', FORMATDATETIME(CURRENT_TIMESTAMP, 'yyyyMMdd''T''HHmmss.SSS000')) [42101-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.ddl.CreateTable.update(CreateTable.java:109)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.command.CommandList.update(CommandList.java:43)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.openconcerto.sql.model.JDBCStructureSource.getNames(JDBCStructureSource.java:133)
at org.openconcerto.sql.model.StructureSource$1$1.run(StructureSource.java:118)
at java.security.AccessController.doPrivileged(Native Method)
at org.openconcerto.sql.model.StructureSource$1.handle(StructureSource.java:115)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:844)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:812)
at org.openconcerto.sql.model.StructureSource.init(StructureSource.java:111)
... 22 more
"
Le pire pas de possibilité de réutilisé l'ancien
je suis dans la merde ....
si quelqu'un peux m'aider
Mise à jour de 1,3 vers 1,4 ERREUR (RESOLU)
Bonjour,
Normalement il faut faire une mise à niveau de la base avec le programme OpenConcerto-Configuration, onglet Installation.
Sinon pour revenir en arrière et si vous avez ecrasé le repertoire 1.3 , il suffit de re-telecharger cette version.
Normalement il faut faire une mise à niveau de la base avec le programme OpenConcerto-Configuration, onglet Installation.
Sinon pour revenir en arrière et si vous avez ecrasé le repertoire 1.3 , il suffit de re-telecharger cette version.
Utilisateur OC 1.5 multiposte Postgresql Linux
RE
quand je fais une mise à jour voila ce qu'il me dis
" Echec de mise à jour
org.h2.jdbc.JdbcSQLException: Table "FWK_SCHEMA_METADATA" already exists; SQL statement:
CREATE TABLE "Common"."FWK_SCHEMA_METADATA" (
"NAME" varchar(100) default '' NOT NULL,
"VALUE" varchar(250) default '' NOT NULL,
PRIMARY KEY ("NAME")) ;
INSERT INTO "Common"."FWK_SCHEMA_METADATA"("NAME", "VALUE") VALUES ('VERSION', FORMATDATETIME(CURRENT_TIMESTAMP, 'yyyyMMdd''T''HHmmss.SSS000')) [42101-175]
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:351)
at java.lang.Thread.run(Thread.java:695)
Caused by: org.openconcerto.sql.model.StructureSource$PrechangeException: org.h2.jdbc.JdbcSQLException: Table "FWK_SCHEMA_METADATA" already exists; SQL statement:
CREATE TABLE "Common"."FWK_SCHEMA_METADATA" (
"NAME" varchar(100) default '' NOT NULL,
"VALUE" varchar(250) default '' NOT NULL,
PRIMARY KEY ("NAME")) ;
INSERT INTO "Common"."FWK_SCHEMA_METADATA"("NAME", "VALUE") VALUES ('VERSION', FORMATDATETIME(CURRENT_TIMESTAMP, 'yyyyMMdd''T''HHmmss.SSS000')) [42101-175]
at org.openconcerto.sql.model.StructureSource.init(StructureSource.java:134)
at org.openconcerto.sql.model.SQLBase.refreshTables(SQLBase.java:276)
at org.openconcerto.sql.model.SQLBase.fetchTablesP(SQLBase.java:252)
at org.openconcerto.sql.model.SQLBase.loadTables(SQLBase.java:207)
at org.openconcerto.sql.model.SQLBase.refresh(SQLBase.java:168)
at org.openconcerto.sql.model.SQLBase.init(SQLBase.java:147)
at org.openconcerto.sql.model.SQLServer.putBase(SQLServer.java:494)
at org.openconcerto.sql.model.SQLServer.createBase(SQLServer.java:422)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:409)
at org.openconcerto.sql.model.SQLServer.createSystemRoot(SQLServer.java:468)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:446)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:426)
at org.openconcerto.sql.PropsConfiguration.createSystemRoot(PropsConfiguration.java:682)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createSystemRoot(ComptaPropsConfiguration.java:665)
at org.openconcerto.sql.PropsConfiguration.getSystemRoot(PropsConfiguration.java:1096)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:135)
... 1 more
Caused by: org.h2.jdbc.JdbcSQLException: Table "FWK_SCHEMA_METADATA" already exists; SQL statement:
CREATE TABLE "Common"."FWK_SCHEMA_METADATA" (
"NAME" varchar(100) default '' NOT NULL,
"VALUE" varchar(250) default '' NOT NULL,
PRIMARY KEY ("NAME")) ;
INSERT INTO "Common"."FWK_SCHEMA_METADATA"("NAME", "VALUE") VALUES ('VERSION', FORMATDATETIME(CURRENT_TIMESTAMP, 'yyyyMMdd''T''HHmmss.SSS000')) [42101-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.ddl.CreateTable.update(CreateTable.java:109)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.command.CommandList.update(CommandList.java:43)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.openconcerto.sql.model.JDBCStructureSource.getNames(JDBCStructureSource.java:133)
at org.openconcerto.sql.model.StructureSource$1$1.run(StructureSource.java:118)
at java.security.AccessController.doPrivileged(Native Method)
at org.openconcerto.sql.model.StructureSource$1.handle(StructureSource.java:115)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:844)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:812)
at org.openconcerto.sql.model.StructureSource.init(StructureSource.java:111)
... 16 more
"
quand je fais une mise à jour voila ce qu'il me dis
" Echec de mise à jour
org.h2.jdbc.JdbcSQLException: Table "FWK_SCHEMA_METADATA" already exists; SQL statement:
CREATE TABLE "Common"."FWK_SCHEMA_METADATA" (
"NAME" varchar(100) default '' NOT NULL,
"VALUE" varchar(250) default '' NOT NULL,
PRIMARY KEY ("NAME")) ;
INSERT INTO "Common"."FWK_SCHEMA_METADATA"("NAME", "VALUE") VALUES ('VERSION', FORMATDATETIME(CURRENT_TIMESTAMP, 'yyyyMMdd''T''HHmmss.SSS000')) [42101-175]
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:351)
at java.lang.Thread.run(Thread.java:695)
Caused by: org.openconcerto.sql.model.StructureSource$PrechangeException: org.h2.jdbc.JdbcSQLException: Table "FWK_SCHEMA_METADATA" already exists; SQL statement:
CREATE TABLE "Common"."FWK_SCHEMA_METADATA" (
"NAME" varchar(100) default '' NOT NULL,
"VALUE" varchar(250) default '' NOT NULL,
PRIMARY KEY ("NAME")) ;
INSERT INTO "Common"."FWK_SCHEMA_METADATA"("NAME", "VALUE") VALUES ('VERSION', FORMATDATETIME(CURRENT_TIMESTAMP, 'yyyyMMdd''T''HHmmss.SSS000')) [42101-175]
at org.openconcerto.sql.model.StructureSource.init(StructureSource.java:134)
at org.openconcerto.sql.model.SQLBase.refreshTables(SQLBase.java:276)
at org.openconcerto.sql.model.SQLBase.fetchTablesP(SQLBase.java:252)
at org.openconcerto.sql.model.SQLBase.loadTables(SQLBase.java:207)
at org.openconcerto.sql.model.SQLBase.refresh(SQLBase.java:168)
at org.openconcerto.sql.model.SQLBase.init(SQLBase.java:147)
at org.openconcerto.sql.model.SQLServer.putBase(SQLServer.java:494)
at org.openconcerto.sql.model.SQLServer.createBase(SQLServer.java:422)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:409)
at org.openconcerto.sql.model.SQLServer.createSystemRoot(SQLServer.java:468)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:446)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:426)
at org.openconcerto.sql.PropsConfiguration.createSystemRoot(PropsConfiguration.java:682)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createSystemRoot(ComptaPropsConfiguration.java:665)
at org.openconcerto.sql.PropsConfiguration.getSystemRoot(PropsConfiguration.java:1096)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:135)
... 1 more
Caused by: org.h2.jdbc.JdbcSQLException: Table "FWK_SCHEMA_METADATA" already exists; SQL statement:
CREATE TABLE "Common"."FWK_SCHEMA_METADATA" (
"NAME" varchar(100) default '' NOT NULL,
"VALUE" varchar(250) default '' NOT NULL,
PRIMARY KEY ("NAME")) ;
INSERT INTO "Common"."FWK_SCHEMA_METADATA"("NAME", "VALUE") VALUES ('VERSION', FORMATDATETIME(CURRENT_TIMESTAMP, 'yyyyMMdd''T''HHmmss.SSS000')) [42101-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.ddl.CreateTable.update(CreateTable.java:109)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.command.CommandList.update(CommandList.java:43)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.openconcerto.sql.model.JDBCStructureSource.getNames(JDBCStructureSource.java:133)
at org.openconcerto.sql.model.StructureSource$1$1.run(StructureSource.java:118)
at java.security.AccessController.doPrivileged(Native Method)
at org.openconcerto.sql.model.StructureSource$1.handle(StructureSource.java:115)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:844)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:812)
at org.openconcerto.sql.model.StructureSource.init(StructureSource.java:111)
... 16 more
"
Cette erreur ne devrait pas se produire... nous ferons quelques tests demain, je vous tiens au courant.
Bonjour,
A moins d'un bug relatif à Java 6, merci de nous envoyer votre base de données pour tests!
Cordialement,
A moins d'un bug relatif à Java 6, merci de nous envoyer votre base de données pour tests!
Cordialement,