OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-2968) Vendor Prepayment - outgoing payment - Setting status to 'Sent' causes exception

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

Nicolas Malin (Jira)

[jira] Created: (OFBIZ-2968) Vendor Prepayment - outgoing payment - Setting status to 'Sent' causes exception

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

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.

Nicolas Malin (Jira)

[jira] Updated: (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 ]

Aswath Satrasala updated OFBIZ-2968:
------------------------------------

Attachment: patch.txt

VendorPrePayment is mapped to accounttype=prepaid-expenses
There was no mapping for the 'Company' from accounttype=prepaid-expenses to a GL account
Hence the exception

Please review the patch

> 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
> 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.

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-2968) Vendor Prepayment - outgoing payment - Setting status to 'Sent' causes exception

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12763670#action_12763670 ]

Jacques Le Roux commented on OFBIZ-2968:
----------------------------------------

Hi Aswath,

Is this using seed data ? Because it seems that using demo data I have any problems. Else could you please provide more informations ?

Thanks

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-2968) Vendor Prepayment - outgoing payment - Setting status to 'Sent' causes exception

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12764308#action_12764308 ]

Aswath Satrasala commented on OFBIZ-2968:
-----------------------------------------

Hello Jacques,
I get the trunk version of OFBiz.
I do 'ant run-install run'

By doing the above, the demo data also gets loaded.

I created an outgoing payment
PaymentType: VendorPrepayment.
PaymentMethod: Cash
ToParty: DemoSupplier

I click on 'Status to Sent' - then exception occurs

So, I am submitting the patch for the file DemoGlSetupData.xml - which is a demo data.

Thanks
-Aswath

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Nicolas Malin (Jira)

[jira] Closed: (OFBIZ-2968) Vendor Prepayment - outgoing payment - Setting status to 'Sent' causes exception

In reply to this post by Nicolas Malin (Jira)

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