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

sourabh jain commented on OFBIZ-12153:
--------------------------------------

Hello All,
I have added the patch for resolving the issue of getting an error on deleting the Financial Account with the following changes:

- Updated the service definition of 'deleteFinAccount' and used the 'update' as entity-auto invoke method instead of 'delete'.
- Added all non-pk attributes of the entity for the update operation.
- Added 'thruDate' parameter for expiring the financial account.

*OFBIZ-12153.patch*
Please let me know if any modification is needed.

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