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

["ASF subversion and git services (Jira)" <ji...@apache.org>]

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

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

Commit 2876adf26cb3c4f9c9a2ffebeec501322cb0d0d7 in ofbiz-framework's branch refs/heads/release17.12 from Jacques Le Roux
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=2876adf ]

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 fix


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