No delete option on Screens

Symptoms

Browsing to Administration >Issues > Screens there is no option to delete a screen, even if it was just created. In the logs the following error appear:

Cause

It happens because the attribute jira.fieldscreen.id is missing from the workflow - perhaps this screen was deleted.

Resolution 1

1. Go through Using the Database Integrity Checker first to see if this helps. If not:

2. Verify if those screens exist the database. It's likely they were somehow deleted:

   1 2 3 SELECT * FROM fieldscreen ORDER BY 2;

   ℹ️ If these have been deleted, they can be restored by restoring the entire instance using the XML backup. They cannot be restored by themselves through the application.

3. You need to find in which Workflow this error is from. This can be done by identifying the workflow with those screen names in it. Replace 'Default Screen' with the screen name from the exception(s).

   1 2 3 SELECT workflowname FROM jiraworkflows WHERE descriptor LIKE '%Default Screen%';

4. Export that workflow to XML. This is done by viewing the workflow and clicking Export > XML.

5. Search the XML for the screen name, e.g.: 'Default Screen':

   1 2 3 4 <action id="500" name="Go to Resolved" view="Default Screen"> <meta name="jira.description"></meta> <meta name="jira.fieldscreen.id">1</meta> <results>

6. Change the jira.fieldscreen.id to a valid value from step 1, for example:

   1 2 3 4 <action id="500" name="Go to Resolved" view="Default Screen"> <meta name="jira.description"></meta> <meta name="jira.fieldscreen.id">10000</meta> <results>

7. Backup the database (using XML or native DB tools).

8. Import that edited workflow XML.

Resolution 2

Alternatively, if you cannot import the workflow or if there are too many workflows to be modified, you can use the following operation that will change the workflows directly in the database. This was only tested in JIRA 7.

This will replace all non-existing references to screens to a single screen you'll create.

1. Copy the result of the following 'select' to a file named 'descriptors.xml'

   1 select descriptor from jiraworkflows;

   1. There are different commands in different databases. The following command works for 'postgres':

      1 copy ( select descriptor from jiraworkflows ) to '/path/descriptors.xml';

2. Make sure you have the 'descriptors' file in a Linux system

3. Make sure the file has new lines (not the '\n' characters) in XML file. Depending on how the data is copied, each descriptor may be in a single line. If so, this may resolve it:

   1 2 cat descriptors.xml | sed -r -e 's/\\n/\n/g' > descriptors_fixed.xml mv descriptors_fixed.xml descriptors.xml

4. Create a new screen in Screens page in JIRA without any fields and take note of its ID in the URL

5. Copy the following script to a script file (say fix_workflows.sh) in the same directory as 'descriptors.xml', replacing <NEW_ID>, by the screen's ID

   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 #!/bin/bash # Change here! NEW_SCREEN_ID=<NEW_ID> FILE=descriptors.xml SEARCH_STRING='<meta name="jira.fieldscreen.id">' cat $FILE | grep "$SEARCH_STRING" | sort | uniq | while read line; do ID=`echo $line | cut -d '>' -f 2 | cut -d '<' -f 1` echo -e "\033[0;31m If the following select doesn't return anything\033[0m, run the update below it. \033[0;31mDon't run in otherwise\033[0m" echo "select * from fieldscreen where id = $ID;" echo "update jiraworkflows set descriptor = replace(descriptor,'<meta name=\"jira.fieldscreen.id\">${ID}</meta>', '<meta name=\"jira.fieldscreen.id\">${NEW_SCREEN_ID}</meta>');" echo done

6. Give it executable permissions:

   1 chmod a+x fix_workflows.sh

7. Run it

   1 ./fix_workflows.sh

8. Stop JIRA and backup the database

9. Follow the instructions, run the updated only if the select above it doesn't return anything. This will change only the references to non-existing screens.

10. Start JIRA