[ https://issues.apache.org/jira/browse/OFBIZ-13021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837102#comment-17837102 ]
Jacques Le Roux commented on OFBIZ-13021: ----------------------------------------- Thanks Pierre, Makes sense indeed. > Error when creating agreement role > ---------------------------------- > > Key: OFBIZ-13021 > URL: https://issues.apache.org/jira/browse/OFBIZ-13021 > Project: OFBiz > Issue Type: Bug > Components: accounting > Affects Versions: 18.12.13 > Reporter: Jacques Le Roux > Assignee: Jacques Le Roux > Priority: Major > > In trunk demo UI with partyId = accountant_group > Erreur(s) : > Error doing entity-auto operation for entity AgreementRole in service > createAgreementRole: org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:AgreementRole][agreementId,8000(java.lang.String)][createdStamp,2024-04-14 > 06:51:34.653(java.sql.Timestamp)][createdTxStamp,2024-04-14 > 06:51:34.652(java.sql.Timestamp)][lastUpdatedStamp,2024-04-14 > 06:51:34.653(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-14 > 06:51:34.652(java.sql.Timestamp)][partyId,accountant_group(java.lang.String)][roleTypeId,MAIN_ROLE(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO > public.AGREEMENT_ROLE (AGREEMENT_ID, PARTY_ID, ROLE_TYPE_ID, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) > VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table > "agreement_role" violates foreign key constraint "agrmnt_role_prle"<br/> > Detail: Key (party_id, role_type_id)=(accountant_group, MAIN_ROLE) is not > present in table "party_role".)) (Error while inserting: > [GenericEntity:AgreementRole][agreementId,8000(java.lang.String)][createdStamp,2024-04-14 > 06:51:34.653(java.sql.Timestamp)][createdTxStamp,2024-04-14 > 06:51:34.652(java.sql.Timestamp)][lastUpdatedStamp,2024-04-14 > 06:51:34.653(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-14 > 06:51:34.652(java.sql.Timestamp)][partyId,accountant_group(java.lang.String)][roleTypeId,MAIN_ROLE(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO > public.AGREEMENT_ROLE (AGREEMENT_ID, PARTY_ID, ROLE_TYPE_ID, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) > VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table > "agreement_role" violates foreign key constraint "agrmnt_role_prle"<br/> > Detail: Key (party_id, role_type_id)=(accountant_group, MAIN_ROLE) is not > present in table "party_role".))) -- This message was sent by Atlassian Jira (v8.20.10#820010)