[OFBIZ-13021] Error when creating agreement role

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 18.12.13
• Component/s: accounting
• Assignee: Jacques Le Roux
• Reporter: Jacques Le Roux
• Created: 14/Apr/24 06:58
• Updated: 15/Apr/24 07:39
• Resolved: 15/Apr/24 07:07

Description

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".)))

Issue Links

• is related to: OFBIZ-12518 Agreement Roles - VIEW permissions