Umesh,
 
Based on the error in the H2 log, it seems like you are trying to assign tasks to a user that is not in your users database.  The task component contains a list of possible users and methods to add new users.  When creating a new task, possible actors must be in the user list, otherwise the foreign key constraint cannot be satisfied.  By default, there should always be an "Administrator" user, as all tasks are by default assigned to this users.  On top of that, you also need to add all possible users that you use in your processes.
 
It might be better to check for the existing users when trying to create a task and give an appropriate error message if the user cannot be found ... I would gladly apply a patch if you could find the time.  Tasks are created in WSHumanTaskHandler, so that would be the location to do these modifications.
 
Kris
 
----- Original Message -----
From: Umesh Wankhede
To: Rules Users List
Sent: Tuesday, March 24, 2009 2:07 PM
Subject: [rules-users] Facing severe issues while using Persistence

Hi

 

While using workflow persistence feature (with human task component), I am having quite a few problems. When I use default db (H2), I get ConstraintViolationException [1]. Since I have to ultimately integrate with Oracle, I modify the config files to point to Oracle. But with that I started getting lot of other issues, like invalid column names (size, date), invalid table name (Comment), SQLGrammarException, etc[2] (This is serious problem, if you use Oracle!)

I am struggling for quite a few days to get this work, but no success, any help would be greatly appreciated.

I am attaching the source code also[3].

 

[1]db-h2-errors.log

[2] db-oracle-errors.log

[3] RuleFlowTest.java, ruleflow.rf

 

Regds

Umesh

 

 

 Legal Notice: This transmission, including any attachments, is confidential, proprietary, and may be privileged. It is intended solely for the intended recipient. If you are not the intended recipient, you have  received this transmission in error and you are hereby advised that any review, disclosure, copying, distribution, or use of this transmission, or any of the information included therein, is unauthorized and strictly prohibited. If you have received this transmission in error, please immediately notify the sender by reply and permanently delete all copies of this transmission and its attachments

 

_______________________________________________
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users