Integrity Check Error: Object refers to a missing user

 Problem

During an Integrity Check scan, objects that refer to a missing user are found.

Open

 Solution

1. The general solution is to remove all references of the missing user from the missing object (boards) or create the user so it's available on the system. Integrity error types | Missing objectPreview

2. In some cases, the object shows all the users as active, and the user reference cannot be found to remove or modify it.
   
   

   • This is because the Jira system may still reference a user who has been deleted from the user interface but remains in the database. This causes inconsistencies during integrity checks.

   • To identify the deleted user, run the following SQL query on the database to check for the user's presence:

     SELECT * from app_user WHERE user_key = 'JIRAUSERXXXXX'

     or run the REST API : $JIRA_URL/rest/api/2/user?key=JIRAUSERXXXXX
     Note:- Please replace JIRAUSERXXXXX with the user that is seen in the error, for example, JIRAUSER57721

   • Execute the following SQL query to determine if the deleted user is listed as the owner of any boards:

     SELECT * from AO_60DB71_RAPIDVIEW

   • Also, check the filter query of the boards to see if the user is present in the JQL query

   • If references to the deleted user are found, update the board to point to an existing user or delete the reference.