Issue with security groups in ASG-RD 2018 P6

[Peteng]

Hi,

I have noticed that suddenly, the security groups have started to create one group per user.
Earlier today we had 1 group with several members, now its 1 group per member.
Is this a possible bug or something that can be reversed?

I'd like to, not have to revert back to a previous DB backup in order to restore the order..

Screenshot of securitygroup


Any ideas on how to solve this?

[DevOma]

I think that is a known bug - but we didn't had any (other) SQL updates in the last year so this bug is still alive in older database versions

Please try the following command on your SQL database - it just add a "Order By " to the SQL command

ALTER PROCEDURE [dbo].[SecurityGroupGetAll]
AS
BEGIN
SELECT * FROM SecurityGroups Groups LEFT OUTER JOIN SecurityGroupUsers AssignedUsers ON (Groups.GroupId = AssignedUsers.GroupId) ORDER BY Groups.GroupId
END
GO

[Peteng]

I think that is a known bug - but we didn't had any (other) SQL updates in the last year so this bug is still alive in older database versions

Please try the following command on your SQL database - it just add a "Order By " to the SQL command

ALTER PROCEDURE [dbo].[SecurityGroupGetAll]
AS
BEGIN
SELECT * FROM SecurityGroups Groups LEFT OUTER JOIN SecurityGroupUsers AssignedUsers ON (Groups.GroupId = AssignedUsers.GroupId) ORDER BY Groups.GroupId
END
GO

Thank you. This resolved the matter. But it seems ASG-RD crashed for all connected users.

[DevOma]

Really? Just through an update of an stored proc? Wow...

[thogud]

Seems it just happened for the users that were "logging" to the DB in some way at the same time as the DB command ran. Like connecting to a connection etc (probably due to the connection logs).