[
https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17300421#comment-17300421 ]
Pawan Verma commented on OFBIZ-12153:
-------------------------------------
Hi [~jleroux]
Here is the patch for R17 and R18, Could you please have a look!
[^OFBIZ-12153.patch]
> 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)
Locked
