Problème d'installation sous mac

gbarioz · mar. mars 25, 2014 10:26 pm

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

xantof · jeu. mars 27, 2014 9:46 am

Bonjour,

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

Stephan

gbarioz · sam. mars 29, 2014 1:26 pm

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.

morganarg · jeu. mai 08, 2014 1:33 pm

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

jeu. mai 08, 2014 3:08 pm

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,