How to validate literal values on the LHS of rules.
by groovenarula
Hello all,
In my use case, I am planning on using decision tables to implement rules
that contain product information (product attributes - like product grade,
product style etc). I've managed to put together the spreadsheet and have
been successful in generating different set of rules (using rule templates)
from this spreadsheet. The spreadsheet with contain basic product
information that product fact will be matched against.
e.g. The spreadsheet will contain columns of product grade and product
styles that when translated into rules, the LHS would look something like
Product ( grade == "010", style == "515" )
Where the '010' and '515' would come from a spreadsheet (decision table)
that the user's provide.
Now here's the challenge. I need to also provide a means for the user to
validate the "010" and "515". The available product grade and styles are
available in a database table. So I should be able to use that to build
second set of rules (templates). So I'm thinking, if there's a way to
convert the user supplied spreadsheet and make it a table of 'facts' of the
validation rules, I should be able to verify the value "010" "515" against
the database.
Is that the best way to go about this ? If so, can someone please point me
to a way to load facts from a spreadsheet ? I have looked around and found
that there is a jxls project that allows loading of JavaBeans from values in
spreadsheet. But it requires xml files to be configured. I really like the
way rule templates work (by simply state substitution variables in the
template itself - thereby avoiding the whole need to configuration xml
files). I think if there's a way to load facts using templates from a
spreadsheet, I should be able to use that concept to validate the values in
my rules.
So is it possible to do the above ? Also is there a better way ?
Any insight would be appreciated.
Thanks in advance,
Gurvinder
--
View this message in context: http://drools-java-rules-engine.46999.n3.nabble.com/How-to-validate-liter...
Sent from the Drools - User mailing list archive at Nabble.com.
15 years, 1 month
How to specify relative URL in chagenset.xml file
by Pardeep Ruhil
Hi,
I am getting File Not Found Exception when I try to give relative path of the file.
<resource source='file:../HelloWorld.drl' type='DRL' />
But when I give the complete path, It picks the changeset.xml file.
<resource source='file:C:/Tomcat/webapps/DroolsCheck/HelloWorld.drl' type='DRL' />
Please tell me the syntax for using the relative path for my workflow or rule files.
Thanks & Regards
Pradeep Ruhil
________________________________
This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.
______________________________________________________________________
15 years, 1 month
Drools Logging
by Laks Sundararajan
Hello There,
I'm using Drools as a part of my current project and have a few questions. I
subscribed to the forums and posted a new question but it keeps showing up
as pending.
Do I need to do anything else from my side?
Thanks!
15 years, 1 month
Re: [rules-users] Agenda group in excel
by FrankVhh
Hi all,
Let me tune in on this old post.
Is AGENDA-GROUP still unavailable in excel decision tables (V5.1)? The user
manual suggests it should be possible, but when I try it, it doesn't seem to
work.
In the same row as CONDITION, PRIORITY and ACTION, I named one of the
columns AGENDA-GROUP. Then, I filled up the column with names for the
groups.
In another decision table, I called drools.setFocus("$param"); underneath
ACTION to switch agendagroups.
Moreover, the spreadsheetcompiler returns priority as a salience attribute
in each rule, agenda-group can't be found in the outputs.
Regards,
Frank
--
View this message in context: http://drools-java-rules-engine.46999.n3.nabble.com/Agenda-group-in-excel...
Sent from the Drools - User mailing list archive at Nabble.com.
15 years, 1 month
Two instances of drools-guvnor can point to same database?
by Sartaj Shaik
Hi,
Can we deploy guvnor in two instances of jboss server pointing to same
oracle database?
Do we need to modify any settings to use same database by all the
instances?
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
15 years, 1 month
Unable to start drools-server 5.1.1 or 5.2.0.M1 under Tomcat 6.0.30
by A R
Hi,
I don't seem to be able to get the drools server (5.1.1 or 5.2.0.M1) to
startup correctly under Tomcat 6.0.30.
Here are the steps I've taken:
1) cp drools-5.1.1-server.war to my webapps directory
2) deleted servlet-api-2.3.jar due to a conflict with tomcat's
servrlet-api.jar
3) On startup however I get the following error in the logs (same error for
5.2.0.M1):
org.springframework.beans.factory.parsing.BeanDefinitionParsingException:
Configuration problem: Failed to import bean definitions from URL location
[classpath:knowledge-services.xml]
Offending resource: class path resource [beans.xml]; nested exception is
org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line
25 in XML document from class path resource [knowledge-services.xml] is
invalid; nested exception is org.xml.sax.SAXParseException:
cvc-complex-type.2.4.c: The matching wildcard is strict, but no declaration
can be found for element 'drools:execution-node'.
Where line 25 in the knowledge-services.xml file is:
<drools:execution-node id="node1" />
Full stack trace is here:
http://pastebin.com/Dweg29gJ
Any help appreciated.
Thanks!
15 years, 1 month
Converging gateway
by Salina Fung/UFL - ICIL
I have a flow as attached.
Before the Exit node, I have the Converging gateway with type = 'AND',
and before that, I have 2 human task:
1. Receive Cargo (Task 3)
2. Request for Approval
I don't understand why when I complete the Receive Cargo Task, I get the following
debug message in Eclipse Console, why I got the 'Request for Approval' task exit debug
message?
<<quote>>
Task completed 3
[2011:03:64 19:03:229:debug] Message receieved on client : EventTriggerResponse
[2011:03:64 19:03:230:debug] Arguments : [org.drools.task.event.EventPayload@1c52ac68]
Task completed 3
[2011:03:64 19:03:231:debug] Message receieved on client : GetTaskResponse
[2011:03:64 19:03:231:debug] Arguments : [org.drools.task.Task@1524adef]
[2011:03:64 19:03:245:debug] Message receieved on client : GetTaskResponse
[2011:03:64 19:03:245:debug] Arguments : [org.drools.task.Task@1524adef]
[2011:03:64 19:03:264:debug] Message receieved on client : GetTaskResponse
[2011:03:64 19:03:264:debug] Arguments : [org.drools.task.Task@1524adef]
[2011:03:64 19:03:267:debug] Message receieved on client : GetContentResponse
[2011:03:64 19:03:267:debug] Arguments : [org.drools.task.Content@fbfe1674]
Exiting 'Request for Approval' - status = [ON_HOLD]
Exiting 'Request for Approval' - booking status = [ON_HOLD]
AFTER REQUEST FOR APPROVAL
Exiting from warehouse
AFTER WAREHOUSE
Hibernate: select processins0_.InstanceId as col_0_0_ from ProcessInstanceInfo processins0_ where ? in (select eventtypes1_.element from EventTypes eventtypes1_ where processins0_.InstanceId=eventtypes1_.InstanceId)
[2011:03:64 19:03:273:debug] Message receieved on client : GetContentResponse
[2011:03:64 19:03:273:debug] Arguments : [org.drools.task.Content@fbfe1674]
Hibernate: select workitemin0_.workItemId as workItemId7_0_, workitemin0_.creationDate as creation2_7_0_, workitemin0_.externalVariables as external3_7_0_, workitemin0_.name as name7_0_, workitemin0_.processInstanceId as processI5_7_0_, workitemin0_.state as state7_0_, workitemin0_.OPTLOCK as OPTLOCK7_0_, workitemin0_.workItemByteArray as workItem8_7_0_ from WorkItemInfo workitemin0_ where workitemin0_.workItemId=?
[2011:03:64 19:03:307:debug] Message receieved on client : GetContentResponse
[2011:03:64 19:03:307:debug] Arguments : [org.drools.task.Content@fbfe1674]
Hibernate: select workitemin0_.workItemId as workItemId7_0_, workitemin0_.creationDate as creation2_7_0_, workitemin0_.externalVariables as external3_7_0_, workitemin0_.name as name7_0_, workitemin0_.processInstanceId as processI5_7_0_, workitemin0_.state as state7_0_, workitemin0_.OPTLOCK as OPTLOCK7_0_, workitemin0_.workItemByteArray as workItem8_7_0_ from WorkItemInfo workitemin0_ where workitemin0_.workItemId=?
<end quote>>
Then if I complete the 'Request for Approval' task, no debugging message from the
exiting action of the task, but only the below, and the flow does not end?
<quoted>
[2011:03:64 19:03:306:debug] Message receieved on client : EventTriggerResponse
[2011:03:64 19:03:306:debug] Arguments : [org.drools.task.event.EventPayload@1b2dd1b8]
Task completed 2
[2011:03:64 19:03:324:debug] Message receieved on client : EventTriggerResponse
[2011:03:64 19:03:324:debug] Arguments : [org.drools.task.event.EventPayload@51cfc277]
Task completed 2
[2011:03:64 19:03:326:debug] Message receieved on client : EventTriggerResponse
[2011:03:64 19:03:326:debug] Arguments : [org.drools.task.event.EventPayload@50a6023a]
Task completed 2
[2011:03:64 19:03:328:debug] Message receieved on client : GetTaskResponse
[2011:03:64 19:03:328:debug] Arguments : [org.drools.task.Task@7972f798]
[2011:03:64 19:03:346:debug] Message receieved on client : GetTaskResponse
[2011:03:64 19:03:346:debug] Arguments : [org.drools.task.Task@7972f798]
[2011:03:64 19:03:362:debug] Message receieved on client : GetTaskResponse
[2011:03:64 19:03:362:debug] Arguments : [org.drools.task.Task@7972f798]
[2011:03:64 19:03:365:debug] Message receieved on client : GetContentResponse
[2011:03:64 19:03:365:debug] Arguments : [org.drools.task.Content@37a4cf8d]
<<end quote>>
I did the reverse, complete 'Request for Approval' first, and then 'Receive cargo',
the same result.
I tried XOR, Discriminator, seems they are the same. Please help
Thanks
Salina
15 years, 1 month
recovery from unclean Guvnor shutdown..
by Tharakesh Siddalingaiah
Hi folks,
The unix host that our Guvnor instance ran on was shutdown without first
shutting down Guvnor.
When I restarted Guvnor after the host came back up, I got the message: "This
looks like a brand new repository. Would you like to install a sample
repository?"
Has anyone else experienced this problem?
Any pointers on how to recovery would be greatly appreciated.
I do have an xml export of the repository that I can use if all else fails.
But I would prefer to recover the existing database so that I can retain the
history and the latest changes.
Thank you for your assistance.
-tk
-------------------------
Guvnor version: 5.0.0.SNAPSHOT 25673M
JBoss: Release ID: JBoss [Trinity] 4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA
date=200807181417)
JDK: Java version: 1.6.0_20,Sun Microsystems Inc.
OS: SunOS <hostname> 5.10 Generic_142900-12 sun4v sparc SUNW,T5240
We are using SQL Server as the repository (see repository.xml below)
When I check the database I see the following tables and row counts:
VERSION_BINVAL 0
VERSION_NODE 13836
VERSION_PROP 66436
VERSION_REFS 3324
Repository.xml content:
<?xml version="1.0"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit
1.4//EN"
"
http://jackrabbit.apache.org/dtd/repository-1.4.dtd">
<!-- Example Repository Configuration File -->
<Repository>
<!--
virtual file system where the repository stores global state
(e.g. registered namespaces, custom node types, etc.)
-->
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/repository"/>
</FileSystem>
<!--
security configuration
-->
<Security appName="Jackrabbit">
<!--
access manager:
class: FQN of class implementing the AccessManager interface
-->
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
<!-- <param name="config" value="${rep.home}/access.xml"/> -->
</AccessManager>
<LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<!-- anonymous user name ('anonymous' is the default value) -->
<!-- <param name="anonymousId" value="anonymous"/> -->
<!--
default user name to be used instead of the anonymous user
when no login credentials are provided (unset by default)
-->
<!-- <param name="defaultUserId" value="superuser"/> -->
</LoginModule>
</Security>
<!--
location of workspaces root directory and name of default workspace
-->
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default"/>
<!--
workspace configuration template:
used to create the initial workspace if there's no workspace yet
-->
<Workspace name="${wsp.name}">
<!--
virtual file system of the workspace:
class: FQN of class implementing the FileSystem interface
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}"/>
</FileSystem>
<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager interface
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="user" value="<dbuser>"/>
<param name="password" value="<dbpassword>"/>
<param name="schema" value="mssql"/>
<param name="url"
value="jdbc:sqlserver://<sqlserver_host>:<sqlserver_port>"/>
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
</PersistenceManager>
<!--
Search index and the file system it uses.
class: FQN of class implementing the QueryHandler interface
-->
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index"/>
<param name="textFilterClasses"
value="org.apache.jackrabbit.extractor.MsWordTextExtractor,org.apache.jackrabbit.extractor.MsExcelTextExtractor,org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,org.apache.jackrabbit.extractor.PdfTextExtractor,org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,org.apache.jackrabbit.extractor.RTFTextExtractor,org.apache.jackrabbit.extractor.HTMLTextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"/>
<param name="extractorPoolSize" value="2"/>
<param name="supportHighlighting" value="true"/>
</SearchIndex>
</Workspace>
<!--
Configures the versioning
-->
<Versioning rootPath="${rep.home}/version">
<!--
Configures the filesystem to use for versioning for the respective
persistence manager
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/version" />
</FileSystem>
<!--
Configures the persistence manager to be used for persisting
version state.
Please note that the current versioning implementation is based on
a 'normal' persistence manager, but this could change in future
implementations.
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
<param name="url" value="jdbc:derby:$
{rep.home}/version/db;create=true"/>
<param name="schemaObjectPrefix" value="version_"/>
</PersistenceManager>
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="user" value="<dbuser>"/>
<param name="password" value="<dbpassword>"/>
<param name="schema" value="mssql"/>
<param name="url"
value="jdbc:sqlserver://<sqlserver_host>:<sqlserver_port>"/>
<param name="schemaObjectPrefix" value="version_"/>
</PersistenceManager>
</Versioning>
<!--
Search index for content that is shared repository wide
(/jcr:system tree, contains mainly versions)
-->
<SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${rep.home}/repository/index"/>
<param name="textFilterClasses"
value="org.apache.jackrabbit.extractor.MsWordTextExtractor,org.apache.jackrabbit.extractor.MsExcelTextExtractor,org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,org.apache.jackrabbit.extractor.PdfTextExtractor,org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,org.apache.jackrabbit.extractor.RTFTextExtractor,org.apache.jackrabbit.extractor.HTMLTextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"/>
<param name="extractorPoolSize" value="2"/>
<param name="supportHighlighting" value="true"/>
</SearchIndex>
</Repository>
Tharakesh Siddalingaiah
Solution Architect Tel: +1 (410) 895 5275
GTO GIS Core Banking - PWM IT Mob: +1 (410) 905 2169
US tharakesh.siddalingaiah(a)db.com
Deutsche Bank AG
---
This communication may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this communication
in error) please notify the sender immediately and destroy this
communication. Any unauthorized copying, disclosure or distribution of the
material in this communication is strictly forbidden.
Deutsche Bank does not render legal or tax advice, and the information
contained in this communication should not be regarded as such.
15 years, 1 month
Problem creating package - validateUniqueRuleNames(PackageBuilder.java:830)
by Saleem Lakhani
Following is my code:
KnowledgeBuilderConfiguration kbc =
KnowledgeBuilderFactory.newKnowledgeBuilderConfiguration();
kbc.setProperty("drools.dialect.java.compiler", "JANINO");
KnowledgeBuilder builder = null;
builder = KnowledgeBuilderFactory.newKnowledgeBuilder(kbc);
Reader drlSource = new
InputStreamReader(RVEngine.class.getResourceAsStream(ruleset.getDrlSourc
e())); //ruleset.getDrlSource() = com/cit/myDrl.dslr
Reader dslSource = new
InputStreamReader(RVEngine.class.getResourceAsStream(ruleset.getDslSourc
e()));
builder.add(ResourceFactory.newReaderResource(dslSource),
ResourceType.DSL);
builder.add(ResourceFactory.newReaderResource(drlSource),
ResourceType.DSLR);
KnowledgeBase kbase = KnowledgeBaseFactory.newKnowledgeBase();
kbase.addKnowledgePackages(builder.getKnowledgePackages());
no matter what I type in my dslr (drl) file I get the following
exception on the highlighted line; ANY IDEA????
I have 1 rule or No rule it still throws the same exception. Does it
have to do with any jar files?
Caused by: java.lang.NullPointerException
at
org.drools.compiler.PackageBuilder.validateUniqueRuleNames(PackageBuilde
r.java:830)
at
org.drools.compiler.PackageBuilder.addPackage(PackageBuilder.java:555)
at
org.drools.compiler.PackageBuilder.addPackageFromDslr(PackageBuilder.jav
a:355)
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.j
ava:461)
at
org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.ja
va:28)
saleem
15 years, 1 month
