Unable to Delete Issues Due to Conflict in Database
Unable to render {include} The included page could not be found.
Symptoms
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 10.0.0.10 /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'.))
Cause
This occurs due to foreign key constraints in the database.
Resolution
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).
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.