Unable to Delete Issues Due to Conflict in Database

Unable to render {include} The included page could not be found.


When attempting to delete an issue, the error message "There was a system error trying to delete the issue" may appear in JIRA. Also, an error similar to the following may appear in the logs:

2010-08-31 11:43:40,934 http-8080-8 ERROR username 703x2493x1 pfx453 /secure/BulkDeletePerform.jspa [jira.bc.issue.DefaultIssueService] There was an exception while trying to delete the issue 'TST-1'.

com.atlassian.jira.exception.RemoveException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM jiraschema.OS_WFENTRY WHERE ID=? (The DELETE statement conflicted with the REFERENCE constraint "RELATEDOSWORKFLOWENTRY". The conflict occurred in database "jiradb", table "jiraschema.jiraissue", column 'WORKFLOW_ID'.))


This occurs due to foreign key constraints in the database.


Create and configure new database for JIRA without foreign keys. Then, restore the data by importing an XML backup into the newly created database (via JIRA).

Was this helpful?

Thanks for your feedback!

Why was this unhelpful?

Have a question about this article?

See questions about this article

Powered by Confluence and Scroll Viewport