[Anthill-pro] Problem deleting originating workflows

[Chad Loder]

On Mon, Feb 05, 2007 at 07:16:20PM -0800, Chad Loder wrote:
> Hello. I am experiencing a problem with AHP (3.1.2.b54).
> 
> When trying to delete any of my originating workflows, I get the following
> error:
> 
> 
> com.urbancode.anthill3.domain.persistent.PersistenceRuntimeException: com.urbancode.anthill3.domain.persistent.PersistenceException: Error deleting object in database
> 	com.urbancode.anthill3.web.util.Conversation.unbind0(Conversation.java:169)
> 	com.urbancode.anthill3.web.util.Conversation.unbind(Conversation.java:49)
> 	com.urbancode.anthill3.web.controller.ControllerServlet.doPost(ControllerServlet.java:396)
> 	com.urbancode.anthill3.web.controller.ControllerServlet.doGet(ControllerServlet.java:139)
> 	javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> 	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> 	com.urbancode.anthill3.web.util.LicenseFilter.doFilter(LicenseFilter.java:63)
> 	com.urbancode.anthill3.web.util.SecurityFilter.doFilter(SecurityFilter.java:66)
> 
> It seems that non-originating workflows get deleted just fine.
> 
> The underlying error message on the console is:
> 
> Caused by: org.apache.derby.client.am.SqlException: DELETE on table 'BUILD_PROFILE' caused a violation of foreign key co
> nstraint 'JT_BUILD_PROFILE_FK' for key (22).  The statement has been rolled back.

As a followup.  I deleted all the entries from the "Misc Jobs" search and the foreign key
constraint violations seem to have been resolved.