<!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="https://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;">
JPAWorkingMemoryDbLogger issue on server restart
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/proteus">Proteus Hades</a> in <i>jBPM Development</i> - <a href="https://community.jboss.org/message/778787#778787">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi,</p><p>I'm using jpbm5.2 in my project which involves few User Tasks.  I have created different methods to start and load the knowledge session and also to start and complete the user task.</p><p>I'm using the JPAWorkingMemoryDbLogger to log the entering and exiting of the nodes in the log tables. The logger is initialized when ever the StatefulKnowledgeSession is created or loaded. </p><p>           </p><p><em>          //load the knowledge session.</em></p><p><em>           ksession = Configuration.loadKSession(ksessionId,</em></p><p><em>                    myJbpm.getMyEmfPersistence(),</em></p><p><em>                    myJbpm.getMyKnowledgeBase());</em></p><p><em><br/></em></p><p><em>  // Initialize logger to enter values in log table</em></p><p><em> JPAWorkingMemoryDbLogger myJpaLogger = new JPAWorkingMemoryDbLogger(</em><em>ksession);</em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The knowledge session & process instance id created is stored in project's database, so that whenever a user log in I could get the process info and load it.</p><p>Now the problem is whenever the tomcat server restarts and the knowledge session is loaded and the process continued, entries are not made in the log tables, but Task table has proper entries.</p><p>When checked at the console for sql queries, whenever the tomcat restarts the 'insert into nodeinstancelog...' statements are missing.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>My project's working depends on the data in nodeinstancelog table which I query to check where the process has reached.  So although the process has moved forward the nodeinstancelog do not have entries. Thereby crashing the whole application.</p><p>This occurs only when the tomcat restarts- which occurs quite a few times where the project is intended to be deployed.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The logger is giving me a hard time... kindly help.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/778787#778787">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM Development at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2035">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>