Error when changing roles of users (in v7.0)

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

Note: Confirm that client is not using the supplies module in the OpenSpecimen then only run below SQLs. If client is using supplies module then deploy the supplies plugin on that OpenSpecimen instance.

In the latest versions (v7.0), the supplies module have removed from core application. The above error comes because of the supply resource and its associated permissions are still present in the database. Cleanup this by running below SQLs on OpenSpecimen 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';