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.
13 years, 4 months
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
13 years, 4 months
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!
13 years, 4 months
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
13 years, 4 months
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.
13 years, 4 months
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
13 years, 4 months
'Long' and 'double' value comparing problem in drools 5.1.0
by Miles Wen
hi there,
I have a simple fact class:
public class Msg {
private Long lo = 5l;
private double dbl = 5.5;
public Long getLo() {
return lo;
}
public void setLo(Long lo) {
this.lo = lo;
}
public double getDbl() {
return dbl;
}
public void setDbl(double dbl) {
this.dbl = dbl;
}
}
and a simple drl program:
package com.sample
import com.sample.Msg;
rule "Hello World"
when
m:Msg(lo >= dbl)
then
System.out.println( "hello world" );
System.out.println(m.getLo());
System.out.println(m.getDbl());
end
I simply compare the Long value, which is 5, to the double value ,which is
5.5, with operator '>=', and the output is:
hello world
5
5.5
but it can't be ,cause 5 is less than 5.5.
then I modified the drl program a bit:
m:Msg(lo == dbl)
It successfully prints out the message as well.It seems that drools treated
the double value '5.5' as '5' in comparing...
Is this a bug or something?What could I do to correct it?
thanks.
13 years, 4 months
Drools Clustering & High Availability
by Carlos Santiago Moreno
Hi there! My team and I were thinking on implementing Drools Flow on a
project, running it on a Tomcat Apache server, but we have to investigate
some little details of this tools before taking any desition. The thing is,
that we have been searching, on a lots of forums, mailing lists, and blog
posts, but no one ever gives a direct answer to two particular questions.
The first one is, if Flow is compatible with clustering. Till now, we
understand that is not a problem if we use JBoss AS, but, as I said before,
we are planning to use Tomcat, so we don't know for sure if it will work.
The other question unanswered yet is, what can you tell us about the High
Availability. We need to know if it possible to set HA features on this
tool.
Everything you could tell us will be for help.
Carlos S. Moreno
13 years, 4 months
Drools Clustering & High Availability
by Carlos Santiago Moreno
Hi there! My team and I were thinking on implementing Drools Flow on a
project, running it on a Tomcat Apache server, but we have to investigate
some little details of this tools before taking any desition. The thing is,
that we have been searching, on a lots of forums, mailing lists, and blog
posts, but no one ever gives a direct answer to two particular questions.
The first one is, if Flow is compatible with clustering. Till now, we
understand that is not a problem if we use JBoss AS, but, as I said before,
we are planning to use Tomcat, so we don't know for sure if it will work.
The other question unanswered yet is, what can you tell us about the High
Availability. We need to know if it possible to set HA features on this
tool.
Everything you could tell us will be for help.
Carlos S. Moreno
13 years, 4 months
