topic Problem with SQL: insert into ACT_RU_VARIABLE in Alfresco Archive

Problem with SQL: insert into ACT_RU_VARIABLE

mtvrznik — Tue, 12 Aug 2014 11:13:52 GMT

Hi,we got main process with subprocess (called with CallActivity). In the subprocess is ReceivedTask where we got this error:<blockcode>org.apache.ibatis.exceptions.PersistenceException:### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integritn

Re: Problem with SQL: insert into ACT_RU_VARIABLE

martin_grofcik — Wed, 13 Aug 2014 05:04:49 GMT

Hi,

Could you create jUnit test for the issue? (to see process definition).
http://forums.activiti.org/content/sticky-how-write-unit-test

Regards
Martin

Re: Problem with SQL: insert into ACT_RU_VARIABLE

mtvrznik — Wed, 13 Aug 2014 07:23:10 GMT

hi,

thanks for your response

we will try to prepare test, but we hope if somebody have some tips becouse we are not sure if is possible to create some kind of simple junit test for simulating this problem in our system

Michal

Re: Problem with SQL: insert into ACT_RU_VARIABLE

jbarrez — Tue, 19 Aug 2014 09:26:08 GMT

What does this mean?

ORA-02291: integritní omezení (VYZVY.ACT_FK_VAR_PROCINST) porušeno - nenalezen nadřízený klíč

Re: Problem with SQL: insert into ACT_RU_VARIABLE

mtvrznik — Tue, 19 Aug 2014 10:27:46 GMT

Oh sorry it was in czech, here is same error in english:

ORA-02291: integrity constraint (VYZVY.ACT_FK_VAR_PROCINST) violated - parent key not found

Re: Problem with SQL: insert into ACT_RU_VARIABLE

jbarrez — Tue, 19 Aug 2014 11:18:00 GMT

ok thanks 🙂

The error indicates that the process instance is gone. Could it be some other node in the cluster has already completed the process instance somehow?

Re: Problem with SQL: insert into ACT_RU_VARIABLE

mtvrznik — Fri, 22 Aug 2014 07:16:28 GMT

Thanks, this is one of the things that we looked for, but haven´t found anything wrong. We have two concurent actions when problem occured.
1. Start instance of process which is leading to user task in main process or to receive task in subprocess
2. User or agent sends process from user task from main process which leads to receive task in subprocess

We are trying to prepare simple test but we are not successful yet, maybe because in real process, there is big amount of other actions like xml and xls parsing, cooperating with IBM Notes and Oracle,… so it´s not simply possible simulate it all in jUnit test.