8 Replies Latest reply on Jul 13, 2011 4:24 AM by Michael Wagner

    H2 database problems, running jBPM 5.1 demo

    Michael Wagner Newbie

      Hi,

       

      I am very new to jBPM, features looks impressive. I tried the demo since yesterday and run always again in problems with the database. Yesterday I had some "transaction not possible" problems, now I run into: "Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-157] 90020/90020"

       

      What I have done to get this error:

       

      1) download the full installer

      2) run "ant install.demo"

      3) run "ant start.demo"

      4) play with the example in eclipse (works very well)

      5) start the console in the browser and clicked on "process history"

       

      Then the error occurs. Restarting by calling "ant stop.demo" and then "ant start.demo" does not help. Cosole login is showing up, after login just a white site is displayed. The log showing:

       

      2011-07-01 11:27:36,882 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (main) Throwable while attempting to get a new connection: null

      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.h2.jdbc.JdbcSQLException: Datenbank wird wahrscheinlich bereits benutzt: "Locked by another process". Mögliche Lösungen: alle Verbindungen schliessen; Server Modus verwenden

      Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-124]

          at org.h2.message.Message.getSQLException(Message.java:111)

          at org.h2.message.Message.getSQLException(Message.java:122)

          at org.h2.message.Message.getSQLException(Message.java:75)

          at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:474)

          at org.h2.store.FileLock.lockFile(FileLock.java:333)

          at org.h2.store.FileLock.lock(FileLock.java:131)

       

      I will no reboot windows and hope this helps

       

      Is there something about the H2 installation I overlooked? It is important for us the the process engine NEVER runs into such a lock. So I have to find out why this happens. Somebody had the same problems?

       

      Michael

       

      ps: Yes, this is a question. But in my firefox I can see nothing to mark it as such. Can anybody help? I have 12 minutes left (so say the software to me) to mark my topic as question.... that is very frustrating, if you dont know how to do this.

        • 1. Re: H2 database problems, running jBPM 5.1 demo
          Michael Wagner Newbie

          After rebooting windows I can login to the console. Then I startet a new process. The message appears:

          "

          Successfully processed input

          You can now close this window."

           

          On strerr I see at the same time:

                [java] javax.persistence.RollbackException: Error while commiting the transaction      [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)      [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:820)      [java]     at org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:134)      [java]     at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:109)      [java]     at org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(MinaTaskServerHandler.java:41)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:713)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:793)      [java]     at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:375)      [java]     at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:229)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:793)      [java]     at org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:176)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:793)      [java]     at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:638)      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:598)      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:587)      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:61)      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:969)      [java]     at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)      [java]     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)      [java]     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)      [java]     at java.lang.Thread.run(Thread.java:662)      [java] Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update      [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)      [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)      [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)      [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)      [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)      [java]     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)      [java]     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)      [java]     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)      [java]     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)      [java]     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)      [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)      [java]     ... 29 more      [java] Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referentielle Integritõt verletzt: "FK27A9A59E619A0: PUBLIC.TASK FOREIGN KEY(CREATEDBY_ID) REFERENCES PU BLIC.ORGANIZATIONALENTITY(ID)"      [java] Referential integrity constraint violation: "FK27A9A59E619A0: PUBLIC.TASK FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL stat ement:      [java] update Task set allowedToDelegate=?, taskInitiator_id=?, priority=?, activationTime=?, actualOwner_id=?, createdBy_id=?, createdOn=?, documentAccessType= ?, documentContentId=?, documentType=?, expirationTime=?, faultAccessType=?, faultContentId=?, faultName=?, faultType=?, outputAccessType=?, outputContentId=?, outpu tType=?, parentId=?, previousStatus=?, processInstanceId=?, skipable=?, status=?, workItemId=? where id=? [23002-124]      [java]     at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1082)      [java]     at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)      [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)      [java]     ... 37 more

          • 2. Re: H2 database problems, running jBPM 5.1 demo
            Michael Wagner Newbie

            Hi,

             

            I am still running into this problems after I deleted everything, downloading again and just create a new process over the console.

             

            Here is my transcript:

            C:\jbpm-installer>ant install.demo Buildfile: C:\jbpm-installer\build.xml  download.jboss.check:      [echo] Checking JBoss AS download ...  download.jboss:      [echo] Getting JBoss AS ...       [get] Getting: http://downloads.sourceforge.net/jboss/jboss-5.1.0.GA.zip       [get] To: C:\jbpm-installer\lib\jboss-5.1.0.GA.zip       [get] http://downloads.sourceforge.net/jboss/jboss-5.1.0.GA.zip permanently moved to http://downloads.sourceforge. net/project/jboss/JBoss/JBoss-5.1.0.GA/jboss-5.1.0.GA.zip       [get] http://downloads.sourceforge.net/project/jboss/JBoss/JBoss-5.1.0.GA/jboss-5.1.0.GA.zip moved to http://switc h.dl.sourceforge.net/project/jboss/JBoss/JBoss-5.1.0.GA/jboss-5.1.0.GA.zip  install.jboss:     [unzip] Expanding: C:\jbpm-installer\lib\jboss-5.1.0.GA.zip into C:\jbpm-installer  download.drools.guvnor.check:      [echo] Checking Drools Guvnor download ...  download.drools.guvnor:  install.guvnor.into.jboss:  check.jboss.version:  install.guvnor.into.jboss.5:     [mkdir] Created dir: C:\jbpm-installer\target\drools-guvnor     [unzip] Expanding: C:\jbpm-installer\lib\guvnor-distribution-wars-5.2.0.Final-jboss-as-5.1.war into C:\jbpm-installe r\target\drools-guvnor       [zip] Building zip: C:\jbpm-installer\target\drools-guvnor.war      [copy] Copying 1 file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy    [delete] Deleting directory C:\jbpm-installer\target  check.jboss.version:  install.guvnor.into.jboss.other:  download.designer.check:      [echo] Checking Designer download ...  download.designer:  install.designer.into.jboss:      [copy] Copying 1 file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy  download.h2.check:      [echo] Checking h2 download ...  download.h2:      [echo] Getting h2 ...       [get] Getting: http://repo1.maven.org/maven2/com/h2database/h2/1.2.124/h2-1.2.124.jar       [get] To: C:\jbpm-installer\db\driver\h2.jar  check.birt:  download.birt.check:  download.birt:  download.jBPM.gwt-console.check:      [echo] Checking jBPM gwt-console download ...  download.jBPM.gwt-console:  install.jBPM-gwt-console.into.jboss:     [mkdir] Created dir: C:\jbpm-installer\target     [unzip] Expanding: C:\jbpm-installer\lib\jbpm-5.1.0.Final-gwt-console.zip into C:\jbpm-installer\target     [mkdir] Created dir: C:\jbpm-installer\target\jbpm-gwt-console-server-war     [unzip] Expanding: C:\jbpm-installer\target\jbpm-gwt-console-server-5.1.0.Final.war into C:\jbpm-installer\target\jb pm-gwt-console-server-war      [copy] Copying 1 file to C:\jbpm-installer\target\jbpm-gwt-console-server-war\WEB-INF\classes      [copy] Copying 1 file to C:\jbpm-installer\target\jbpm-gwt-console-server-war\WEB-INF\classes\META-INF      [copy] Copying 2 files to C:\jbpm-installer\target\jbpm-gwt-console-server-war\WEB-INF\classes       [zip] Building zip: C:\jbpm-installer\target\jbpm-gwt-console-server-5.1.0.Final.war      [copy] Copying 1 file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy      [copy] Copying 1 file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy    [delete] Deleting directory C:\jbpm-installer\target      [copy] Copying 1 file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy      [copy] Copying 1 file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\lib      [copy] Copying 1 file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\conf      [copy] Copying 1 file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\conf  check.birt:  install.reporting.into.jboss:  download.eclipse.check:      [echo] Checking Eclipse download ...  download.eclipse:  download.eclipse.gef.check:      [echo] Checking Eclipse GEF download ...  download.eclipse.gef:      [echo] Getting Eclipse GEF ...       [get] Getting: http://download.eclipse.org/tools/gef/downloads/drops/3.6.2/R201102251600/GEF-SDK-3.6.2.zip       [get] To: C:\jbpm-installer\lib\GEF-SDK-3.6.2.zip  install.eclipse:  unzipEclipse:     [unzip] Expanding: C:\jbpm-installer\lib\eclipse-java-helios-SR2-win32.zip into C:\jbpm-installer  untarEclipse:     [unzip] Expanding: C:\jbpm-installer\lib\GEF-SDK-3.6.2.zip into C:\jbpm-installer  download.jBPM.eclipse.check:      [echo] Checking jBPM Eclipse download ...  download.jBPM.eclipse:  install.jBPM-eclipse.into.eclipse:     [unzip] Expanding: C:\jbpm-installer\lib\jbpm-5.1.0.Final-eclipse-all.zip into C:\jbpm-installer\eclipse  download.jBPM.bin.check:      [echo] Checking jBPM binaries download ...  download.jBPM.bin:  install.jBPM.runtime:     [mkdir] Created dir: C:\jbpm-installer\runtime     [unzip] Expanding: C:\jbpm-installer\lib\jbpm-5.1.0.Final-bin.zip into C:\jbpm-installer\runtime  download.drools.eclipse.check:      [echo] Checking Drools Eclipse download ...  download.drools.eclipse:  install.drools-eclipse.into.eclipse:     [mkdir] Created dir: C:\jbpm-installer\eclipse\drools-update-site     [unzip] Expanding: C:\jbpm-installer\lib\org.drools.updatesite-5.2.0.Final-assembly.zip into C:\jbpm-installer\eclip se\drools-update-site      [copy] Copying 3 files to C:\jbpm-installer\eclipse\features      [copy] Copying 4 files to C:\jbpm-installer\eclipse\plugins    [delete] Deleting directory C:\jbpm-installer\eclipse\drools-update-site  install.demo:  BUILD SUCCESSFUL Total time: 11 minutes 45 seconds  C:\jbpm-installer>ant start.demo Buildfile: C:\jbpm-installer\build.xml  download.h2.check:      [echo] Checking h2 download ...  download.h2:  start.h2:  start.jboss:  start.eclipse:  start.human.task:     [mkdir] Created dir: C:\jbpm-installer\task-service\target     [javac] C:\jbpm-installer\build.xml:500: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath= last; set to false for repeatable builds     [javac] Compiling 1 source file to C:\jbpm-installer\task-service\target     [javac] C:\jbpm-installer\task-service\src\org\jbpm\DemoTaskService.java:49: warning: [unchecked] unchecked cast     [javac] found   : java.lang.Object     [javac] required: java.util.Map    [javac]         Map users = ( Map ) eval( reader, vars );     [javac]                                                             ^     [javac] C:\jbpm-installer\task-service\src\org\jbpm\DemoTaskService.java:54: warning: [unchecked] unchecked cast     [javac] found   : java.lang.Object     [javac] required: java.util.Map    [javac]         Map groups = ( Map ) eval( reader, vars );     [javac]                                                                ^     [javac] Note: C:\jbpm-installer\task-service\src\org\jbpm\DemoTaskService.java uses or overrides a deprecated API.     [javac] Note: Recompile with -Xlint:deprecation for details.     [javac] 2 warnings      [copy] Copying 2 files to C:\jbpm-installer\task-service\target      [java] SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".      [java] SLF4J: Defaulting to no-operation (NOP) logger implementation      [java] SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.      [java] Task service started correctly !      [java] Task service running ...      [java] javax.persistence.RollbackException: Error while commiting the transaction      [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)      [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:820)      [java]     at org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:134)      [java]     at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:109)      [java]     at org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(MinaTaskServerHandler.java:41)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain .java:713)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.ja va:434)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChai n.java:793)      [java]     at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter. java:375)      [java]     at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:229)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.ja va:434)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChai n.java:793)      [java]     at org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:176)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.ja va:434)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChai n.java:793)      [java]     at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.ja va:434)      [java]     at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:4 26)      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:638)      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:598)      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:587)      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:61 )      [java]     at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java :969)      [java]     at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)      [java]     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)      [java]     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)      [java]     at java.lang.Thread.run(Thread.java:662)      [java] Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update      [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)      [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)      [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)      [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)      [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)      [java]     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener .java:321)      [java]     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)      [java]     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)      [java]     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)      [java]     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)      [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)      [java]     ... 29 more      [java] Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referentielle Integritõt verletzt: "FK27A9A59E619A0: PUBLIC .TASK FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"      [java] Referential integrity constraint violation: "FK27A9A59E619A0: PUBLIC.TASK FOREIGN KEY(CREATEDBY_ID) REFERENC ES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement:      [java] update Task set allowedToDelegate=?, taskInitiator_id=?, priority=?, activationTime=?, actualOwner_id=?, cre atedBy_id=?, createdOn=?, documentAccessType=?, documentContentId=?, documentType=?, expirationTime=?, faultAccessType=? , faultContentId=?, faultName=?, faultType=?, outputAccessType=?, outputContentId=?, outputType=?, parentId=?, previousS tatus=?, processInstanceId=?, skipable=?, status=?, workItemId=? where id=? [23002-124]      [java]     at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1082)      [java]     at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)      [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)      [java]     ... 37 more

             

            Are there any right I have to set? Where exactly is the db file stored?  Michael

            • 3. Re: H2 database problems, running jBPM 5.1 demo
              bpmn2user Expert

              You might want to look for the directory 'repository' in jbpm-installer directory

              • 4. Re: H2 database problems, running jBPM 5.1 demo
                Kris Verlaenen Master

                The referential integrity constraint violation seems to indicate you are trying to create a task but the user that the task is assigned to does not exist?  What user are you using in your test and is this one of the pre-registered or did you register your custom users?

                 

                Kris

                • 5. Re: H2 database problems, running jBPM 5.1 demo
                  Michael Wagner Newbie

                  Hi Kris,

                   

                  thanks for your answer, you are probably right. Yesterday I tested the whole day, using the registered users john,mary and krisv and the error has not occured. Last week I tried with "michael" without registering. But I was able to create a task with the non existing user. Would be nice to have an error message if a user does not exists. This is no complaint. It is a great project and I'm looking forward to understand everything.

                  Perhaps such a message would make no sense since it can happen that users will be registered after a process is defined?

                  Great manual, too.

                   

                  Michael

                  • 6. Re: H2 database problems, running jBPM 5.1 demo
                    Michael Wagner Newbie

                    Hi Kris,

                     

                    I have to reformulate my question: what tools are you using to "clean up" the database if something like my error occurs? The "ant clean.demo" followed by "ant install.demo" does not correct the database. I have to delete the whole install folder an reinstall to get things running again.

                     

                    Michael

                    • 7. Re: H2 database problems, running jBPM 5.1 demo
                      Michael Wagner Newbie

                      The database file can be found here: C:\Documents and Settings\<username>\test.db if you are on windows. It is not in the jbpm-installer directory. You possibly could repair a broken db with the from h2 provided tools:

                      http://www.h2database.com/html/download.html

                       

                      I have been able to backup the db and restore it with the tool found under: http://localhost:8082 (after installing the above).

                      • 8. Re: H2 database problems, running jBPM 5.1 demo
                        Michael Wagner Newbie

                        What I do not understand is: how can a db contraint concerning users occur if the users are not stored in this db? The users are stored in the property file in the default-server.

                         

                        Still nobody can tell me how to fix the db if this error occurs?