<!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;">
Re: Archiving Data in JBPM tables
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/eschabell">Eric D. Schabell</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/622966#622966">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 Art,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>It is standard functionality in jBPM3 that all completed processes (history information) remains in the database. It is stated in the docs (enterprise docs) that you need to decide within your organization what you want to do with this, something like this:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>- don't care about old history, just remove/delete.</p><p>- have BAM reporting in place so have to keep, then migrate out to a different format/location/db to allow for continued reporting.</p><p>- apply enterprise process (for example, I worked in an enterprise that applied data warehousing techniques) to collect and store for reporting all history data</p><p>- leave it in place, but be prepared to eventually have to enlarge your DB machine! ;-)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>That about covers it. I looked at your doc, but I am not sure anymore exactly what you all can clean out of your tables. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Regards, erics</p></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/622966#622966">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>