topic Re: Exception on insert into act_hi_detail in Alfresco Forum

Exception on insert into act_hi_detail

jamespatten — Wed, 21 Mar 2018 20:45:27 GMT

Hi,I'm using Activiti 5.22.0, and I occasionally encounter the following exception when trying to complete a task:### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "act_hi_detail_pkey" Detail: Key (id_)=(5096) already exists.

Re: Exception on insert into act_hi_detail

bassam_al-saror — Thu, 22 Mar 2018 13:54:53 GMT

I don't think that DbIdGenerator is the issue but you can try switching to UUID instead see Activiti User Guide

Re: Exception on insert into act_hi_detail

upforsin — Mon, 06 Jul 2020 11:41:35 GMT

Recently we faced this issue on Alfresco Community 6.1.x. The problem is about the incorrect ID generator (newly generated ID is already in the database).

To fix this issue you have to change next.dbid value in the database.

Step-by-step:

1) Check maximum id value

id_ select max(to_number(id_,'999999999')) from public.act_hi_detail

2) Update value_ in the act_ge_property table - must be greater than maximum id return by the previous SQL statement

3) Restart Alfresco