<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">There is no easy way to deal with this in 5.5, other than importing and exporting. The problem no longer exists in 6.x, as we now use GIT.<div><br></div><div>Mark<br><div><div>On 9 Feb 2014, at 15:30, Demian Calcaprina <<a href="mailto:calcacuervo@gmail.com">calcacuervo@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">Hi Guys,<div><br></div><div>I am using Guvnor 5.5. For moving packages between environments, I am doing an export, and then import in the new package. I have a lof of assets in each package. I am using the DB storage for the jcr repository.</div>
<div><br></div><div style="">After some months, the DB has grown a LOT! (like 3.5GB).</div><div style=""><br></div><div style="">Is there a way regularly clean the JCR history, or maybe disable JCR history as we are not using it at all?</div>
<div style=""><br></div><div style="">These are the steps I did to remove the history and seems to work fine. Does is seem safe? Is there a better way?</div><div style=""><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
1.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Export the entire repository via guvor.<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
<u></u>2.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Delete all the packages.<u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
<u></u>3.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Stop tomact<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><u></u>4.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>“truncate” the following guvnor tables:<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>a.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Pm_ws_default_binval<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>b.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Pm_ws_default_bundel<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>c.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Versioning_pm_binval<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>d.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Versioning_pm_bundle<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><u></u>5.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Restated tomcat</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
6.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Import what I exported on step #1</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><br></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">Thanks!</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><br></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
Demian</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><u></u></p><div><br></div></div></div>
_______________________________________________<br>rules-users mailing list<br><a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>https://lists.jboss.org/mailman/listinfo/rules-users</blockquote></div><br></div></body></html>