8 Replies Latest reply on Jul 29, 2012 10:02 AM by artist123

    Human Task , task table deleted every time, when I restart the jbpm-install demo application..

    artist123

      Hi,

       

      I try to install jbpm5.3 installer, afer some persistence related fixes, It is working fine.

      but I have one problem, each time when I stop and start the demo.db, all the records in task table get deleted, even though some reserved data is there it deletes all.

       

      please advise me, how to prevent this, below is my task service persistence.xml...........

       

       

      thanks,

       

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

      <persistence version="1.0"

                   xsi:schemaLocation="http://java.sun.com/xml/ns/persistence

                                       http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd

                                       http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"

                   xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"

                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                   xmlns="http://java.sun.com/xml/ns/persistence">

        <persistence-unit name="org.jbpm.task">

          <provider>org.hibernate.ejb.HibernatePersistence</provider>

          <non-jta-data-source>java:jboss/datasources/taskDS</non-jta-data-source>      

          <mapping-file>META-INF/Taskorm.xml</mapping-file>

          <class>org.jbpm.task.Attachment</class>

          <class>org.jbpm.task.BooleanExpression</class>

          <class>org.jbpm.task.Comment</class>

          <class>org.jbpm.task.Content</class>

          <class>org.jbpm.task.Deadline</class>

          <class>org.jbpm.task.Delegation</class>

          <class>org.jbpm.task.EmailNotification</class>

          <class>org.jbpm.task.EmailNotificationHeader</class>

          <class>org.jbpm.task.Escalation</class>

          <class>org.jbpm.task.Group</class>

          <class>org.jbpm.task.I18NText</class>

          <class>org.jbpm.task.Notification</class>

          <class>org.jbpm.task.OnAllSubTasksEndParentEndStrategy</class>

          <class>org.jbpm.task.OnParentAbortAllSubTasksEndStrategy</class>

          <class>org.jbpm.task.PeopleAssignments</class>

          <class>org.jbpm.task.Reassignment</class>

          <class>org.jbpm.task.Status</class>

          <class>org.jbpm.task.SubTasksStrategy</class>

          <class>org.jbpm.task.Task</class>

          <class>org.jbpm.task.TaskData</class>

          <class>org.jbpm.task.User</class>

          <properties>

           <!--

            <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/> 

            -->

            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>       

            <property name="hibernate.max_fetch_depth" value="3"/>

            <property name="hibernate.hbm2ddl.auto" value="update" />

            <property name="hibernate.show_sql" value="false" /> 

            <!-- for AS7 -->

            <property name="hibernate.transaction.manager_lookup_class" value="org.jbpm.integration.console.JBPMTransactionManager" />

            <!-- for AS5 -->

            <!-- <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" /> -->

          </properties>

        </persistence-unit>

      </persistence>

        • 1. Re: Human Task , task table deleted every time, when I restart the jbpm-install demo application..
          artist123

          sorry, table is there but all data deleted...

          When I check the log file...

           

          16:03:59,805 INFO  [stdout] (http-localhost-127.0.0.1-8080-8) INFO  27-07 16:03:59,805 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:03:59,844 INFO  [stdout] (http-localhost-127.0.0.1-8080-1) INFO  27-07 16:03:59,844 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:03:59,891 INFO  [stdout] (http-localhost-127.0.0.1-8080-2) INFO  27-07 16:03:59,891 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:03:59,911 INFO  [stdout] (http-localhost-127.0.0.1-8080-2) INFO  27-07 16:03:59,911 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:04:01,835 INFO  [stdout] (http-localhost-127.0.0.1-8080-7) Hibernate: select processins0_.id as id17_, processins0_.end_date as end2_17_, processins0_.processId as processId17_, processins0_.processInstanceId as processI4_17_, processins0_.start_date as start5_17_ from ProcessInstanceLog processins0_ where processins0_.processId=? and (processins0_.end_date is null)

          16:04:01,845 INFO  [stdout] (http-localhost-127.0.0.1-8080-7) Hibernate: update ProcessInstanceInfo set OPTLOCK=?, processId=?, startDate=?, lastReadDate=?, lastModificationDate=?, state=?, processInstanceByteArray=? where InstanceId=? and OPTLOCK=?

          16:05:15,308 ERROR [stderr] (Thread-23) java.lang.IllegalArgumentException: org.hibernate.QueryParameterException: could not locate named parameter [userId]

          16:05:15,308 ERROR [stderr] (Thread-23)  at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:206)

          16:05:15,308 ERROR [stderr] (Thread-23)  at org.jbpm.task.service.TaskServiceSession.getTasksAssignedAsPotentialOwnerByStatusByGroup(TaskServiceSession.java:1011)

          16:05:15,308 ERROR [stderr] (Thread-23)  at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:356)

          16:05:15,388 ERROR [stderr] (Thread-23)  at org.jbpm.task.service.hornetq.HornetQTaskServerHandler.messageReceived(HornetQTaskServerHandler.java:44)

          16:05:15,388 ERROR [stderr] (Thread-23)  at org.jbpm.task.service.hornetq.BaseHornetQTaskServer.run(BaseHornetQTaskServer.java:85)

          16:05:15,388 ERROR [stderr] (Thread-23)  at java.lang.Thread.run(Thread.java:736)

          16:05:15,388 ERROR [stderr] (Thread-23) Caused by: org.hibernate.QueryParameterException: could not locate named parameter [userId]

          16:05:15,388 ERROR [stderr] (Thread-23)  at org.hibernate.engine.query.ParameterMetadata.getNamedParameterDescriptor(ParameterMetadata.java:99)

          16:05:15,488 ERROR [stderr] (Thread-23)  at org.hibernate.engine.query.ParameterMetadata.getNamedParameterExpectedType(ParameterMetadata.java:105)

          16:05:15,488 ERROR [stderr] (Thread-23)  at org.hibernate.impl.AbstractQueryImpl.determineType(AbstractQueryImpl.java:437)

          16:05:15,488 ERROR [stderr] (Thread-23)  at org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:407)

          16:05:15,488 ERROR [stderr] (Thread-23)  at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:201)

          16:05:15,488 ERROR [stderr] (Thread-23)  ... 5 more

          16:05:15,588 ERROR [stderr] (Thread-39) Exception in thread "Thread-39" java.lang.RuntimeException: Client Exception with class class org.jbpm.task.service.hornetq.HornetQTaskClientConnector$1 using port 5445

          16:05:15,588 ERROR [stderr] (Thread-39)  at org.jbpm.task.service.hornetq.HornetQTaskClientConnector$1.run(HornetQTaskClientConnector.java:134)

          16:05:15,588 ERROR [stderr] (Thread-39)  at java.lang.Thread.run(Thread.java:736)

          16:05:15,588 ERROR [stderr] (Thread-39) Caused by: java.lang.NullPointerException

          16:05:15,688 ERROR [stderr] (Thread-39)  at org.jbpm.task.service.TaskClientHandler.messageReceived(TaskClientHandler.java:62)

          16:05:15,688 ERROR [stderr] (Thread-39)  at org.jbpm.task.service.hornetq.HornetQTaskClientHandler.messageReceived(HornetQTaskClientHandler.java:56)

          16:05:15,688 ERROR [stderr] (Thread-39)  at org.jbpm.task.service.hornetq.HornetQTaskClientConnector$1.run(HornetQTaskClientConnector.java:120)

          16:05:15,688 ERROR [stderr] (Thread-39)  ... 1 more

          16:05:19,168 INFO  [stdout] (http-localhost-127.0.0.1-8080-2) INFO  27-07 16:05:19,168 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:05:19,188 INFO  [stdout] (http-localhost-127.0.0.1-8080-1) INFO  27-07 16:05:19,188 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:05:19,198 INFO  [stdout] (http-localhost-127.0.0.1-8080-1) INFO  27-07 16:05:19,198 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:05:19,233 INFO  [stdout] (http-localhost-127.0.0.1-8080-8) INFO  27-07 16:05:19,233 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:05:19,257 INFO  [stdout] (http-localhost-127.0.0.1-8080-3) INFO  27-07 16:05:19,257 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:05:19,300 INFO  [stdout] (http-localhost-127.0.0.1-8080-3) INFO  27-07 16:05:19,300 (DemoAuthenticator.java:authenticate:65)   Demo login for user (admin) succeeded.

          16:05:20,300 INFO  [stdout] (http-localhost-127.0.0.1-8080-5) Hibernate: select processins0_.id as id17_, processins0_.end_date as end2_17_, processins0_.processId as processId17_, processins0_.processInstanceId as processI4_17_, processins0_.start_date as start5_17_ from ProcessInstanceLog processins0_ where processins0_.processId=? and (processins0_.end_date is null)

          16:05:20,300 INFO  [stdout] (http-localhost-127.0.0.1-8080-5) Hibernate: update ProcessInstanceInfo set OPTLOCK=?, processId=?, startDate=?, lastReadDate=?, lastModificationDate=?, state=?, processInstanceByteArray=? where InstanceId=? and OPTLOCK=?

          16:05:35,311 ERROR [stderr] (http-localhost-127.0.0.1-8080-4) java.lang.RuntimeException: Timeout : unable to retrieve results

          16:05:35,311 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jbpm.task.service.responsehandlers.BlockingTaskSummaryResponseHandler.getResults(BlockingTaskSummaryResponseHandler.java:41)

          16:05:35,311 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jbpm.task.service.SyncTaskServiceWrapper.getTasksAssignedAsPotentialOwnerByStatusByGroup(SyncTaskServiceWrapper.java:779)

          16:05:35,401 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jbpm.integration.console.TaskManagement.getUnassignedTasks(TaskManagement.java:163)

          16:05:35,401 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRefParticipation(TaskListFacade.java:113)

          16:05:35,401 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          16:05:35,401 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)

          16:05:35,501 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

          16:05:35,501 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at java.lang.reflect.Method.invoke(Method.java:600)

          16:05:35,501 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

          16:05:35,501 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)

          16:05:35,601 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)

          16:05:35,601 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)

          16:05:35,601 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)

          16:05:35,601 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)

          16:05:35,701 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

          16:05:35,701 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

          16:05:35,701 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

          16:05:35,701 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

          16:05:35,801 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

          16:05:35,801 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

          16:05:35,801 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

          16:05:35,801 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

          16:05:35,901 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

          16:05:35,901 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

          16:05:35,901 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

          16:05:35,901 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

          16:05:36,001 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)

          16:05:36,001 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:480)

          16:05:36,001 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)

          16:05:36,001 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)

          16:05:36,101 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

          16:05:36,101 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

          16:05:36,101 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)

          16:05:36,101 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

          16:05:36,201 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)

          16:05:36,201 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)

          16:05:36,201 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at java.lang.Thread.run(Thread.java:736)

          16:07:03,950 ERROR [stderr] (http-localhost-127.0.0.1-8080-4) java.lang.RuntimeException: Timeout : unable to retrieve results

          16:07:03,950 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jbpm.task.service.responsehandlers.BlockingTaskSummaryResponseHandler.getResults(BlockingTaskSummaryResponseHandler.java:41)

          16:07:03,950 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jbpm.task.service.SyncTaskServiceWrapper.getTasksOwned(SyncTaskServiceWrapper.java:512)

          16:07:03,950 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jbpm.integration.console.TaskManagement.getAssignedTasks(TaskManagement.java:140)

          16:07:04,010 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRef(TaskListFacade.java:101)

          16:07:04,010 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          16:07:04,010 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)

          16:07:04,010 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

          16:07:04,110 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at java.lang.reflect.Method.invoke(Method.java:600)

          16:07:04,110 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

          16:07:04,110 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)

          16:07:04,110 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)

          16:07:04,210 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)

          16:07:04,210 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)

          16:07:04,210 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)

          16:07:04,210 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

          16:07:04,310 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

          16:07:04,310 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

          16:07:04,310 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

          16:07:04,410 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

          16:07:04,410 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

          16:07:04,410 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

          16:07:04,410 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

          16:07:04,510 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

          16:07:04,510 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

          16:07:04,510 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

          16:07:04,510 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

          16:07:04,610 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)

          16:07:04,610 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:480)

          16:07:04,610 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)

          16:07:04,610 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)

          16:07:04,710 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

          16:07:04,710 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

          16:07:04,710 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)

          16:07:04,710 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

          16:07:04,810 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)

          16:07:04,810 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)

          16:07:04,810 ERROR [stderr] (http-localhost-127.0.0.1-8080-4)  at java.lang.Thread.run(Thread.java:736)

          • 2. Re: Human Task , task table deleted every time, when I restart the jbpm-install demo application..
            salaboy21

            Are you sure that everything is being stored inside your MySQL Database?

            • 3. Re: Human Task , task table deleted every time, when I restart the jbpm-install demo application..
              artist123

              yes...

              start Jobss 7 AS, human task, etc...using jbpm-console...using command "start.demo.db"

              1 - login as krisv/krisv start the process and complete the task, logout

              2 - login as john/john and complet the task, log out

              3 - log in as mary/mary and complete the task, log out,

              4 - log in as krisv/krisv and start the process and complete the task

               

              data sored in the database,  I saw data in the task table for john and mary is reserved and stiil the data is there, workitem table session table processinfo table all having data for the incomplete process...all working fine as expected,

               

              4.stop the all servicess using "ant stop.demo.db" (jboss, task service)

              5. restart the all the service using "ant start.demo.db"...

              6. login as john/john , but I dont see any task listed in the consolo...

               

              When I check the database , what happen is it delete the data in task table....thats why it is not showing any task for john and mary,

               

              my question is how to prevent this from deleting the data from the task table....

              I suspect hibernate query or persistence.xml modification etc...but I am not sure...2 days breaking my head...no use...

              please provide some tool to dig this problem...

               

              thanks

              • 4. Re: Human Task , task table deleted every time, when I restart the jbpm-install demo application..
                salaboy21

                You need to find the persistence.xml which is erasing the database.. that's hibernate configuration.

                If you are in linux grep all the files to find all the persistence.xml files around and make sure that all of them are pointing to your mysql.

                You should also take a look at the AS configuration files which can be defining a Data Source which can also be causing that behavior.

                Cheers

                1 of 1 people found this helpful
                • 5. Re: Human Task , task table deleted every time, when I restart the jbpm-install demo application..
                  artist123

                  I am going to start the secondary investigation now, going to catch the one causing me trouble and deleting my records from db....thanks for your help I will update you...soon....

                   

                  thanks,

                  • 6. Re: Human Task , task table deleted every time, when I restart the jbpm-install demo application..
                    artist123

                    Is any way, or is it possible to start the servicess  only(server and task service not db file creating)? using the ant sctipt in the build.xml?...I tried but cause lots of other exceptions...I just want to start the service i do not want to disturb the db file (after first time creating)...after that let the application handle this not ant script doing all deleting task...how to achive this

                    thanks,

                    • 7. Re: Human Task , task table deleted every time, when I restart the jbpm-install demo application..
                      artist123

                      yes, you are right, I updated the persistence.xml files(2 files) in task service folder and 3 files in lib folder(gwt server and task server war files), the problem resolved,

                       

                      jbpm-installer working beautifully as expected...great job JBPM team.

                       

                      thanks,

                      • 8. Re: Human Task , task table deleted every time, when I restart the jbpm-install demo application..
                        artist123

                        I have a questing inmy mind why do we need so many persistence.xml for task service?

                         

                        thanks,