Error: F_JR2D12 Repository Properties Access_List and User_Access Cannot Be Used Together

Issue

When both Access_List and User_Access properties are configured in the same HVR repository, the following error appears when running hvrreposconfig.

F_JR2D12: Repository properties Access_List and User_Access cannot be used together

Environment

HVR 6

Resolution

To resolve this issue, do the following:

Back up your repository database and export current settings:
```
hvrreposconfig -o <filename>.json
```
Make a copy of this JSON file for rollback purposes.
Edit the JSON file:
i. Remove the Access_List property and its settings.
ii. Add a User_Access block with users and their access rights. For example:
```
"User_Access": {
  "user1": {"sysadmin": true},
  "user2": {"readmetering": true}
}
```
iii. Preserve sensitive fields such as keys by fetching their current values from the hvr_repos_property table.
Apply the new configuration:
```
hvrreposconfig -a -i <filename>.json
```
Validate the changes:
i. Confirm that hvrreposconfig now shows only User_Access.
ii. Log out and log in again. Restart the HVR hub as needed to confirm the new configuration is active.
iii. Test user access and permissions.

Before changing a production hub, test the steps on a non-production environment. Keep the rollback JSON file so you can restore the previous configuration if needed. Do not directly modify repository tables unless instructed by Fivetran support.

Cause

This issue occurs because Access_List and User_Access are mutually exclusive repository properties. Only one can be active for a hub. For HVR versions HVR 6.1.5/2 and later, the -A option is deprecated and User_Access is recommended. Legacy environments that still use Access_List trigger this error if User_Access is also present. For more information, see our User_Access and Access_List documentation.