[ 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)