Supplies: Error when changing roles of users (post v7.0)

Error: NoSuchMessageException: No message found under code 'rbac_resource_supply' for locale 'en_US'. (COMMON_SERVER_ERROR)

Note: Confirm that you are not using the Supplies plugin. If yes, contact Krishagni support.

Error occurs because the roles are associated to ‘Supplies’ resource even after removing the supplies plugin.

The error can be resolved in two ways:

Via User Interface:

Sign in as Super admin.
Go to Roles --> Administrator.

Click on edit --> Supplies
Click on the delete icon to remove the privilege --> Update.

Via database:

Note down the identifier of the below query.

select * from rbac_resources where name = 'Supply';

Cleanup the supply resource

delete from rbac_role_access_list where RESOURCE_ID = <identifier of query #1>;

delete from rbac_role_access_list_ops where ACL_ID in (select identifier from rbac_role_access_list where RESOURCE_ID = <identifier of query #1>);

delete from rbac_resources where name = 'Supply';