Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-12375

Fixed Asset Role: impossible combination of party and role selectable: leads to error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • Trunk, 18.12.01, Upcoming Branch
    • None
    • accounting

    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

          Activity

            People

              Unassigned Unassigned
              pierresmits Pierre Smits
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated: