[jira] [Commented] (OFBIZ-12153) Error in deleting Financial Account

[Nicolas Malin (Jira)]

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

Pawan Verma commented on OFBIZ-12153:
-------------------------------------

Hi [~jleroux]

I've updated the patch to fix the testCase issue. Here is the patch: [^OFBIZ-12153.patch]

EntityAutoEngine's expire method can also expire a field with a name date, so it was not allowing.  FinAccount.fromDate is not part of PK, so the engine is attempting to update it and leaving thruDate field. Modified code will update both fields.

Let me know your thoughts! 

> Error in deleting Financial Account
> -----------------------------------
>
>                 Key: OFBIZ-12153
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-12153
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting
>            Reporter: Lalit Dashora
>            Assignee: sourabh jain
>            Priority: Major
>         Attachments: FinAccountDelete.png, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch
>
>
> 1. Navigate to URL: accounting/control/FindFinAccount
> 2. Click on Find button. List of fin account will be displayed.
> 3. Click on delete button near available balance column.
> The Following Errors Occurred:
> Error doing entity-auto operation for entity FinAccount in service deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting the following entity: [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key (SC_CHECKING). The statement has been rolled back.)) (Exception while deleting the following entity: [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key (SC_CHECKING). The statement has been rolled back.)))

--
This message was sent by Atlassian Jira
(v8.3.4#803005)