Missing roles in User Manager

[eleonard]

When I try to assign permissions in User Manager, the roles "Survey Administrator" and "Survey Editor" are sometimes missing from the list. It seems the system doesn't allow more than 8 people to have this role, because when I remove "Survey Administrator" and "Survey Editor" from one user's permission, they again become available for another user.

We have a 10-license version of Checkbox (4.6), so how is it that we can only have 8 Survey Administrators/Editors?

If there is some kind of limitation on the number of simultaneous Survey Administrators, I need to know now, because we are in the process of deciding if we will buy another license pack.

Thanks!

Eve

[eleonard]

I made some progress finding the source of the problem, but I still don't know how to fix it.

When I go to Settings -> Application, under License Information -> License Limit, I see "10 used". Clicking on it brings me to a list of users with the Form.Edit permissions, and there are indeed 10 of them. However, I cannot see some of them in User Manager, so I am unable to delete them from the system.

One user is entered in the following format: domain/domain\username. It's as if the domain name was entered twice: once in the same field as the username and once in the "domain" field. (We use Checkbox internally and it recognizes the Active Directory credentials.) Could that be the problem? If so, how do I delete this user?

Eve

[pwiesner]

It is unclear why you can not see all of the users. If you contact the support team they will be able to review your database and try to get a better understanding of what has caused this issue. You can either open a support ticket online (Checkbox Support Login) or contact the support team by phone, +1 617-715-9600.

That being said, if you are comfortable with SQL you should be able to delete the users yourself using the query below.

--BEGIN
DELETE FROM ckbx_IdentityRoles WHERE [UniqueIdentifier] = 'ADD_USERNAME'
GO
DELETE FROM ckbx_Credential WHERE [UniqueIdentifier] = ''ADD_USERNAME'
GO
--END

You will need to replace ADD_USERNAME with the unique identifier of the user you would like to remove. The unique identifier value can be found in the ckbx_Credential table.

Before making any changes to your database we strongly suggested making a full back up of your database.

[eleonard]

Thank you pwiesner, the tech was able to delete the stuck user directly in the sql database.