J'ouvre prochainement un commerce et j'ai opté pour le logiciel d'open concerto.
Je l'ai installé sur mon ordi (un Dell Inspiron ONE 19T avec Windows7). Et j'ai actuellement une erreur qui m'empêche de travailler avec.
Je m'explique :
J'ai pu ouvrir Open concerto avec les données d'essai de ILM informatique.
Puis j'ai ouvert Configuration, fait la mise à jour des données, et dans l'onglet caisse, ILM est bien apparu.
J'ai rajouté en bas de l'onglet caisse les données de mon imprimantes :
- Port/nom : USB001/CITIZEN CT-S2000 POS Printer
- Dossier lib JPOS : C:\Program Files (x86)\CITIZEN\CITIZEN JPOS Service Objects
- une entête et un pied de page en mode normal
Et j'ai fait Sauvegarder la configuration. (peut-être ces données sont-elles la cause du plantage..?)
Après tout ça j'ai ouvert Caisse et les problèmes ont commencé :
Je ne peux pas ouvrir la caisse j'ai le message d'erreur suivant :
Puis si je retourne dans Configuration, il me dit :mpossible de lire le fichier de configuration.
found neither C:\Users\Magasin\.OpenConcerto\main.properties nor embedded main.properties
org.openconcerto.utils.ExceptionHandler: Impossible de lire le fichier de configuration.
at org.openconcerto.utils.ExceptionHandler.die(ExceptionHandler.java:106)
at org.openconcerto.erp.config.ComptaPropsConfiguration.create(ComptaPropsConfiguration.java:313)
at org.openconcerto.erp.config.ComptaPropsConfiguration.create(ComptaPropsConfiguration.java:283)
at org.openconcerto.erp.config.ComptaPropsConfiguration.create(ComptaPropsConfiguration.java:279)
at org.openconcerto.erp.core.sales.pos.Caisse.createConnexion(Caisse.java:114)
at org.openconcerto.erp.core.sales.pos.ui.CaisseFrame$1.run(CaisseFrame.java:89)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.io.IOException: found neither C:\Users\Magasin\.OpenConcerto\main.properties nor embedded main.properties
at org.openconcerto.erp.config.ComptaPropsConfiguration.create(ComptaPropsConfiguration.java:308)
... 18 more
Si je veux remettre à niveau la base il affiche :impossible de se connecter au serveur
Et si je veux rouvrir Open Concerto j'ai :Echec de mise à jour
Impossible d'obtenir une connexion sur jdbc:h2:file:C:\Users\Magasin\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto: Cannot create PoolableConnectionFactory (Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode; SQL statement:
null/13faa3a732ae80ae131b802c18c091eb1d089e62029 [90020-138])
org.openconcerto.utils.ExceptionHandler: Echec de mise à jour
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:86)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:90)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:274)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:h2:file:C:\Users\Magasin\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto: Cannot create PoolableConnectionFactory (Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode; SQL statement:
null/13faa3a732ae80ae131b802c18c091eb1d089e62029 [90020-138])
at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1093)
at org.openconcerto.sql.model.SQLDataSource.borrowConnection(SQLDataSource.java:1032)
at org.openconcerto.sql.model.SQLDataSource.getNewConnection(SQLDataSource.java:1014)
at org.openconcerto.sql.model.SQLDataSource$QueryInfo.<init>(SQLDataSource.java:538)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:444)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:396)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1352)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1334)
at org.openconcerto.sql.model.DBSystemRoot.setRootPathFromDS(DBSystemRoot.java:456)
at org.openconcerto.sql.model.DBSystemRoot.setDS(DBSystemRoot.java:452)
at org.openconcerto.sql.model.SQLBase.<init>(SQLBase.java:126)
at org.openconcerto.sql.model.SQLSyntax.createBase(SQLSyntax.java:766)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:370)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:358)
at org.openconcerto.sql.model.SQLServer.createSystemRoot(SQLServer.java:419)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:397)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:378)
at org.openconcerto.sql.PropsConfiguration.createSystemRoot(PropsConfiguration.java:466)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createSystemRoot(ComptaPropsConfiguration.java:535)
at org.openconcerto.sql.PropsConfiguration.getSystemRoot(PropsConfiguration.java:779)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:114)
... 1 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode; SQL statement:
null/13faa3a732ae80ae131b802c18c091eb1d089e62029 [90020-138])
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.openconcerto.sql.model.SQLDataSource.createDataSource(SQLDataSource.java:1120)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1076)
... 21 more
Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode; SQL statement:
null/13faa3a732ae80ae131b802c18c091eb1d089e62029 [90020-138]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:436)
at org.h2.store.FileLock.lockFile(FileLock.java:331)
at org.h2.store.FileLock.lock(FileLock.java:129)
at org.h2.engine.Database.open(Database.java:523)
at org.h2.engine.Database.openDatabase(Database.java:207)
at org.h2.engine.Database.<init>(Database.java:202)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:146)
at org.h2.engine.Engine.getSession(Engine.java:125)
at org.h2.engine.Session.createSession(Session.java:119)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:241)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:219)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:111)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:95)
at org.h2.Driver.connect(Driver.java:58)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 24 more
J'espère que vous pourrez m'aider car le logiciel a vraiment l'air de me plaire !Erreur de connexion à la base de données
Impossible d'obtenir une connexion sur jdbc:h2:file:C:\Users\Magasin\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto: Cannot create PoolableConnectionFactory (Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode; SQL statement:
null/13faa3a732ae80ae131b802c18c091eb1d089e62029 [90020-138])
org.openconcerto.utils.ExceptionHandler: Erreur de connexion à la base de données
at org.openconcerto.utils.ExceptionHandler.die(ExceptionHandler.java:106)
at org.openconcerto.erp.config.Gestion.main(Gestion.java:219)
Caused by: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:h2:file:C:\Users\Magasin\.java\ilm\sql-config\OpenConcerto\DBData/OpenConcerto: Cannot create PoolableConnectionFactory (Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode; SQL statement:
null/13faa3a732ae80ae131b802c18c091eb1d089e62029 [90020-138])
at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1093)
at org.openconcerto.sql.model.SQLDataSource.borrowConnection(SQLDataSource.java:1032)
at org.openconcerto.sql.model.SQLDataSource.getNewConnection(SQLDataSource.java:1014)
at org.openconcerto.sql.model.SQLDataSource$QueryInfo.<init>(SQLDataSource.java:538)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:444)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:396)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1352)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1334)
at org.openconcerto.sql.model.DBSystemRoot.setRootPathFromDS(DBSystemRoot.java:456)
at org.openconcerto.sql.model.DBSystemRoot.setDS(DBSystemRoot.java:452)
at org.openconcerto.sql.model.SQLBase.<init>(SQLBase.java:126)
at org.openconcerto.sql.model.SQLSyntax.createBase(SQLSyntax.java:766)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:370)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:358)
at org.openconcerto.sql.model.SQLServer.createSystemRoot(SQLServer.java:419)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:397)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:378)
at org.openconcerto.sql.PropsConfiguration.createSystemRoot(PropsConfiguration.java:466)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createSystemRoot(ComptaPropsConfiguration.java:535)
at org.openconcerto.sql.PropsConfiguration.getSystemRoot(PropsConfiguration.java:779)
at org.openconcerto.erp.config.Gestion.main(Gestion.java:216)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode; SQL statement:
null/13faa3a732ae80ae131b802c18c091eb1d089e62029 [90020-138])
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.openconcerto.sql.model.SQLDataSource.createDataSource(SQLDataSource.java:1120)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1076)
... 20 more
Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode; SQL statement:
null/13faa3a732ae80ae131b802c18c091eb1d089e62029 [90020-138]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:436)
at org.h2.store.FileLock.lockFile(FileLock.java:331)
at org.h2.store.FileLock.lock(FileLock.java:129)
at org.h2.engine.Database.open(Database.java:523)
at org.h2.engine.Database.openDatabase(Database.java:207)
at org.h2.engine.Database.<init>(Database.java:202)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:146)
at org.h2.engine.Engine.getSession(Engine.java:125)
at org.h2.engine.Session.createSession(Session.java:119)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:241)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:219)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:111)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:95)
at org.h2.Driver.connect(Driver.java:58)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 23 more
En comparaison avec des ERP du marché (EBP notamment), il équivaut largement au niveau des fonctionnalités.
Merci d'avance