Re: [rules-users] Facing severe issues while using Persistence

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(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users