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

Pawan Verma commented on OFBIZ-12153:
-------------------------------------

[~jleroux] [~sourabh.jain]

I'm not fully convinced about the solution here. Delete service should delete a record or expire it. I'm attaching a quickly looked workaround. [^OFBIZ-12153.patch]

Expire was not working as the fromDate field was not part of PK for FinAccount Entity, and it was setting fromDate as nowTime() instead of thruDate.

So modified the check to only check thruDate field on the "expire" action.

Please let us know your views on this. 

 

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