topic Parent Key not found error for table ACT_FK_VAR_PROCINST in Alfresco Archive

Parent Key not found error for table ACT_FK_VAR_PROCINST

sakumar1 — Mon, 05 Oct 2015 13:43:31 GMT

Below error i am getting while executing workflow### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (DMS_SP.ACT_FK_VAR_PROCINST) violated - parent key not found### The error may involve org.activiti.engine.impl.persistence.entity.V

Re: Parent Key not found error for table ACT_FK_VAR_PROCINST

jbarrez — Tue, 06 Oct 2015 08:14:09 GMT

The error seems to indicate a variable is being inserted, but the process instance it belongs to has been deleted.
I would need some more information about when this exception occurs (what API you're invoking, etc.)

Re: Parent Key not found error for table ACT_FK_VAR_PROCINST

sakumar1 — Tue, 06 Oct 2015 09:39:09 GMT

This is sub process called by Activiti. My question here is how same workflow working after deleting Activiti Schema and recreating it again ?

Re: Parent Key not found error for table ACT_FK_VAR_PROCINST

jbarrez — Wed, 07 Oct 2015 08:19:12 GMT

"This is sub process called by Activiti"

That's very little information. Do you have an example?

"My question here is how same workflow working after deleting Activiti Schema and recreating it again ?"

The exception said the process instance was missing. So somehow the instance row in the database was removed while the process variable was not. Without knowing what your code does, it's very hard to say anything how that was caused.