Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
Trunk, 17.12.08, 18.12.01, Upcoming Branch
-
None
Description
On the invoice role page in accounting (see e.g. https://demo-stable.ofbiz.apache.org/accounting/control/invoiceRoles?invoiceId=demo10001 ) it is possible to select an impossible combination of a party and a role. After the submit an error is shown:
The Following Errors Occurred:Exception thrown while creating the "newEntity" GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2021-11-09 10:21:14.073(java.sql.Timestamp)][createdTxStamp,2021-11-09 10:21:14.02(java.sql.Timestamp)][datetimePerformed,2021-11-09 10:21:14.073(java.sql.Timestamp)][invoiceId,demo10001(java.lang.String)][lastUpdatedStamp,2021-11-09 10:21:14.073(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 10:21:14.02(java.sql.Timestamp)][partyId,DemoLead(java.lang.String)][percentage,null()][roleTypeId,INTERNAL_ORGANIZATIO(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE_ROLE' caused a violation of foreign key constraint 'INVCE_RLE_PTRL' for key (DemoLead,INTERNAL_ORGANIZATIO). The statement has been rolled back.)) (Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2021-11-09 10:21:14.073(java.sql.Timestamp)][createdTxStamp,2021-11-09 10:21:14.02(java.sql.Timestamp)][datetimePerformed,2021-11-09 10:21:14.073(java.sql.Timestamp)][invoiceId,demo10001(java.lang.String)][lastUpdatedStamp,2021-11-09 10:21:14.073(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 10:21:14.02(java.sql.Timestamp)][partyId,DemoLead(java.lang.String)][percentage,null()][roleTypeId,INTERNAL_ORGANIZATIO(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE_ROLE' caused a violation of foreign key constraint 'INVCE_RLE_PTRL' for key (DemoLead,INTERNAL_ORGANIZATIO). The statement has been rolled back.)))
Attachments
Issue Links
- is related to
-
OFBIZ-12371 BudgetRole: improbable selection possible, PartyRole gets created
- Open
-
OFBIZ-12372 BillingAccountRole: improbable combo Party & Role selection possible: PartyRole created
- Open
-
OFBIZ-12373 FinAccountRole: improbable selection possible: PartyRole created
- Open
-
OFBIZ-12374 TaxAuthority: Parties not having the role of TaxAuthority can be selected
- Open
-
OFBIZ-12375 Fixed Asset Role: impossible combination of party and role selectable: leads to error
- Open
-
OFBIZ-5980 Have the ability to revoke (expire) roles of a party
- Closed