Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error updating database. Cause: org.postgresql.util.PSQLException #3807

Open
medamines1 opened this issue Dec 20, 2023 · 1 comment
Open

Comments

@medamines1
Copy link

This is the exception i get when i start a new process.it's a simple process that contains just a user task.

Exception: PersistenceException, File: ExceptionFactory.java, Method: wrapException
Stack trace: org.apache.ibatis.exceptions.PersistenceException:

Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: insert or update on table "act_ru_identitylink" violates foreign key constraint "act_fk_idl_procinst"

Detail: Key (proc_inst_id_)=(f7c5dbc8-9f16-11ee-9b0a-7e80ffb266f0) is not present in table "act_ru_execution".

The error may exist in org/flowable/identitylink/service/db/mapping/entity/IdentityLink.xml

The error may involve org.flowable.identitylink.service.impl.persistence.entity.IdentityLinkEntityImpl.insertIdentityLink-Inline

The error occurred while setting parameters

SQL: insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_) values (?, 1, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?)

Cause: org.postgresql.util.PSQLException: ERROR: insert or update on table "act_ru_identitylink" violates foreign key constraint "act_fk_idl_procinst"

Detail: Key (proc_inst_id_)=(f7c5dbc8-9f16-11ee-9b0a-7e80ffb266f0) is not present in table "act_ru_execution".

@filiphr
Copy link
Contributor

filiphr commented Jan 2, 2024

@medamines1 can you please share the code you are using to get to this exception?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants