OpenConcerto

Bonjour,
J'ai téléchargé votre logiciel Open concerto aujourd'hui, mais je n'arrive pas à le faire fonctionner.
Je suis sous mac osx 10.6.8, j'ai vérifié ma version de Java qui est ok.
Lorsque j'ouvre le logiciel monoposte, après connexion, voilà le message qui s'affiche:
Erreur de connexion

table TR_BON_DE_LIVRAISON not found in [OpenConcerto48, Common]
org.openconcerto.utils.ExceptionHandler: Erreur de connexion
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:112)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:116)
at org.openconcerto.erp.action.NouvelleConnexionAction$1.run(NouvelleConnexionAction.java:252)
at org.openconcerto.sql.ui.ConnexionPanel.connect(ConnexionPanel.java:476)
at org.openconcerto.sql.ui.ConnexionPanel.access$4(ConnexionPanel.java:449)
at org.openconcerto.sql.ui.ConnexionPanel$7.run(ConnexionPanel.java:404)
at java.lang.Thread.run(Thread.java:695)
Caused by: org.openconcerto.sql.model.DBStructureItemNotFound: table TR_BON_DE_LIVRAISON not found in [OpenConcerto48, Common]
at org.openconcerto.sql.model.DBSystemRoot.findTable(DBSystemRoot.java:308)
at org.openconcerto.sql.model.DBRoot.findTable(DBRoot.java:91)
at org.openconcerto.erp.core.common.element.ComptaSQLConfElement.<init>(ComptaSQLConfElement.java:78)
at org.openconcerto.erp.core.sales.shipment.element.TransferShipmentSQLElement.<init>(TransferShipmentSQLElement.java:25)
at org.openconcerto.erp.config.ComptaPropsConfiguration.setSocieteDirectory(ComptaPropsConfiguration.java:699)
at org.openconcerto.erp.config.ComptaPropsConfiguration.setUpSocieteDataBaseConnexion(ComptaPropsConfiguration.java:978)
at org.openconcerto.erp.action.NouvelleConnexionAction$1.run(NouvelleConnexionAction.java:131)
... 4 more


Si je tente une mise à jour de la base, voilà un autre message:
Echec de mise à jour

