You can translate the question and the replies:

Error editing resource manager rule: field not found 'roles' in view with schema

Hi All, When trying to create a rule in resource manager using roles.value condition getting error like below: Error editing resource manager rule: field not found 'roles' in view with schema Same seems to work in dev environment but not in UAT.
user
30-03-2021 02:16:20 -0400

3 Answers

Hi, You could use the** ‘(roles).value’ **attribute to assign a rule to the user having the particular role like: > (roles).value = ‘<role_name>’ In case of any errors when specifying the rules, I would do the following checks: * Check whether the role exists in the Virtual DataPort. * Check the vdp.log file under the** “<DENODO_HOME>\logs\vdp” **directory by setting the log level to **‘TRACE’** to get more information on this error. To change the log level, I would use the below query in the VQL Shell of the Virtual DataPort Administration Tool: `CALL LOGCONTROLLER ('com.denodo.vdp','trace')` You can take a look at the **[Resource Manager: Available Fields to Evaluate a Rule](https://community.denodo.com/docs/html/browse/latest/en//vdp/administration/appendix/resource_manager_available_fields_to_evaluate_a_rule/resource_manager_available_fields_to_evaluate_a_rule#resource-manager-available-fields-to-evaluate-a-rule)** section of the Virtual DataPort Administration Guide. Additionally, if you still need help and if you are a user with valid support access then you can create a support case in**[ Denodo Support Site](https://support.denodo.com/)** so that our support team will assist you further. Hope this helps!
Denodo Team
30-03-2021 08:45:48 -0400
Thank you very much! 1. yes Role exists in VDP. 2. Am not allowed to change the log level to Trace:( Could you please let me know the exact configuration file where roles(value) parameter would be maintained in metadata? I believe the issue is with roles parameter in UAT which is not ehc ase in DEV so i can compare and see? Thanks again!
user
31-03-2021 09:34:18 -0400
Hi, The **roles(value)** parameter is maintained in the Virtual DataPort server metadata. If I want to retrieve the list of privileges assigned to the specific role, I would use the **[DESC](https://community.denodo.com/docs/html/browse/8.0/en//vdp/developer/appendix/output_schema_of_the_desc_commands/output_schema_of_the_desc_commands#output-schema-of-the-desc-commands)** command or the **[CATALOG_PERMISSIONS](https://community.denodo.com/docs/html/browse/latest/en//vdp/vql/stored_procedures/predefined_stored_procedures/catalog_permissions#catalog-permissions)** Predefined Stored Procedure. > DESC role <role_name> > CALL CATALOG_PERMISSIONS('<role_name>') For finding the difference in the role, you could execute these queries in the Virtual DataPort Administration Tool of both the environments (UAT and DEV ) and compare those results in the role privileges which might have caused the issue. You can also use the **[GET_CATALOG_EFFECTIVE_PERMISSIONS](https://community.denodo.com/docs/html/browse/latest/en//vdp/vql/stored_procedures/predefined_stored_procedures/get_catalog_effective_permissions#get-catalog-effective-permissions)** Stored Procedure to check the effective privileges and restrictions assigned for you over the Virtual DataPort elements using the query like > CALL GET_CATALOG_EFFECTIVE_PERMISSIONS('<user_name>') **NOTE: **The result of these queries varies depending on the privileges of the user who executes it. Additionally, if you are a user with valid support access, create a support case in **[Denodo Support Site](https://support.denodo.com/)** so that our support team will assist you further in resolving this issue. Hope this helps!
Denodo Team
08-04-2021 07:44:02 -0400
You must sign in to add an answer. If you do not have an account, you can register here