You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacques Le Roux (JIRA)" <ji...@apache.org> on 2009/10/25 11:47:59 UTC
[jira] Closed: (OFBIZ-2968) Vendor Prepayment - outgoing payment -
Setting status to 'Sent' causes exception
[ 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.