1 Reply Latest reply on Apr 10, 2008 4:12 PM by kukeltje

    Couldn't find ProcessDefinition or load Process Instance by

    bloreguy

      I am using Jbpm 3.2.2 with Jboss 4.2.2 with MSSQL with JTS Drivers.

      Worked perfectly with MYSQL with no issues and see error when migrated to MSSQL/JTS Drivers

      Very sporadically and with increasing frequency, I see this error:

      COuldn't find ProcessDefinition on this call:

      graphSession.findLatestProcessDefinition("testSystem");

      Couldn;t load ProcessInstance of id '128' with this call:
      jbpmContext.loadProcessInstance(128);

      If I restart the server, the same call works and all data is present in the database.

      Any pointers deeply appreciated. Basically, need help in determining how to isolate and debug this error. Is the session really closed? if so, how do I determine what caused the session to close?

      Exception:
      22:44:33,598 ERROR [STDERR] org.hibernate.SessionException: Session is closed!
      at org.hibernate.impl.AbstractSessionImpl.errorIfClosed(AbstractSessionImpl.java:49)
      at org.hibernate.impl.SessionImpl.getNamedQuery(SessionImpl.java:1258)
      at org.hibernate.search.impl.FullTextSessionImpl.getNamedQuery(FullTextS
      essionImpl.java:529)
      at org.jboss.seam.persistence.HibernateSessionProxy.getNamedQuery(HibernateSessionProxy.java:235)
      at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:150)
      --------------
      22:44:33,937 ERROR [GraphSession] org.hibernate.SessionException: Session is closed!
      22:44:33,944 ERROR [STDERR] org.jbpm.JbpmException: couldn't find process definition 'testSystem'
      22:44:33,949 ERROR [STDERR] at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:170)

      22:44:34,289 ERROR [STDERR] Caused by: org.hibernate.SessionException: Session is closed!
      22:44:34,292 ERROR [STDERR] at org.hibernate.impl.AbstractSessionImpl.errorIfClosed(AbstractSessionImpl.java:49)
      22:44:34,295 ERROR [STDERR] at org.hibernate.impl.SessionImpl.getNamedQuery(SessionImpl.java:1258)
      22:44:34,298 ERROR [STDERR] at org.hibernate.search.impl.FullTextSessionImpl
      .getNamedQuery(FullTextSessionImpl.java:529)
      22:44:34,301 ERROR [STDERR] at org.jboss.seam.persistence.HibernateSessionProxy.getNamedQuery(HibernateSessionProxy.java:235)
      22:44:34,304 ERROR [STDERR] at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:150)