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

Adrian Crum commented on OFBIZ-5311:
------------------------------------

Actually, the service I was thinking of is copyWorkEffort that I added in rev 
1164773. I apologize for the confusion.

Normally, we CANCEL a workeffort (soft delete) instead of actually removing 
WorkEffort entity values. If you really want to do that, then you can copy and 
modify the copyWorkEffort service. It uses the entity models to find all 
related entities - which is more reliable than the hard-coded list in the 
deleteWorkEffort service.

                
> Error when we  delete workeffort
> --------------------------------
>
>                 Key: OFBIZ-5311
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5311
>             Project: OFBiz
>          Issue Type: Bug
>    Affects Versions: Release Branch 11.04, Release Branch 12.04
>            Reporter: Dhiraj Gupta
>
> Hi All
> Wnen we click on delete button on this page
> https://demo-trunk.ofbiz.apache.org/workeffort/control/FindWorkEffort
> then it gives the error 
> The Following Errors Occurred:
> Exception thrown while removing entity value: Exception while deleting the 
> following entity: 
> [GenericEntity:WorkEffort][workEffortId,DEMO-TASK-4(java.lang.String)] (SQL 
> Exception while executing the following:DELETE FROM OFBIZ.WORK_EFFORT WHERE 
> WORK_EFFORT_ID=? (DELETE on table 'WORK_EFFORT' caused a violation of foreign 
> key constraint 'CSTREQ_WF_WEFF' for key (DEMO-TASK-4). The statement has been 
> rolled back.))
> Thanks 
> Dhiraj Gupta

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to