[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=17301458#comment-17301458 ]

ASF subversion and git services commented on OFBIZ-12153:
---------------------------------------------------------

Commit 2cf6476a79dd1c71045b903ad8e2e201121fefc3 in ofbiz-framework's branch refs/heads/release17.12 from Pawan Verma
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=2cf6476 ]

Fixed: Error in deleting Financial Account (OFBIZ-12153)

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.

Thanks: Lalit Dashora for report, Sourabh Jain for the initial fix, Jacques for the test.

> 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, 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)