Devolutions web administration - unable to manage group membership

Implemented

Devolutions web administration - unable to manage group membership

avatar

We have run into a very strange issue. My colleague tried to add a user into the group. The result was that the group got empty (instead of having the user added to the other members).

Since than I am not able to add any new member into any group. Even by going to group and modify membership. Nor by going into the user defaults and adding him into the group.

I had to restore the database to have the users back to the groups (so the users can continue to work). But still we have this issue and we are unable to modify membership of groups.

 

Please has anyone experienced that? Is there some space where we could find more debug info?

 

All Comments (13)

avatar

Hello,

What DVLS version are you using?

What authentication type are you using in DVLS?

Do you see any relevant errors in the DVLS logs?

https://kb.devolutions.net/dvls_viewdatasourcelogs.html

Best regards,

Érica Poirier

avatar

Hello Erica,

we were on 2022.2.8.0, but after the issue I have upgraded on the latest version (2022.2.9.0).

We are using only Devolution native authentication (users and groups).

The datasource log contains several instances of one error, but I don't think it is related to this issue (but still I attach it to this post).

avatar

Hello Martin,

The SQL error seems to indicate an issue with the date format:

SqlTypeException - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

If you go in SSMS, could you verify what collation you have configured for the database? You can view it in the properties of the database.

Best regards,

Richard Boisvert

avatar

Hello Martin,

The issue was fixed internally in the 2022.3 release. The team will be verifying if they can release that specific fix sooner, since the next major release is planned for November.

Best regards,

Richard Boisvert

avatar

Hi Richard,

sorry for the delay in communication, I have been out of office last week.

Our DB collation is "Latin1_General_CI_AS". Should I change it?

Regarding the fix. You mean that you have found the cause of the group membership issue and fixed it? Or you have fixed the "date format" problem?

The problem with group membership is severe for us, as I cannot add or remove users from groups.

avatar

Hello Martin,

According to engineering, the date format error is causing your issue.

The 2022.2.10 version, which contains the fix, is planned to release early next week (5-6) since tomorrow is a holiday for us.

Best regards,

Richard Boisvert

avatar

Perfect, thank you very much. Once it is out I will test it and let you know.

avatar

Hello Martin,

DVLS version 2022.2.10 is now available with the fix for the error you encountered: https://devolutions.net/server/home/thankyou/dpsconsolebin

Let us know if you still have an issue after!

Best regards,

Richard Boisvert