<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
java.lang.RuntimeException: Could not find session data for id 1
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/johnesky">Jo Blithe</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/617727#617727">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>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:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>org.apache.jasper.JasperException: An exception occurred processing JSP page /page2.jsp at line 106</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>103: </p><p>104:                     </p><p>105:                   int sessionid = 1;</p><p>106:                   StatefulKnowledgeSession ksession = JPAKnowledgeService.loadStatefulKnowledgeSession( sessionid, kbase, null, env );</p><p>107:             new JPAWorkingMemoryDbLogger(ksession);</p><p>108:                          </p><p>109:                KnowledgeRuntimeLoggerFactory.newConsoleLogger(ksession);</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Stacktrace:</p><p> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)</p><p> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:413)</p><p> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)</p><p> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)</p><p> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>root cause</strong> </p><pre class="jive-pre">java.lang.IllegalStateException: java.lang.reflect.InvocationTargetException<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:103)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)<br/>     org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)<br/>     org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)<br/>     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/>     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br/>     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br/>     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>root cause</strong> </p><pre class="jive-pre">java.lang.reflect.InvocationTargetException<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br/>     sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br/>     java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)<br/>     org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)<br/>     org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)<br/>     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/>     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br/>     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br/>     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>root cause</strong> </p><pre class="jive-pre">java.lang.RuntimeException: Could not find session data for id 1<br/>     org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:178)<br/>     org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br/>     sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br/>     java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)<br/>     org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)<br/>     org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)<br/>     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/>     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br/>     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br/>     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>root cause</strong> </p><pre class="jive-pre">javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.drools.persistence.info.SessionInfo#1]<br/>     org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)<br/>     org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:202)<br/>     org.drools.persistence.jpa.JpaPersistenceContext.findSessionInfo(JpaPersistenceContext.java:21)<br/>     org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:176)<br/>     org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br/>     sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br/>     java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)<br/>     org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)<br/>     org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)<br/>     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/>     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br/>     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br/>     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>root cause</strong> </p><pre class="jive-pre">org.hibernate.exception.GenericJDBCException: could not load an entity: [org.drools.persistence.info.SessionInfo#1]<br/>     org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)<br/>     org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)<br/>     org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)<br/>     org.hibernate.loader.Loader.loadEntity(Loader.java:1895)<br/>     org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)<br/>     org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)<br/>     org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3072)<br/>     org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:434)<br/>     org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:415)<br/>     org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:165)<br/>     org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)<br/>     org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)<br/>     org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:905)<br/>     org.hibernate.impl.SessionImpl.get(SessionImpl.java:842)<br/>     org.hibernate.impl.SessionImpl.get(SessionImpl.java:835)<br/>     org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182)<br/>     org.drools.persistence.jpa.JpaPersistenceContext.findSessionInfo(JpaPersistenceContext.java:21)<br/>     org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:176)<br/>     org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br/>     sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br/>     java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)<br/>     org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)<br/>     org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)<br/>     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/>     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br/>     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br/>     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>root cause</strong> </p><pre class="jive-pre">org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.<br/>     org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:200)<br/>     org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:172)<br/>     org.postgresql.jdbc2.AbstractJdbc2BlobClob.<init>(AbstractJdbc2BlobClob.java:47)<br/>     org.postgresql.jdbc2.AbstractJdbc2Blob.<init>(AbstractJdbc2Blob.java:21)<br/>     org.postgresql.jdbc3.AbstractJdbc3Blob.<init>(AbstractJdbc3Blob.java:19)<br/>     org.postgresql.jdbc3.Jdbc3Blob.<init>(Jdbc3Blob.java:20)<br/>     org.postgresql.jdbc3.Jdbc3ResultSet.getBlob(Jdbc3ResultSet.java:52)<br/>     org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:338)<br/>     org.hibernate.type.ByteArrayBlobType.get(ByteArrayBlobType.java:87)<br/>     org.hibernate.type.AbstractLobType.nullSafeGet(AbstractLobType.java:46)<br/>     org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)<br/>     org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2124)<br/>     org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)<br/>     org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)<br/>     org.hibernate.loader.Loader.getRow(Loader.java:1230)<br/>     org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)<br/>     org.hibernate.loader.Loader.doQuery(Loader.java:724)<br/>     org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)<br/>     org.hibernate.loader.Loader.loadEntity(Loader.java:1881)<br/>     org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)<br/>     org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)<br/>     org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3072)<br/>     org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:434)<br/>     org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:415)<br/>     org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:165)<br/>     org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)<br/>     org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)<br/>     org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:905)<br/>     org.hibernate.impl.SessionImpl.get(SessionImpl.java:842)<br/>     org.hibernate.impl.SessionImpl.get(SessionImpl.java:835)<br/>     org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182)<br/>     org.drools.persistence.jpa.JpaPersistenceContext.findSessionInfo(JpaPersistenceContext.java:21)<br/>     org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:176)<br/>     org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/>     sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br/>     sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br/>     java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)<br/>     org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)<br/>     org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)<br/>     org.apache.jsp.page2_jsp._jspService(page2_jsp.java:199)<br/>     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/>     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br/>     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br/>     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br/>     javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/></pre></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/617727#617727">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>