SharePoint 2019 UIL missing some accounts

Michel AL HAYEK 187 Reputation points
2023-05-10T18:00:12.08+00:00

I am facing weird behavior in SP2019. The user profile service successfully synced all users from the AD, but when I provide access to some users on a SharePoint site, the user gains access but remains invisible in the SP group, from the sp designer you can see the user in the group but not from the browser. Also, in the UIL (user information list) the user does not exist, even after the first login the user was not created in the UIL. any idea?

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,221 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,623 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,799 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 17,875 Reputation points
    2023-05-10T18:27:39.2433333+00:00

    The behavior you described in SharePoint 2019 can be quite puzzling. Here are a few suggestions to investigate and potentially resolve the issue:

    User Profile Synchronization: Confirm that the User Profile Synchronization service is running correctly and has successfully synchronized the user profiles from Active Directory. Check the synchronization logs for any errors or warnings that might indicate issues with the synchronization process.

    SharePoint User Information List (UIL): The User Information List is typically located in the site collection's root site at http://<sitecollectionurl>/_catalogs/users/simple.aspx. Ensure that the User Information List is not corrupted or experiencing any issues. You may want to try the following steps:

    • Restart the SharePoint Timer Service on all servers in the farm.
    • Perform an IISRESET on all servers in the farm.
    • Run the SharePoint Products Configuration Wizard to ensure the farm is in a healthy state.

    SharePoint Group Visibility: Verify that the SharePoint groups are set to display all users. You can check this by going to the group settings in the SharePoint site and ensuring that the option "Who can view the membership of the group?" is set to "Everyone" or "Everyone except external users."

    Browser Cache: Clear the browser cache on the client machine where you are experiencing the visibility issue. Sometimes, caching can cause discrepancies between the actual group membership and what is displayed in the browser.

    Replicate the Issue: Test the behavior with different users and different SharePoint sites to see if the issue is specific to a particular user or site. This will help determine if the problem is isolated or systemic.

    Permissions and Security Trimming: Confirm that the user has the necessary permissions to access the SharePoint site and the site's contents. Also, ensure that security trimming is not affecting the visibility of the user in certain areas of the site.

    If the issue persists after trying these steps, it may be helpful to review SharePoint logs (ULS logs) for any related errors or warnings.

    0 comments No comments

  2. Vahid Ghafarpour 17,875 Reputation points
    2023-05-10T18:27:48.1566667+00:00

    The behavior you described in SharePoint 2019 can be quite puzzling. Here are a few suggestions to investigate and potentially resolve the issue:

    User Profile Synchronization: Confirm that the User Profile Synchronization service is running correctly and has successfully synchronized the user profiles from Active Directory. Check the synchronization logs for any errors or warnings that might indicate issues with the synchronization process.

    SharePoint User Information List (UIL): The User Information List is typically located in the site collection's root site at http://<sitecollectionurl>/_catalogs/users/simple.aspx. Ensure that the User Information List is not corrupted or experiencing any issues. You may want to try the following steps:

    • Restart the SharePoint Timer Service on all servers in the farm.
    • Perform an IISRESET on all servers in the farm.
    • Run the SharePoint Products Configuration Wizard to ensure the farm is in a healthy state.

    SharePoint Group Visibility: Verify that the SharePoint groups are set to display all users. You can check this by going to the group settings in the SharePoint site and ensuring that the option "Who can view the membership of the group?" is set to "Everyone" or "Everyone except external users."

    Browser Cache: Clear the browser cache on the client machine where you are experiencing the visibility issue. Sometimes, caching can cause discrepancies between the actual group membership and what is displayed in the browser.

    Replicate the Issue: Test the behavior with different users and different SharePoint sites to see if the issue is specific to a particular user or site. This will help determine if the problem is isolated or systemic.

    Permissions and Security Trimming: Confirm that the user has the necessary permissions to access the SharePoint site and the site's contents. Also, ensure that security trimming is not affecting the visibility of the user in certain areas of the site.

    If the issue persists after trying these steps, it may be helpful to review SharePoint logs (ULS logs) for any related errors or warnings.


  3. Emily Du-MSFT 41,786 Reputation points Microsoft Vendor
    2023-05-11T07:57:46.8566667+00:00

    A SharePoint site refers to a site collection or a sub site? If it is a sub site, it has unique permissions?

    Whether you grant access to users directly or grant access to AD group including some users?

    If you grant access to users directly, users are added automatically into the hidden user information list and show in the SharePoint group.

    If you grant access to AD group including some users, the AD group is added automatically into the user information list and show in the SharePoint group. Users in the AD group will be show after a certain access.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.