[jboss-user] [jBPM] - JTA in jBPM5.4 on jBoss7.1.1 is inconsistent - Urgent help please

[Arif Mohammed]

Arif Mohammed [https://community.jboss.org/people/arif.mohammed] created the discussion

"JTA in jBPM5.4 on jBoss7.1.1 is inconsistent - Urgent help please"

To view the discussion, visit: https://community.jboss.org/message/800174#800174

--------------------------------------------------------------
Hi All,

    Iam doing a prototype to evaluate jBPM5 for using it in a web application. I have defined a simple process StartUseCase -> CheckDuplicateOperator -> PersistOperator -> EndUseCase.
    In StartUseCase and EndUseCase activities Iam calling LocalTaskService to start and complete the user task respectively. I can't use HumanTask here due to some other reason. Following are the technology stack Iam using.

    JBoss7.1.1 Application server
    Spring MVC 3.0.5
    Hibernate4
    jBPM5.4.0.Final

*Problem:* When I create a persistable session I get the exception "*java.lang.IllegalStateException: BaseTransaction.rolback - ARJUNA01604: no transaction!*" When I inspect the stack trace further I see "*java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (JBPM.SYS_C0010966) violated*" 

    The above integrity constraint violation which is related to primary key in SESSIONINFO table is strange to me, as Iam not having any control over there and it is jBPM's responsibility to insert and update the session information. I also noticed the first line of exception some times during the end of my process, while it is updating the information in DB about the process and this behaviour is sporadic.

    It is even strange to me that if I restart the jBoss Application server it works fine with out any exception huff... Am I doing any thing wrong here ? I have attached all of my handlers along with persistence.xml and spring configuration, your quick help is appreciated.

   To look at the code you can start at OperatorController.saveOperator which is the trigger point for the process.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/800174#800174]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130228/e596c91c/attachment.html