Impossible d'accéder au résultat de ALTER TABLE "Default"."AXE_ANALYTIQUE" ALTER COLUMN "ID" int DEFAULT (NEXT VALUE FOR "Default".SYSTEM_SEQUENCE_CBDE4A1A_9CA6_4545_AF66_3E1E053EC3B1) NOT NULL SEQUENCE "SYSTEM_SEQUENCE_CBDE4A1A_9CA6_4545_AF66_3E1E053EC3B1";
in jdbc:h2:file:/Users/geraldinebarioz/Library/Application Support/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:695)
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de ALTER TABLE "Default"."AXE_ANALYTIQUE" ALTER COLUMN "ID" int DEFAULT (NEXT VALUE FOR "Default".SYSTEM_SEQUENCE_CBDE4A1A_9CA6_4545_AF66_3E1E053EC3B1) NOT NULL SEQUENCE "SYSTEM_SEQUENCE_CBDE4A1A_9CA6_4545_AF66_3E1E053EC3B1";
in jdbc:h2:file:/Users/geraldinebarioz/Library/Application Support/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_CBDE4A1A_9CA6_4545_AF66_3E1E053EC3B1" not found; SQL statement:
ALTER TABLE "Default"."AXE_ANALYTIQUE" ALTER COLUMN "ID" int DEFAULT (NEXT VALUE FOR "Default".SYSTEM_SEQUENCE_CBDE4A1A_9CA6_4545_AF66_3E1E053EC3B1) NOT NULL SEQUENCE "SYSTEM_SEQUENCE_CBDE4A1A_9CA6_4545_AF66_3E1E053EC3B1"; [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


Pourriez-vous m'aider svp?

Merci par avance

Bonjour,

Patience : voir ici
http://www.openconcerto.org/forum/viewt ... =993#p3908

Stephan

Bonjour,
Merci pour votre réponse.
J'ai téléchargé la nouvelle version, mais lors de la mise à jour de la base, j'ai à nouveau un problème:

Echec de mise à jour

Impossible d'obtenir une connexion sur jdbc:h2:file:/Users/geraldinebarioz/Library/Application Support/OpenConcerto/DBData/OpenConcerto: Unique index or primary key violation: "SYS_ID ON PUBLIC.SYS(ID) VALUES ( /* key:45475 */ 51, 0, 3, 'CREATE SEQUENCE ""Default"".SYSTEM_SEQUENCE_DEA2F695_B810_4663_80FF_ABE8BA668FB8 START WITH 2 BELONGS_TO_TABLE')" [23505-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:307)
at java.lang.Thread.run(Thread.java:695)
Caused by: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:h2:file:/Users/geraldinebarioz/Library/Application Support/OpenConcerto/DBData/OpenConcerto: Unique index or primary key violation: "SYS_ID ON PUBLIC.SYS(ID) VALUES ( /* key:45475 */ 51, 0, 3, 'CREATE SEQUENCE ""Default"".SYSTEM_SEQUENCE_DEA2F695_B810_4663_80FF_ABE8BA668FB8 START WITH 2 BELONGS_TO_TABLE')" [23505-175]
at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1194)
at org.openconcerto.sql.model.SQLDataSource.borrowConnection(SQLDataSource.java:1129)
at org.openconcerto.sql.model.SQLDataSource.getNewConnection(SQLDataSource.java:1111)
at org.openconcerto.sql.model.SQLDataSource$QueryInfo.<init>(SQLDataSource.java:611)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:519)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:466)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1660)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1642)
at org.openconcerto.sql.model.DBSystemRoot.setRootPathFromDS(DBSystemRoot.java:603)
at org.openconcerto.sql.model.DBSystemRoot.setDS(DBSystemRoot.java:599)
at org.openconcerto.sql.model.SQLBase.<init>(SQLBase.java:138)
at org.openconcerto.sql.model.SQLSyntax.createBase(SQLSyntax.java:800)
at org.openconcerto.sql.model.SQLServer.createBase(SQLServer.java:417)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:405)
at org.openconcerto.sql.model.SQLServer.createSystemRoot(SQLServer.java:464)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:442)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:422)
at org.openconcerto.sql.PropsConfiguration.createSystemRoot(PropsConfiguration.java:677)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createSystemRoot(ComptaPropsConfiguration.java:597)
at org.openconcerto.sql.PropsConfiguration.getSystemRoot(PropsConfiguration.java:1090)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:134)
... 1 more
Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "SYS_ID ON PUBLIC.SYS(ID) VALUES ( /* key:45475 */ 51, 0, 3, 'CREATE SEQUENCE ""Default"".SYSTEM_SEQUENCE_DEA2F695_B810_4663_80FF_ABE8BA668FB8 START WITH 2 BELONGS_TO_TABLE')" [23505-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.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:101)
at org.h2.index.TreeIndex.add(TreeIndex.java:68)
at org.h2.table.RegularTable.addRowsToIndex(RegularTable.java:339)
at org.h2.table.RegularTable.addIndex(RegularTable.java:266)
at org.h2.engine.Database.open(Database.java:673)
at org.h2.engine.Database.openDatabase(Database.java:244)
at org.h2.engine.Database.<init>(Database.java:239)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:160)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:139)
at org.h2.engine.Engine.createSession(Engine.java:122)
at org.h2.engine.Engine.createSession(Engine.java:28)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:323)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90)
at org.h2.Driver.connect(Driver.java:73)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.openconcerto.sql.model.SQLDataSource$2.makeObject(SQLDataSource.java:1375)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.openconcerto.sql.model.SQLDataSource.createPoolableConnectionFactory(SQLDataSource.java:1390)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1177)
... 21 more


Pourriez-vous m'aider svp?

Merci beaucoup.

Bonjour,

je subis le même problème sous mac en version monoposte. Je suis repassé sous la version 1.3beta et après reconfiguration j'ai pu reconnecter la base de données.

Une solution est elle prévue ?

Merci

Bonjour,

org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "SYS_ID ON PUBLIC.SYS(ID) VALUES ( /* key:45475 */ 51, 0, 3, 'CREATE SEQUENCE ""Default"".SYSTEM_SEQUENCE_DEA2F695_B810_4663_80FF_ABE8BA668FB8 START WITH 2 BELONGS_TO_TABLE')" [23505-175]

est un bug de H2, pas d'OpenConcerto.
Le soumettre à H2 directement via https://groups.google.com/forum/#!forum/h2-database
en fournissant votre base.

Cordialement,