[jboss-user] [JBoss jBPM] - JBPM4.0 Oracle Parent Key Not Found Error
rams.rapo
do-not-reply at jboss.com
Wed Jul 22 21:22:27 EDT 2009
Environment:
JBPM4.0
Hibernate 3.3.1GA
Database: Oracle 10
When i try to create a process instance out of the following process definition, it fails with below error. The same when i run against hsql on my local it works fine. Only difference we have in oracle is the sequence are our own instead of assigned=native.
ProcessDefinition:
|
| <?xml version="1.0" encoding="UTF-8"?>
|
| <process name="SimpleProcess" xmlns="http://jbpm.org/4.0/jpdl">
|
| <start g="20,20,48,48">
| <transition name="review1" to="review1" />
| </start>
|
| <task name="review1" g="96,16,127,52">
| <assignment-handler class="test.TaskHandler">
| </assignment-handler>
| <transition name="review2" to="review2" />
| </task>
|
| <task name="review2" g="96,16,127,52">
| <assignment-handler class="test.TaskHandler">
| </assignment-handler>
| <transition name="review3" to="review3" />
| </task>
|
| <task name="review3" g="96,16,127,52">
| <assignment-handler class="test.TaskHandler">
| </assignment-handler>
| <transition name="endstate" to="endstate" />
| </task>
|
| <end name="endstate" g="255,16,88,52" />
|
| </process>
|
|
|
Error:
|
| Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (JBPM4.FK_HTI_HTASK) violated - parent key not found
|
| at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
| at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10768)
| at com.p6spy.engine.logging.P6LogPreparedStatement.executeBatch(P6LogPreparedStatement.java:329)
| at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
| at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
| at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
| ... 72 more
|
|
|
|
Logs (I used p6spy driver to see values being passed)
| Hibernate: select * from ( select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from test.JBPM4_DEPLOYMENT deployment0_, test.JBPM4_DEPLOYPROP deployment1_, test.JBPM4_DEPLOYPROP deployment2_, test.JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='SimpleProcess' order by deployment3_.LONGVAL_ desc ) where rownum <= ?
|
| Hibernate: select * from ( select deployment0_.DBID_ as DBID1_13_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_13_, deployment0_.OBJNAME_ as OBJNAME3_13_, deployment0_.KEY_ as KEY4_13_, deployment0_.STRINGVAL_ as STRINGVAL5_13_, deployment0_.LONGVAL_ as LONGVAL6_13_ from test.JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='SimpleProcess-1' ) where rownum <= ?
|
| Hibernate: select test.S_JBPM4_EXECUTION.nextval from dual
|
| Hibernate: insert into test.JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)
|
| Hibernate: select test.S_JBPM4_HIST_PROCINST.nextval from dual
|
| Hibernate: select test.S_JBPM4_TASK.nextval from dual
|
| [2009-07-22 18:05:31,062] (TaskHandler:assignTask:24) - TaskHandler
|
| Hibernate: select historypro0_.DBID_ as DBID1_4_0_, historypro0_.DBVERSION_ as DBVERSION2_4_0_, historypro0_.ID_ as ID3_4_0_, historypro0_.PROCDEFID_ as PROCDEFID4_4_0_, historypro0_.KEY_ as KEY5_4_0_, historypro0_.START_ as START6_4_0_, historypro0_.END_ as END7_4_0_, historypro0_.DURATION_ as DURATION8_4_0_, historypro0_.STATE_ as STATE9_4_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_4_0_, historypro0_.NEXTIDX_ as NEXTIDX11_4_0_ from test.JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?
|
| Hibernate: select test.S_JBPM4_HIST_ACTINST.nextval from dual
|
| Hibernate: insert into test.JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
|
| Hibernate: insert into test.JBPM4_TASK (DBVERSION_, NAME_, DESCR_, STATE_, SUSPHISTSTATE_, ASSIGNEE_, FORM_, PRIORITY_, CREATE_, DUEDATE_, PROGRESS_, SIGNALLING_, EXECUTION_ID_, ACTIVITY_NAME_, HASVARS_, SUPERTASK_, EXECUTION_, PROCINST_, SWIMLANE_, TASKDEFNAME_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'T', ?)
|
| Hibernate: insert into test.JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, HTASK_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'task', ?)
>From the above logs, its obvious that a row is being inserted into JBPM4_HIST_ACTINST instead of JBPM4_HIST_TASK, there by causing parent key not found. Tried changing hbm's a bit by adding ignore=false, etc but ain't working. Any clues?
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4245443#4245443
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4245443
More information about the jboss-user
mailing list