Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-70506

Error when creating/editing an issue with inactive users in multi-user picker field

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 5.0.1, 8.5.1, 8.6.1, 8.13.1, 8.13.6
    • Custom fields

    Description

      Issue Summary

      When attempting to edit/create an issue where there is a multi-user picker field with inactive users, an ERROR appears and I am not able to perform the edit/create action.

      Steps to Reproduce

      Scenario #1

      1. Create a multi-user picker custom field, disable the filtering for it (JRASERVER-40963) and add it to create and edit screens.
      2. Create a user.
      3. Create an issue and set the custom field to this user.
      4. Under Administration>User management, click on Edit next to the new user and uncheck the Active box.
      5. Try to edit the issue created in step 3 (any field).

      Scenario #2

      1. Create multi-user picker custom field > set this as global context (all projects, all issue types)
        • Do not associate this with any screens.
      2. Set default value to a specific user, let's say userone
      3. Set userone as inactive
      4. Create an issue in any project

      Scenario #3

      1. Create multi-user picker custom field > Associate it with JSM project/s
      2. Add the custom field to the appropriate create/edit screens
      3. For the correlating request type add the custom field to the request form field list > hide the field > and set a preset value for the custom field to a specific user, let's say userone
      4. Set userone as inactive
      5. Attempt to remove userone from the preset value for the custom field on the request type configuration screen

      Expected Results

      Should be able to edit and create the issue.

      Actual Results

      You'll receive an ERROR mentioning "User 'x' is not valid for this user picker" and you'll not be able to edit the issue (see attached screenshot).

      Workaround #1

      The workaround, for now, is to re-activate the user in question, make sure they are not granted any application access to not impact the number of users for the license. Under Administration>User management, click on Edit next to the new user and check the Active box.

      Workaround #2

      Remove the inactive user from the field.

      Workaround #3

      Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

      1. Identify the custom field ID for the custom field added to the request type form.
        • You can do this by navigating the Jira Administration > Issues > Custom fields > and edit the custom field in question. In the URL you will see an "ID" appended to the end of the address which is the custom field ID.
      i.e. <baseurl>/jira/secure/admin/EditCustomField!default.jspa?id=10110
      1. Query the "AO_54307E_VIEWPORTFIELDVALUE" table, which is where the preset values for forms are stored to confirm you are seeing the inactive username set for the custom field ID retrieved above.
        select * from AO_54307E_VIEWPORTFIELDVALUE  
      1. After confirming the user is registered as a preset value for the custom field in question on the AO_54307E_VIEWPORTFIELDVALUE table you will want to delete the row as shown below
        delete from AO_54307E_VIEWPORTFIELDVALUE where FIELD_NAME = '<insert custom field ID here>' AND VALUE = <insert username here>

        i.e.

        delete from AO_54307E_VIEWPORTFIELDVALUE where FIELD_NAME = 'customfield_10110' AND VALUE = 'john.doe'  
      1. Restart Jira 

       

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mdhahak@atlassian.com Meriem Dhahak
              Votes:
              33 Vote for this issue
              Watchers:
              37 Start watching this issue

              Dates

                Created:
                Updated: