0 Replies Latest reply on Apr 16, 2007 9:43 AM by Ajaneesh Rajashekharaiah

    SQLException on jBPM Process Creation

    Ajaneesh Rajashekharaiah Newbie

      Hi All,

      I get the below error when i submit to an action method with the @CreateProcess annotation. What could be the reason. The error is very clear, a parent entry needs to be in the table jbpm_processinstance. The primary key in question is a auto generated one. (set up by jbpm). I manually created an entry in the processinstance table and ID_ was automatically generated. Dont understand what the problem could be, any help is appreciated.

      I am using MySQL, SEAM 1.2.1-GA and Jboss 4.0.5-GA.

      Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (`cvsportal/jbpm_moduleinstance`, CONSTRAINT `FK_MODINST_PRCINST` FOREIGN KEY (`PROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`))
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)