<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;">try increasing your perm gen space.<div><br></div><div>Mark<br><div><div>On 16 Aug 2014, at 04:11, Jan Rose <<a href="mailto:ufos@comcast.net">ufos@comcast.net</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="EN-US" link="#0563C1" vlink="#954F72" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div class="WordSection1" style="page: WordSection1;"><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">Would like some advice regarding using Decision Tables in DROOLS 5.6.0 Final. We have decision tables with over 12,000 rows. It is a basic ‘look-up’ table with 3 conditions and 2 actions. The conditions are, for example: Company = X Dept = X Class = X then value = X and log X. When I reduced the number of rows to approx. 500 . .. it works.<o:p></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">I have set the max memory in the JVM to 2 gigs. We have tried compiling the decision tables using the spreadsheet compiler as well as the decision table compiler.<o:p></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">Below is the error when using the decision table compiler. However, we get the same PermGen space error with the spreadsheet compiler.<o:p></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">Obviously, we need to be able to have more than 500 rows in our decision table(s). Any advice would be appreciated.<o:p></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 10pt; font-family: Consolas; color: red;">Aug 14, 2014 6:33:09 PM com.macys.test.rules.engine.AttribDecisionTbl main</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">INFO: found<span class="Apple-converted-space"> </span></span><a href="file:///c:/attribute-data.xls" style="color: rgb(149, 79, 114); text-decoration: underline;"><span style="font-size: 10pt; font-family: Consolas; color: red;">file:c:\attribute-data.xls</span></a><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">Aug 14, 2014 6:33:10 PM com.macys.test.test_drools.RuleRunner loadRules</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">INFO: Loading file: log-rules.drl</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">Aug 14, 2014 6:33:10 PM com.macys.test.test_drools.RuleRunner loadRuleFile</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">INFO: found rule<span class="Apple-converted-space"> </span></span><a href="file://///log-rules.drl" style="color: rgb(149, 79, 114); text-decoration: underline;"><span style="font-size: 10pt; font-family: Consolas; color: red;">file:log-rules.drl</span></a><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">Aug 14, 2014 6:33:11 PM com.macys.test.test_drools.RuleRunner loadRules</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">INFO: Loading file: AttributeRules-MDSLife-V1.xls</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">Aug 14, 2014 6:33:11 PM com.macys.test.test_drools.RuleRunner loadExcelRules</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">INFO: found<span class="Apple-converted-space"> </span></span><a href="file://///AttributeRules-MDSLife-V1.xls" style="color: rgb(149, 79, 114); text-decoration: underline;"><span style="font-size: 10pt; font-family: Consolas; color: red;">file:AttributeRules-MDSLife-V1.xls</span></a><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;">Exception in thread "main" java.lang.OutOfMemoryError: PermGen space</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at java.lang.ClassLoader.defineClass1(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">Native Method</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at java.lang.ClassLoader.defineClass(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">ClassLoader.java:800</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.rule.JavaDialectRuntimeData$PackageClassLoader.fastFindClass(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">JavaDialectRuntimeData.java:624</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.util.CompositeClassLoader$CachingLoader.load(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">CompositeClassLoader.java:254</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.util.CompositeClassLoader$CachingLoader.load(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">CompositeClassLoader.java:237</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.util.CompositeClassLoader.loadClass(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">CompositeClassLoader.java:88</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at java.lang.ClassLoader.loadClass(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">ClassLoader.java:358</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.rule.JavaDialectRuntimeData.wire(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">JavaDialectRuntimeData.java:434</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.rule.JavaDialectRuntimeData.wire(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">JavaDialectRuntimeData.java:429</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.rule.JavaDialectRuntimeData.onBeforeExecute(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">JavaDialectRuntimeData.java:257</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.rule.DialectRuntimeRegistry.onBeforeExecute(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">DialectRuntimeRegistry.java:139</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.compiler.PackageBuilder.reloadAll(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">PackageBuilder.java:1202</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.compiler.PackageBuilder.compileAllRules(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">PackageBuilder.java:951</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.compiler.PackageBuilder.addPackage(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">PackageBuilder.java:938</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.compiler.PackageBuilder.addPackageFromDecisionTable(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">PackageBuilder.java:451</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.compiler.PackageBuilder.addKnowledgeResource(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">PackageBuilder.java:715</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at org.drools.builder.impl.KnowledgeBuilderImpl.add(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">KnowledgeBuilderImpl.java:51</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at com.macys.test.test_drools.RuleRunner.loadExcelRules(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">RuleRunner.java:161</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at com.macys.test.test_drools.RuleRunner.loadRules(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">RuleRunner.java:53</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at com.macys.test.test_drools.RuleRunner.runStatelessRules(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">RuleRunner.java:217</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><span style="font-size: 10pt; font-family: Consolas; color: red;"> at com.macys.test.rules.engine.AttribDecisionTbl.main(</span><u><span style="font-size: 10pt; font-family: Consolas; color: rgb(0, 98, 225);">AttribDecisionTbl.java:99</span></u><span style="font-size: 10pt; font-family: Consolas; color: red;">)</span><span class="Apple-converted-space"> </span><br><br><br><o:p></o:p></div></div>_______________________________________________<br>rules-users mailing list<br><a href="mailto:rules-users@lists.jboss.org" style="color: rgb(149, 79, 114); text-decoration: underline;">rules-users@lists.jboss.org</a><br><a href="https://lists.jboss.org/mailman/listinfo/rules-users" style="color: rgb(149, 79, 114); text-decoration: underline;">https://lists.jboss.org/mailman/listinfo/rules-users</a></div></blockquote></div><br></div></body></html>