Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-13021

Error when creating agreement role

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Problem
    • 18.12.13
    • None
    • accounting
    • None

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

      Attachments

        Issue Links

          Activity

            People

              jleroux Jacques Le Roux
              jleroux Jacques Le Roux
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: