OpenConcerto

Bonjour,

Je n'arrive plus à accéder à ma base de donnée. Pas de motif sur la config. J'ai ce message à l'ouverture :

UncaughtException on thread Thread[main,5,main]

java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:h2:file:/Users/romaindavid/Library/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
org.openconcerto.utils.ExceptionHandler: UncaughtException on thread Thread[main,5,main]
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:125)
at org.openconcerto.erp.config.Gestion$2.uncaughtException(Gestion.java:198)
at java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1057)
at java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1052)
at java.lang.Thread.dispatchUncaughtException(Thread.java:1959)
Caused by: java.lang.IllegalStateException: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:h2:file:/Users/romaindavid/Library/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
at org.openconcerto.sql.PropsConfiguration$Addable.get(PropsConfiguration.java:993)
at org.openconcerto.sql.PropsConfiguration.getDirectory(PropsConfiguration.java:1104)
at org.openconcerto.erp.config.Gestion.main(Gestion.java:309)
Caused by: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:h2:file:/Users/romaindavid/Library/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at org.openconcerto.sql.PropsConfiguration$Addable.get(PropsConfiguration.java:989)
... 2 more
Caused by: java.lang.IllegalStateException: Impossible d'obtenir une connexion sur jdbc:h2:file:/Users/romaindavid/Library/OpenConcerto/DBData/OpenConcerto;DATABASE_TO_UPPER=false
at org.openconcerto.sql.model.SQLDataSource.getRawConnectionThrow(SQLDataSource.java:1376)
at org.openconcerto.sql.model.SQLDataSource.getRawConnection(SQLDataSource.java:1394)
at org.openconcerto.sql.model.SQLDataSource._borrowConnection(SQLDataSource.java:1334)
at org.openconcerto.sql.model.SQLDataSource.borrowConnection(SQLDataSource.java:1321)
at org.openconcerto.sql.model.SQLDataSource.getNewConnection(SQLDataSource.java:1301)
at org.openconcerto.sql.model.SQLDataSource$QueryInfo.<init>(SQLDataSource.java:701)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:610)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:554)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1878)
at org.openconcerto.sql.model.SQLDataSource.getSchema(SQLDataSource.java:1860)
at org.openconcerto.sql.model.DBSystemRoot.setRootPathFromDS(DBSystemRoot.java:632)
at org.openconcerto.sql.model.DBSystemRoot.setDS(DBSystemRoot.java:628)
at org.openconcerto.sql.model.SQLBase.<init>(SQLBase.java:142)
at org.openconcerto.sql.model.SQLServer.createBase(SQLServer.java:419)
at org.openconcerto.sql.model.SQLServer.getBase(SQLServer.java:408)
at org.openconcerto.sql.model.SQLServer.createSystemRoot(SQLServer.java:467)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:445)
at org.openconcerto.sql.model.SQLServer.getSystemRoot(SQLServer.java:425)
at org.openconcerto.sql.PropsConfiguration.createSystemRoot(PropsConfiguration.java:608)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createSystemRoot(ComptaPropsConfiguration.java:747)
at org.openconcerto.sql.PropsConfiguration.getSystemRoot(PropsConfiguration.java:1043)
at org.openconcerto.sql.PropsConfiguration.createRoot(PropsConfiguration.java:390)
at org.openconcerto.sql.PropsConfiguration.getRoot(PropsConfiguration.java:1033)
at org.openconcerto.sql.element.ConfSQLElement.<init>(ConfSQLElement.java:35)
at org.openconcerto.sql.element.ConfSQLElement.<init>(ConfSQLElement.java:30)
at org.openconcerto.task.config.ComptaBasePropsConfiguration.createDirectory(ComptaBasePropsConfiguration.java:183)
at org.openconcerto.erp.config.ComptaPropsConfiguration.createDirectory(ComptaPropsConfiguration.java:767)
at org.openconcerto.sql.PropsConfiguration$1.create(PropsConfiguration.java:243)
at org.openconcerto.sql.PropsConfiguration$1.create(PropsConfiguration.java:1)
at org.openconcerto.sql.PropsConfiguration$Addable$1.call(PropsConfiguration.java:969)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.openconcerto.sql.PropsConfiguration$Addable.get(PropsConfiguration.java:987)
... 2 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowcount remaining=2 SYS" [50000-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:161)
at org.h2.message.DbException.convert(DbException.java:284)
at org.h2.engine.Database.openDatabase(Database.java:274)
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$4.makeObject(SQLDataSource.java:1584)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.openconcerto.sql.model.SQLDataSource.createPoolableConnectionFactory(SQLDataSource.java:1599)
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:1386)
... 32 more
Caused by: java.lang.RuntimeException: rowcount remaining=2 SYS
at org.h2.message.DbException.throwInternalError(DbException.java:231)
at org.h2.table.RegularTable.addIndex(RegularTable.java:272)
at org.h2.engine.Database.open(Database.java:673)
at org.h2.engine.Database.openDatabase(Database.java:244)
... 49 more

Je vous remercie par avance pour votre aide.

Romain

Bonsoir,

A priori votre base de donnée est corrompue, si vous avez une sauvegarde c'est le moment de s'en servir, sinon tentez une récupération avec l'outil H2.

Bonjour,

Merci pour votre réponse. J'ai récupéré la sauvegarde et c'est tout bon.

Cdt,
Romain