[jboss-user] [jBPM] - java.lang.RuntimeException: Could not find session data for id 1

Jo Blithe [http://community.jboss.org/people/johnesky] created the discussion "java.lang.RuntimeException: Could not find session data for id 1" To view the discussion, visit: http://community.jboss.org/message/617727#617727 -------------------------------------------------------------- I have my process uncompleted on the task table in my jbpm database and I also have the sessioninfo table in my jbpm database filled with a row and the id-column of integer 1. I was thinking the session id data is on the id column on the sessioninfo table and I was trying to recreate a new session to continue my process but I keep getting this error 106: org.apache.jasper.JasperException: An exception occurred processing JSP page /page2.jsp at line 106 103: 104:                     105:                   int sessionid = 1; 106:                   StatefulKnowledgeSession ksession = JPAKnowledgeService.loadStatefulKnowledgeSession( sessionid, kbase, null, env ); 107:             new JPAWorkingMemoryDbLogger(ksession); 108:                          109:                KnowledgeRuntimeLoggerFactory.newConsoleLogger(ksession); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:413) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) *root cause* java.lang.IllegalStateException: java.lang.reflect.InvocationTargetException      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:103)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)      org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)      org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717)      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717) *root cause* java.lang.reflect.InvocationTargetException      sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)      sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)      sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)      java.lang.reflect.Constructor.newInstance(Constructor.java:513)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)      org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)      org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717)      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717) *root cause* java.lang.RuntimeException: Could not find session data for id 1      org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:178)      org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)      sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)      sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)      sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)      java.lang.reflect.Constructor.newInstance(Constructor.java:513)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)      org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)      org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717)      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717) *root cause* javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.drools.persistence.info.SessionInfo#1]      org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)      org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:202)      org.drools.persistence.jpa.JpaPersistenceContext.findSessionInfo(JpaPersistenceContext.java:21)      org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:176)      org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)      sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)      sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)      sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)      java.lang.reflect.Constructor.newInstance(Constructor.java:513)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)      org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)      org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717)      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717) *root cause* org.hibernate.exception.GenericJDBCException: could not load an entity: [org.drools.persistence.info.SessionInfo#1]      org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)      org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)      org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)      org.hibernate.loader.Loader.loadEntity(Loader.java:1895)      org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)      org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)      org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3072)      org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:434)      org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:415)      org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:165)      org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)      org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)      org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:905)      org.hibernate.impl.SessionImpl.get(SessionImpl.java:842)      org.hibernate.impl.SessionImpl.get(SessionImpl.java:835)      org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182)      org.drools.persistence.jpa.JpaPersistenceContext.findSessionInfo(JpaPersistenceContext.java:21)      org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:176)      org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)      sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)      sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)      sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)      java.lang.reflect.Constructor.newInstance(Constructor.java:513)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)      org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)      org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717)      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717) *root cause* org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.      org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:200)      org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:172)      org.postgresql.jdbc2.AbstractJdbc2BlobClob.<init>(AbstractJdbc2BlobClob.java:47)      org.postgresql.jdbc2.AbstractJdbc2Blob.<init>(AbstractJdbc2Blob.java:21)      org.postgresql.jdbc3.AbstractJdbc3Blob.<init>(AbstractJdbc3Blob.java:19)      org.postgresql.jdbc3.Jdbc3Blob.<init>(Jdbc3Blob.java:20)      org.postgresql.jdbc3.Jdbc3ResultSet.getBlob(Jdbc3ResultSet.java:52)      org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:338)      org.hibernate.type.ByteArrayBlobType.get(ByteArrayBlobType.java:87)      org.hibernate.type.AbstractLobType.nullSafeGet(AbstractLobType.java:46)      org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)      org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2124)      org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)      org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)      org.hibernate.loader.Loader.getRow(Loader.java:1230)      org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)      org.hibernate.loader.Loader.doQuery(Loader.java:724)      org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)      org.hibernate.loader.Loader.loadEntity(Loader.java:1881)      org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)      org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)      org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3072)      org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:434)      org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:415)      org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:165)      org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)      org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)      org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:905)      org.hibernate.impl.SessionImpl.get(SessionImpl.java:842)      org.hibernate.impl.SessionImpl.get(SessionImpl.java:835)      org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182)      org.drools.persistence.jpa.JpaPersistenceContext.findSessionInfo(JpaPersistenceContext.java:21)      org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:176)      org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)      sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)      sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)      sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)      java.lang.reflect.Constructor.newInstance(Constructor.java:513)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)      org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)      org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)      org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717)      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)      javax.servlet.http.HttpServlet.service(HttpServlet.java:717) -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/617727#617727] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]