RoleLocalServiceUtil.getResourceRoles(long, String, int, String) always throws a NullPointerException due to missing SQL query

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE, 7.0.X EE, Master
• Fix Version/s: 6.2.X EE, 7.0.0 DXP FP13, 7.0.0 DXP SP3, 7.0.3 CE GA4, 7.0.X EE, 7.1.X, Master
• Component/s: User Management, User Management > Roles
• Labels:
  • 62-ee-sp19
  • liferay-digital-enterprise-70-sp3
  • liferay-fixpack-de-13-7010
  • liferay-fixpack-portal-144-6210
• Branch Version/s:
  7.0.x, 6.2.x
• Backported to Branch:
  Committed
• Story Points: 1
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/47820

Description
The RoleLocalServiceUtil.getResourceRoles(long, String, int, String) method is completely unusable because its SQL query is missing from portal.xml. Calling this method will always result in a NullPointerException being thrown.

Steps to Reproduce

1. Start up Liferay
2. Log in as an administrator.
3. Navigate to Admin > Control Panel > Server Administration > Scripts
4. Change Language to Groovy.
5. Paste the contents of the attached callGetResourceRoles.groovy file into the Script box (use the file that corresponds to the version of Liferay you are testing on).
6. Click execute.

Expected Result: The script will complete without error. For this script, this will most likely just return an empty map as follows:

[:]

If you want to test it in more detail, you can modify the name, scope, and primKey variables to match an entry in the ResourcePermission table and see the map that is returned.
Actual Result: The script throws a NullPointerException, which you can see in the console. The map of resource roles is not printed out.

Reproduced in:
master - a61624d5129b8d26f7ba6a9c07f76130fd565b28: Reproduced
ee-7.0.x - 606d9d902aef50ca425f401e51ef30ff8d02e70e - Reproduced
ee-6.2.x - da614c15129e7e4f4fc1721372f3621f44adb365: Reproduced