[
https://issues.apache.org/jira/browse/OFBIZ-12375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Smits updated OFBIZ-12375:
---------------------------------
Labels: roles (was: )
> 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: Trunk, 18.12.01
> Reporter: Pierre Smits
> Priority: Major
> Labels: roles
>
> 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)
