Re: [rules-users] Guvnor repository database use to store assets
by puja nandamuri
Hi,
Sorry, I think the original question I had asked still seems to have been unanswered.
This is the question I had.
does Guvnor keep creating additional tables as per the need or is the Table structure that Guvnor creates in the beginning where all the assets are stored remains the same until we manually delete the Tables?
after creating rules and assets for several days, we had to re deploy a freshly compiled Guvnor war file( everything remaining the same) using the same repository xml and same database connected through jndi datasource.
In other words, just the war file has been recompiled. we also deleted the workspace and repository directories previously created by Guvnor.
The DBA had locked the userid permissions to prevent any new table creation in the Guvnor database.
During Guvnor startup, Guvnor had complained about not having permission to create Tables.
My question is :
why does Guvnor need to create any additional tables and not use the existing Table structure in the database.
I would appreciate any thoughts on this.
--- On Sun, 9/4/11, Nicolas Héron <nicolas.heron.java(a)gmail.com> wrote:
From: Nicolas Héron <nicolas.heron.java(a)gmail.com>
Subject: Re: [rules-users] Guvnor repository database use to store assets
To: "Rules Users List" <rules-users(a)lists.jboss.org>
Date: Sunday, September 4, 2011, 10:52 PM
Hi,
Sorry, but you do not have to delete the workspace directory. Not
sure where you are getting this from? In cases where you have a
large number of packages/assets in Guvnor it is rather recommended
_not_ to delete the search indexes written onto the file system,
because it takes extra time to re-create them.
May be it is recommended. But when you modify a lot the assets, rename, copy, delete,etc.. Guvnor gets lost.
At startup, Jackrabbit (containent in Guvnor) reads all the
database and creates the two directories. You do not need to
backup them.
Again, I don't know where you are getting this from. Jackrabbit does
_not_ read the entire DB on startup and does not write any of the
JCR content stored in an RDBMS to the file system if you have
configured it to store to the RDBMS. If you for any weird reason are
seeing this on your end, you should really have another look at your
repository.xml.
The search indexes, they are stored on the file system no ? And with no index, you cannot reach any of the assets. So when you delete thoses directories, at startup, they are re-created and the database is read. I do not know what is read, but it can take quite some times, depending on the size of the package. Now If there is a way to store thoses indexes in the database, I would be happy to know how.
The project I am on has many rules and many big web decision tables that end up with more than 100000 rules. I am using 5.3 snapshot with MVEL beta6 => Startup time =5 minutes and building the package, 3 to 5 minutes on a HP G6 processor. On my PC that has an i5 processor and a 32 bits linux, I cannot build anymore the package.
With those sizes, which is not that much, Guvnor/jackrabbits gets lots on the indexes : it gives jackrabbit exceptioorn or spaces are not considered. So then, what I do is delete those two directories and restart guvnor and everything is fine again.
ThanksNicolas
-----Inline Attachment Follows-----
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
12 years, 7 months
Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total
by john＠oa
Guvnor: guvnor-5.2.0.Final-tomcat-6.0
Hi
I am a Drools Newbie and I have an integer field called score that I need to
add to when a rule matches in a spreadsheet decision table. i.e. the score
field should hold a running total of all scores that are matched. However,
I can't even update the field in the table. I have attached the spreadsheet
for review. In this spreadsheet I am simply trying to set the score, and
that is failing with:
DScoringTable] Rule Compilation error application cannot be resolved
My goal is to have different decision tables that will all need to update
the same score, and keep a running total of the total score.
Any help very much appreciated! I hope that I am just missing something
obvious.
http://drools.46999.n3.nabble.com/file/n3322713/demo-score-sheet.xls
demo-score-sheet.xls
In future I may wish to also update a String field and keep concatenating to
that field, is this possible?
John
--
View this message in context: http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
12 years, 7 months
Guvnor Integration with BPEL
by Rabindra Kumar Srivastava
Hi,
I am using guvnor 5.2.0Final version to create rules and integrating
with ActiveVOS.
I am successfully done with one rule in a package using the url
url=http://localhost:8080/guvnor/org.drools.guvnor.Guvnor/package/final/
LATEST.
Now I have created two more rules in the same package final but not able
to access the other rules.
Please suggest the possible solution.
Rabindra Kumar Srivastava | ATT04 | Tech Mahindra
Hinjewadi, Pune 411 057, INDIA
( Office: +91 20 42250000 | Mobile: +91 9892232699| Ext: 253918
Email: rs0090916(a)techmahindra.com
www.techmahindra.com <http://www.techmahindra.com/>
============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================
12 years, 7 months
prevent rule evaluation for certain rules while event insertion
by Neel
Hi,I'm using Drools 5.3.0. I've a proprietary key-value based data store, where all the events are stored. As soon as an event is received, it is inserted in the session and the rules (example below) is fired:
rule "registration count"no-loopdialect "mvel"when $e : Event(type == "registration", $s: student)then $s.registerCount += 1; update($s);end
All the 'registration' events which has occurred in the past (stored in data store) also are inserted in session so that any rule with temporal operator (relates among the events) can work fine. If I insert previous events then the rule "registration count" is evaluated again for each previous events and fired. Please let me know, if there is a way to prevent rule evaluation for certain rules while event insertion. The events are too many, so I don't keep all in working memory for long period, instead I store previous events in data store and insert all previous events also in session when I get a new event.Please help me regarding the issue.
Thanks,Neel
12 years, 7 months
Client code using RuleAgent API - Guvnor 5.1.1 - getting 401 error
by Achyutha, Venkata
Hi,
This error would be basic one but it's very frustrating to me to debug this, few days ago it use to work.
I deployed guvnor 5.1.1 war into web logic 10.3, created package with 4 rules, build and deploy, got package url.
Started using package url in properties file and passing file to RuleAgent api, suddenly it started giving HTTP response code: 401 for URL.
Any thoughts on this issue would be greatly appreciated.
Below is the content of properties file and Client code.
{url=http://10.117.39.51:7001/Guvnor5.1.1/org.drools.guvnor.Guvnor/package/com.tmobile.pos.rules/LATEST , name=myrules, username=weblogic, poll=30, newInstance=true, localCacheDir=C:\Installed\workspaces\drools\POC\bin, workspacepath=C://bea/user_projects/domains/posdomain, password=weblogic123, enableBasicAuthentication=true}
Error:
RuleAgent(myrules) INFO (Fri Nov 26 15:19:00 IST 2010): Configuring with newInstance=true, secondsToRefresh=30
RuleAgent(myrules) INFO (Fri Nov 26 15:19:00 IST 2010): Configuring package provider : URLScanner monitoring URLs: http://10.117.39.51:7001/Guvnor5.1.1/org.drools.guvnor.Guvnor/package/com... with local cache dir of C:\Installed\workspaces\drools\POC\bin
RuleAgent(myrules) EXCEPTION (Fri Nov 26 15:19:01 IST 2010): Server returned HTTP response code: 401 for URL: http://10.117.39.51:7001/Guvnor5.1.1/org.drools.guvnor.Guvnor/package/com.... Stack trace should follow.
java.io.IOException: Server returned HTTP response code: 401 for URL: http://10.117.39.51:7001/Guvnor5.1.1/org.drools.guvnor.Guvnor/package/com...
Client Code: (getting error at 3rd line)
File file = new File("C:\\guvnor.properties");
properties.load(new FileInputStream(file));
RuleAgent agent = RuleAgent.newRuleAgent(properties);
RuleBase ruleBase = agent.getRuleBase();
WorkingMemory workingMemory = ruleBase.newStatefulSession();
Thanks
Kumar
12 years, 7 months
order of execution between BPM events and rules
by Jordi Alvarez
Hello, I am involved in a set of projects for an insurance company in which
we have been combining Drools Expert and Drools Flow for its 5.1.1 version.
We are making extensive use of events / wait states in our processes.
We have experienced that, in case of conflict between wait state constraints
and rules (that is, there is a wait state constraint that is true and also a
rule activation that is true), always the constraints associated to our
processes execute before the rule.
We have searched in the documentation but found nothing regarding this
point. Can anybody confirm whether our empirical assumption is really true?
There is some way to configure this behaviour?
Many thanks in advance!
Jordi Alvarez
12 years, 7 months
How to get a Facts handle in Custom Evaluator
by kashif10
Lets say we have 100s or 1000s of Fact objects of Observation.
In rule we need to compare it with some data lets say
Observation( this checkObs "SomeData")
Where checkObs is our customeEvaluator
Now we have to make the RHS dynamic...
That If we have some data in database depending upon the caller... we need
to replcae that with "SomeData" in our evaluator, but how can I get/passes
user info in our custom evaluator.
Is there a way to read some global variable, or some other facts object in
our evalutor, which changed per firing of rule sets??
--
View this message in context: http://drools.46999.n3.nabble.com/How-to-get-a-Facts-handle-in-Custom-Eva...
Sent from the Drools: User forum mailing list archive at Nabble.com.
12 years, 7 months
