[
https://issues.apache.org/jira/browse/OFBIZ-13021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837096#comment-17837096
]
Pierre Smits commented on OFBIZ-13021:
--------------------------------------
Hi @jacques,
AFAIK, party accountant_group is not a 'demo user'. OOTB it doesn't have a
userLogin.
A party with partyTypeId="PARTY_GROUP' should/must not have a userLogin.
> 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)
