[ https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17301463#comment-17301463 ]
ASF subversion and git services commented on OFBIZ-12153: --------------------------------------------------------- Commit b2a59b12a96e9dbbea72372bc062f5a8532dac24 in ofbiz-framework's branch refs/heads/release18.12 from Pawan Verma [ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=b2a59b1 ] 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)