[rules-users] getting mismatched '==' error
Hi ! Please find my attached Decision Table. I am getting following error... log4j:WARN No appenders could be found for logger (com.sample.RuleRunner). log4j:WARN Please initialize the log4j system properly. Warning: Cell at E20 not present - adding a blank Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 - setting to empty Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 - setting to empty Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 - setting to empty Exception in thread main org.drools.rule.InvalidRulePackage: [10,9]: [ERR 102] Line 10:9 mismatched input '==' in rule Distribution Cost Rules_11 [23,9]: [ERR 102] Line 23:9 mismatched input '==' in rule Distribution Cost Rules_12 [36,9]: [ERR 102] Line 36:9 mismatched input '==' in rule Distribution Cost Rules_13 [49,9]: [ERR 102] Line 49:9 mismatched input '==' in rule Distribution Cost Rules_14 [62,9]: [ERR 102] Line 62:9 mismatched input '==' in rule Distribution Cost Rules_15 [75,9]: [ERR 102] Line 75:9 mismatched input '==' in rule Distribution Cost Rules_16 [88,9]: [ERR 102] Line 88:9 mismatched input '==' in rule Distribution Cost Rules_17 [101,9]: [ERR 102] Line 101:9 mismatched input '==' in rule Distribution Cost Rules_18 [114,9]: [ERR 102] Line 114:9 mismatched input '==' in rule Distribution Cost Rules_19 [127,9]: [ERR 102] Line 127:9 mismatched input '==' in rule Distribution Cost Rules_20 [140,9]: [ERR 102] Line 140:9 mismatched input '==' in rule Distribution Cost Rules_21 [153,9]: [ERR 102] Line 153:9 mismatched input '==' in rule Distribution Cost Rules_22 [166,9]: [ERR 102] Line 166:9 mismatched input '==' in rule Distribution Cost Rules_23 [179,9]: [ERR 102] Line 179:9 mismatched input '==' in rule Distribution Cost Rules_24 [192,9]: [ERR 102] Line 192:9 mismatched input '==' in rule Distribution Cost Rules_25 [205,9]: [ERR 102] Line 205:9 mismatched input '==' in rule Distribution Cost Rules_26 [218,9]: [ERR 102] Line 218:9 mismatched input '==' in rule Distribution Cost Rules_27 [231,9]: [ERR 102] Line 231:9 mismatched input '==' in rule Distribution Cost Rules_28 [244,9]: [ERR 102] Line 244:9 mismatched input '==' in rule Distribution Cost Rules_29 [257,9]: [ERR 102] Line 257:9 mismatched input '==' in rule Distribution Cost Rules_30 [270,9]: [ERR 102] Line 270:9 mismatched input '==' in rule Distribution Cost Rules_31 [283,9]: [ERR 102] Line 283:9 mismatched input '==' in rule Distribution Cost Rules_32 [296,9]: [ERR 102] Line 296:9 mismatched input '==' in rule Distribution Cost Rules_33 [309,9]: [ERR 102] Line 309:9 mismatched input '==' in rule Distribution Cost Rules_34 [0,0]: Parser returned a null Package at org.drools.rule.Package.checkValidity(Package.java:471) at org.drools.common.AbstractRuleBase.addPackages(AbstractRuleBase.java:481) at org.drools.reteoo.ReteooRuleBase.addPackages(ReteooRuleBase.java:436) at org.drools.reteoo.ReteooRuleBase.addPackage(ReteooRuleBase.java:443) at com.sample.RuleRunner.loadRules(RuleRunner.java:70) at com.sample.RuleRunner.runStatelessRules(RuleRunner.java:185) at com.sample.RuleMain.main(RuleMain.java:132) http://drools.46999.n3.nabble.com/file/n4017627/Distribution_Factor.xls Distribution_Factor.xls -- View this message in context: http://drools.46999.n3.nabble.com/getting-mismatched-error-tp4017627.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] getting mismatched '==' error
I suspect it is caused by the spreadsheet validations you have enabled for rows 19 onwards, columns E and F. Try removing these - as they look to be a hang-over from (presumably) basing the workbook on an existing example somewhere. On 29 May 2012 11:31, zeeshan zeeshan.spr...@gmail.com wrote: Hi ! Please find my attached Decision Table. I am getting following error... log4j:WARN No appenders could be found for logger (com.sample.RuleRunner). log4j:WARN Please initialize the log4j system properly. Warning: Cell at E20 not present - adding a blank Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 - setting to empty Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 - setting to empty Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 - setting to empty Exception in thread main org.drools.rule.InvalidRulePackage: [10,9]: [ERR 102] Line 10:9 mismatched input '==' in rule Distribution Cost Rules_11 [23,9]: [ERR 102] Line 23:9 mismatched input '==' in rule Distribution Cost Rules_12 [36,9]: [ERR 102] Line 36:9 mismatched input '==' in rule Distribution Cost Rules_13 [49,9]: [ERR 102] Line 49:9 mismatched input '==' in rule Distribution Cost Rules_14 [62,9]: [ERR 102] Line 62:9 mismatched input '==' in rule Distribution Cost Rules_15 [75,9]: [ERR 102] Line 75:9 mismatched input '==' in rule Distribution Cost Rules_16 [88,9]: [ERR 102] Line 88:9 mismatched input '==' in rule Distribution Cost Rules_17 [101,9]: [ERR 102] Line 101:9 mismatched input '==' in rule Distribution Cost Rules_18 [114,9]: [ERR 102] Line 114:9 mismatched input '==' in rule Distribution Cost Rules_19 [127,9]: [ERR 102] Line 127:9 mismatched input '==' in rule Distribution Cost Rules_20 [140,9]: [ERR 102] Line 140:9 mismatched input '==' in rule Distribution Cost Rules_21 [153,9]: [ERR 102] Line 153:9 mismatched input '==' in rule Distribution Cost Rules_22 [166,9]: [ERR 102] Line 166:9 mismatched input '==' in rule Distribution Cost Rules_23 [179,9]: [ERR 102] Line 179:9 mismatched input '==' in rule Distribution Cost Rules_24 [192,9]: [ERR 102] Line 192:9 mismatched input '==' in rule Distribution Cost Rules_25 [205,9]: [ERR 102] Line 205:9 mismatched input '==' in rule Distribution Cost Rules_26 [218,9]: [ERR 102] Line 218:9 mismatched input '==' in rule Distribution Cost Rules_27 [231,9]: [ERR 102] Line 231:9 mismatched input '==' in rule Distribution Cost Rules_28 [244,9]: [ERR 102] Line 244:9 mismatched input '==' in rule Distribution Cost Rules_29 [257,9]: [ERR 102] Line 257:9 mismatched input '==' in rule Distribution Cost Rules_30 [270,9]: [ERR 102] Line 270:9 mismatched input '==' in rule Distribution Cost Rules_31 [283,9]: [ERR 102] Line 283:9 mismatched input '==' in rule Distribution Cost Rules_32 [296,9]: [ERR 102] Line 296:9 mismatched input '==' in rule Distribution Cost Rules_33 [309,9]: [ERR 102] Line 309:9 mismatched input '==' in rule Distribution Cost Rules_34 [0,0]: Parser returned a null Package at org.drools.rule.Package.checkValidity(Package.java:471) at org.drools.common.AbstractRuleBase.addPackages(AbstractRuleBase.java:481) at org.drools.reteoo.ReteooRuleBase.addPackages(ReteooRuleBase.java:436) at org.drools.reteoo.ReteooRuleBase.addPackage(ReteooRuleBase.java:443) at com.sample.RuleRunner.loadRules(RuleRunner.java:70) at com.sample.RuleRunner.runStatelessRules(RuleRunner.java:185) at com.sample.RuleMain.main(RuleMain.java:132) http://drools.46999.n3.nabble.com/file/n4017627/Distribution_Factor.xls Distribution_Factor.xls -- View this message in context: http://drools.46999.n3.nabble.com/getting-mismatched-error-tp4017627.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] getting mismatched '==' error
Hi Mike ! Still getting the same error :( please find the attached file... log4j:WARN No appenders could be found for logger (com.sample.RuleRunner). log4j:WARN Please initialize the log4j system properly. Warning: Cell at E20 not present - adding a blank Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 - setting to empty Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 - setting to empty Warning: Cannot read name ranges for ClaimTypes - setting to empty Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 - setting to empty Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_2 - setting to empty Exception in thread main org.drools.rule.InvalidRulePackage: [10,9]: [ERR 102] Line 10:9 mismatched input '==' in rule Distribution Cost Rules_11 [23,9]: [ERR 102] Line 23:9 mismatched input '==' in rule Distribution Cost Rules_12 [36,9]: [ERR 102] Line 36:9 mismatched input '==' in rule Distribution Cost Rules_13 [49,9]: [ERR 102] Line 49:9 mismatched input '==' in rule Distribution Cost Rules_14 [62,9]: [ERR 102] Line 62:9 mismatched input '==' in rule Distribution Cost Rules_15 [75,9]: [ERR 102] Line 75:9 mismatched input '==' in rule Distribution Cost Rules_16 [88,9]: [ERR 102] Line 88:9 mismatched input '==' in rule Distribution Cost Rules_17 [101,9]: [ERR 102] Line 101:9 mismatched input '==' in rule Distribution Cost Rules_18 [114,9]: [ERR 102] Line 114:9 mismatched input '==' in rule Distribution Cost Rules_19 [127,9]: [ERR 102] Line 127:9 mismatched input '==' in rule Distribution Cost Rules_20 [140,9]: [ERR 102] Line 140:9 mismatched input '==' in rule Distribution Cost Rules_21 [153,9]: [ERR 102] Line 153:9 mismatched input '==' in rule Distribution Cost Rules_22 [166,9]: [ERR 102] Line 166:9 mismatched input '==' in rule Distribution Cost Rules_23 [179,9]: [ERR 102] Line 179:9 mismatched input '==' in rule Distribution Cost Rules_24 [192,9]: [ERR 102] Line 192:9 mismatched input '==' in rule Distribution Cost Rules_25 [205,9]: [ERR 102] Line 205:9 mismatched input '==' in rule Distribution Cost Rules_26 [218,9]: [ERR 102] Line 218:9 mismatched input '==' in rule Distribution Cost Rules_27 [231,9]: [ERR 102] Line 231:9 mismatched input '==' in rule Distribution Cost Rules_28 [244,9]: [ERR 102] Line 244:9 mismatched input '==' in rule Distribution Cost Rules_29 [257,9]: [ERR 102] Line 257:9 mismatched input '==' in rule Distribution Cost Rules_30 [270,9]: [ERR 102] Line 270:9 mismatched input '==' in rule Distribution Cost Rules_31 [283,9]: [ERR 102] Line 283:9 mismatched input '==' in rule Distribution Cost Rules_32 [296,9]: [ERR 102] Line 296:9 mismatched input '==' in rule Distribution Cost Rules_33 [309,9]: [ERR 102] Line 309:9 mismatched input '==' in rule Distribution Cost Rules_34 [0,0]: Parser returned a null Package at org.drools.rule.Package.checkValidity(Package.java:471) at org.drools.common.AbstractRuleBase.addPackages(AbstractRuleBase.java:481) at org.drools.reteoo.ReteooRuleBase.addPackages(ReteooRuleBase.java:436) at org.drools.reteoo.ReteooRuleBase.addPackage(ReteooRuleBase.java:443) at com.sample.RuleRunner.loadRules(RuleRunner.java:70) at com.sample.RuleRunner.runStatelessRules(RuleRunner.java:185) at com.sample.RuleMain.main(RuleMain.java:132) http://drools.46999.n3.nabble.com/file/n4017643/Distribution_Factor.xls Distribution_Factor.xls -- View this message in context: http://drools.46999.n3.nabble.com/getting-mismatched-error-tp4017627p4017643.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] getting mismatched '==' error
Here in first condition channel == $param so it's expecting string values but u r inserting numeric values -- View this message in context: http://drools.46999.n3.nabble.com/getting-mismatched-error-tp4017627p4017644.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] getting mismatched '==' error
I tried ur suggestion.still same error. :( I think I will have to create a new Excel file -- View this message in context: http://drools.46999.n3.nabble.com/getting-mismatched-error-tp4017627p4017655.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] getting mismatched '==' error
Your table seems correct, and writing a new one won't change the problem. But errors are reported according to the generated DRL, so it is hard to say which constraint is the problem. To generate the DRL, you can use SpreadsheetCompiler (or may be something more up-to-date?) like this : SpreadsheetCompiler compiler = new SpreadsheetCompiler(); String bigDrl = compiler.compile(new FileInputStream(xlsFile), InputType.XLS); Generate the DRL, then locate the error, then re-post here if the solution does not pops up by itself, or just to report back :) - Original Message - From: zeeshan zeeshan.spr...@gmail.com To: rules-users@lists.jboss.org Sent: Mardi 29 Mai 2012 14:03:40 Subject: Re: [rules-users] getting mismatched '==' error I tried ur suggestion.still same error. :( I think I will have to create a new Excel file -- View this message in context: http://drools.46999.n3.nabble.com/getting-mismatched-error-tp4017627p4017655.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] getting mismatched '==' error
Hi Vincent ! I solved the error by writing a new file :) may be some unseen error but it is not taking taking Policy Year more than 1. as i have given year values 2,99 separate rule and for 1 year separate rule. Thanks !! -- View this message in context: http://drools.46999.n3.nabble.com/getting-mismatched-error-tp4017627p4017659.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users