Pierre Smits created OFBIZ-12375:
------------------------------------
Summary: Fixed Asset Role: impossible combination of party and
role selectable: leads to error
Key: OFBIZ-12375
URL: https://issues.apache.org/jira/browse/OFBIZ-12375
Project: OFBiz
Issue Type: Bug
Components: accounting
Affects Versions: 18.12.01, Trunk
Reporter: Pierre Smits
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:
{code:java}
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.))) {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
