0 Replies Latest reply on Apr 9, 2015 1:11 PM by mariaprabudass Edwin

    Operation failed in LocalTaskService

    mariaprabudass Edwin Newbie

      We have implemented LocalTaskService in our Web App. I have been facing concurrency problem for the below scenario.

       

      Scenario:

      When two users are trying to complete the different task (on same time), exception occurs. This issue has not been noticed when the users complete task at different time. We're really getting stuck up with this. Is there any solution to this problem? Awaiting for your's valuable feedback.

       

      Given below the version details,

      jBPM - 5.4.0.Final

      jBoss - 7.0.2.Final

      Spring - 3.1.1.RELEASE

      Hibernate - 3.6.9

       

      Posted below the jBoss server log exception for your reference.

       

      Exception1:-

      [org.hibernate.jdbc.ConnectionManager] (http--localhost-8080-17) forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?

      10:31:09,431 INFO  [stdout] (http--localhost-8080-17) Exception..!

      10:31:09,439 ERROR [stderr] (http--localhost-8080-17) java.lang.RuntimeException: Operation failed

      10:31:09,440 ERROR [stderr] (http--localhost-8080-17)   at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:1130)

      10:31:09,440 ERROR [stderr] (http--localhost-8080-17)   at org.jbpm.task.service.TaskServiceSession.getEntity(TaskServiceSession.java:1069)

      10:31:09,441 ERROR [stderr] (http--localhost-8080-17)   at org.jbpm.task.service.TaskServiceSession.getTask(TaskServiceSession.java:605)

      10:31:09,441 ERROR [stderr] (http--localhost-8080-17)   at org.jbpm.task.service.local.LocalTaskService.getTask(LocalTaskService.java:157)

       

      Exception2:-

      11:01:29,766 INFO  [org.hibernate.jdbc.ConnectionManager] (http--localhost-8080-14) forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?

      11:01:29,767 WARNING [org.hibernate.jdbc.AbstractBatcher] (http--localhost-8080-19) exception clearing maxRows/queryTimeout: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@2e63879b

              at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:151)

              at org.jboss.jca.adapters.jdbc.WrappedStatement.lock(WrappedStatement.java:88)

              at org.jboss.jca.adapters.jdbc.WrappedStatement.getMaxRows(WrappedStatement.java:515)

              at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298) [hibernate-core-3.6.9.Final.jar:]

              at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234) [hibernate-core-3.6.9.Final.jar:]

              at org.hibernate.loader.Loader.doQuery(Loader.java:854) [hibernate-core-3.6.9.Final.jar:]

              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) [hibernate-core-3.6.9.Final.jar:]

              at org.hibernate.loader.Loader.loadCollection(Loader.java:2166) [hibernate-core-3.6.9.Final.jar:]

       

      Thank for looking into this,

      Maria Prabudass