[rules-users] Facing severe issues while using Persistence

[Kris Verlaenen]

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 at lists.jboss.org
  https://lists.jboss.org/mailman/listinfo/rules-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20090326/c95faa95/attachment.html