Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
Trunk, 18.12.01, Upcoming Branch
-
None
Description
On the Fixed Asset Role page (called Party Fixed Assed Assignments, see https://demo-stable.ofbiz.apache.org/accounting/control/createPartyFixedAssetAssignment) 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:Error doing entity-auto operation for entity PartyFixedAssetAssignment in service createPartyFixedAssetAssignment: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:PartyFixedAssetAssignment][allocatedDate,null()][comments,null()][createdStamp,2021-11-09 12:10:05.792(java.sql.Timestamp)][createdTxStamp,2021-11-09 12:10:05.781(java.sql.Timestamp)][fixedAssetId,DEMO_PROJECTOR(java.lang.String)][fromDate,2021-11-09 12:10:05.792(java.sql.Timestamp)][lastUpdatedStamp,2021-11-09 12:10:05.792(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 12:10:05.781(java.sql.Timestamp)][partyId,BigSupplier(java.lang.String)][roleTypeId,TAX_AUTHORITY(java.lang.String)][statusId,PRTYASGN_ASSIGNED(java.lang.String)][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PARTY_FIXED_ASSET_ASSIGNMENT (PARTY_ID, ROLE_TYPE_ID, FIXED_ASSET_ID, FROM_DATE, THRU_DATE, ALLOCATED_DATE, STATUS_ID, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PARTY_FIXED_ASSET_ASSIGNMENT' caused a violation of foreign key constraint 'PTY_FASTAS_PTRL' for key (BigSupplier,TAX_AUTHORITY). The statement has been rolled back.)) (Error while inserting: [GenericEntity:PartyFixedAssetAssignment][allocatedDate,null()][comments,null()][createdStamp,2021-11-09 12:10:05.792(java.sql.Timestamp)][createdTxStamp,2021-11-09 12:10:05.781(java.sql.Timestamp)][fixedAssetId,DEMO_PROJECTOR(java.lang.String)][fromDate,2021-11-09 12:10:05.792(java.sql.Timestamp)][lastUpdatedStamp,2021-11-09 12:10:05.792(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 12:10:05.781(java.sql.Timestamp)][partyId,BigSupplier(java.lang.String)][roleTypeId,TAX_AUTHORITY(java.lang.String)][statusId,PRTYASGN_ASSIGNED(java.lang.String)][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PARTY_FIXED_ASSET_ASSIGNMENT (PARTY_ID, ROLE_TYPE_ID, FIXED_ASSET_ID, FROM_DATE, THRU_DATE, ALLOCATED_DATE, STATUS_ID, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PARTY_FIXED_ASSET_ASSIGNMENT' caused a violation of foreign key constraint 'PTY_FASTAS_PTRL' for key (BigSupplier,TAX_AUTHORITY). The statement has been rolled back.)))
Attachments
Issue Links
- relates to
-
OFBIZ-12370 InvoiceRole: impossible combination of party and role selectable: leads to error
- Open