[ https://issues.apache.org/jira/browse/OFBIZ-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Le Roux closed OFBIZ-2968. ---------------------------------- Resolution: Fixed Fix Version/s: SVN trunk Release Branch 9.04 Assignee: Jacques Le Roux Thanks Aswath, Your patch is in trunk at r829527, R9.04 r829528 > Vendor Prepayment - outgoing payment - Setting status to 'Sent' causes > exception > -------------------------------------------------------------------------------- > > Key: OFBIZ-2968 > URL: https://issues.apache.org/jira/browse/OFBIZ-2968 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Aswath Satrasala > Assignee: Jacques Le Roux > Fix For: Release Branch 9.04, SVN trunk > > Attachments: patch.txt > > > Hi, > I created an outgoing payment > PaymentType: VendorPrepayment. > PaymentMethod: Cash > ToParty: DemoSupplier > I click on 'Status to Sent' - Following exception occurs > The Following Errors Occurred: > Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service > invocation error (Could not commit transaction for service [setPaymentStatus] > call: Roll back error, could not commit transaction, was rolled back instead > because of: Failure in create operation for entity [AcctgTransEntry]: > org.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00002(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10045(java.lang.String)][amount,333.0000(java.math.BigDecimal)][createdStamp,2009-09-24 > 11:26:29.156(java.sql.Timestamp)][createdTxStamp,2009-09-24 > 11:26:27.234(java.sql.Timestamp)][currencyUomId,INR(java.lang.String)][debitCreditFlag,D(java.lang.String)][glAccountId,150000(java.lang.String)][glAccountTypeId,PREPAID_EXPENSES(java.lang.String)][lastUpdatedStamp,2009-09-24 > 11:26:29.156(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-24 > 11:26:27.234(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,333.0000(java.math.BigDecimal)][origCurrencyUomId,INR(java.lang.String)][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO > OFBIZ.ACCTG_TRANS_ENTRY (ACCTG_TRANS_ID, ACCTG_TRANS_ENTRY_SEQ_ID, > ACCTG_TRANS_ENTRY_TYPE_ID, DESCRIPTION, VOUCHER_REF, PARTY_ID, ROLE_TYPE_ID, > THEIR_PARTY_ID, PRODUCT_ID, THEIR_PRODUCT_ID, GL_ACCOUNT_TYPE_ID, > GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, AMOUNT, CURRENCY_UOM_ID, ORIG_AMOUNT, > ORIG_CURRENCY_UOM_ID, DEBIT_CREDIT_FLAG, DUE_DATE, GROUP_ID, TAX_ID, > RECONCILE_STATUS_ID, SETTLEMENT_TERM_ID, IS_SUMMARY, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > (INSERT on table 'ACCTG_TRANS_ENTRY' caused a violation of foreign key > constraint 'ACCTTXENT_GLACOG' for key (150000,Company). The statement has > been rolled back.)). Rolling back > transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00002(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10045(java.lang.String)][amount,333.0000(java.math.BigDecimal)][createdStamp,2009-09-24 > 11:26:29.156(java.sql.Timestamp)][createdTxStamp,2009-09-24 > 11:26:27.234(java.sql.Timestamp)][currencyUomId,INR(java.lang.String)][debitCreditFlag,D(java.lang.String)] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.