Assign Users to This Site dialog is broken when enable Limit membership to members of the parent site

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.2.X, Master
• Fix Version/s: 7.2.10 DXP FP8, 7.2.10.3 DXP SP3, 7.2.X, 7.3.1 CE GA2, 7.3.2 CE GA3, 7.3.4 CE GA5, 7.3.10 DXP GA1, Master
• Component/s: User Management, User Management > Users & Organizations
• Labels:
  • QA-AUTOMATION
  • QA-FP
  • ee-ts
  • liferay-dxp-72-sp3
  • liferay-fixpack-dxp-8-7210
• Branch Version/s:
  7.2.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/86204
• Bug Type: Regression Bug
• QA Test Name:
  • LocalFile.SiteMemberships#LimitMembershipParentSite
• QA Test Score: 4

Step to reproduce

1. Add a new user
2. Add a parent site
3. Add a child site in parent site
4. Enable Limit membership to members of the parent site
5. Navigate to parent site
6. Site admin > People > Memberships > Users tab
7. Assign new user to parent site
8. Navigate to child site
9. Site admin > People > Memberships > Users tab
10. Click add button

Expected Results
The available users are shown in dialog.

Actual Results
The dialog is broken. The alert message Memberships is temporarily unavailable.
And the following error is thrown in browser console.

Additonally, The following error is thrown in console.

2020-03-11 13:34:22.972 ERROR [http-nio-8080-exec-9][PortletRequestDispatcherImpl:304] Unable to dispatch request: com.liferay.portal.kernel.exception.SystemException: java.lang.IllegalArgumentException: Positional parameter does not exist: 40 in query: SELECT COUNT(userId) AS COUNT_VALUE FROM ((  SELECT DISTINCT User_.userId AS userId FROM User_   INNER JOIN Users_Groups ON Users_Groups.userId = User_.userId  WHERE  Users_Groups.groupId = ?    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ((LOWER(User_.firstName) LIKE ? OR ? IS NULL) AND (LOWER(User_.middleName) LIKE ? OR ? IS NULL) AND (LOWER(User_.lastName) LIKE ? OR ? IS NULL) AND (LOWER(User_.screenName) LIKE ? OR ? IS NULL) AND (LOWER(User_.emailAddress) LIKE ? OR ? IS NULL)) AND (User_.status = ?)   ) UNION (  SELECT DISTINCT User_.userId AS userId FROM User_   INNER JOIN Users_Orgs ON Users_Orgs.userId = User_.userId INNER JOIN Groups_Orgs ON Groups_Orgs.organizationId = Users_Orgs.organizationId  WHERE  Groups_Orgs.groupId = 36213    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ((LOWER(User_.firstName) LIKE ? OR ? IS NULL) AND (LOWER(User_.middleName) LIKE ? OR ? IS NULL) AND (LOWER(User_.lastName) LIKE ? OR ? IS NULL) AND (LOWER(User_.screenName) LIKE ? OR ? IS NULL) AND (LOWER(User_.emailAddress) LIKE ? OR ? IS NULL)) AND (User_.status = ?)   ) UNION (  SELECT DISTINCT User_.userId AS userId FROM User_   INNER JOIN Users_UserGroups ON Users_UserGroups.userId = User_.userId INNER JOIN Groups_UserGroups ON Groups_UserGroups.userGroupId = Users_UserGroups.userGroupId  WHERE  Groups_UserGroups.groupId = 36213    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ((LOWER(User_.firstName) LIKE ? OR ? IS NULL) AND (LOWER(User_.middleName) LIKE ? OR ? IS NULL) AND (LOWER(User_.lastName) LIKE ? OR ? IS NULL) AND (LOWER(User_.screenName) LIKE ? OR ? IS NULL) AND (LOWER(User_.emailAddress) LIKE ? OR ? IS NULL)) AND (User_.status = ?)   )) userId

Reproduced on:
Tomcat 9.0.17 + MySQL 5.7. Portal master GIT ID: 763b60c77e5e5e449c1d5bb1e9617771e84ba37f.