17-09-2020, 06:33 PM
I recently encountered an issue where ASG-RD thought my database needed to be upgraded. When I attempted to let it run, it errored out on the 2015Patch2 update script. After a little digging, I found the issue was caused by this index rebuild:
The issue is that the index drop is pointing at the wrong table (SecurityGroupUsers) instead of the Users table. The index commands immediately prior to this were against the SecurityGroupUsers table, so I suspect this was a copy/paste error. I went through the CloudAdminDataAccess.dll all the way back to 2015 Patch 2 and found that the error was there but since the index was probably created in patch 2, this wouldn't be caught.
To work around this issue, I had to manually delete IX_Users from the Users table, then launch ASG-RD and let it run the upgrade. The scripts were able to run as expected and I could get back in.
Please fix this resource script in CloudAdminDataAccess.dll in the next patch.
Code:
IFÂ EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Users]') AND name = N'IX_Users_1')
DROP INDEX [IX_Users_1] ON [dbo].[SecurityGroupUsers] WITH ( ONLINE = OFF )
GO
CREATE NONCLUSTERED INDEX IX_Users_1 ON dbo.Users
(
Type ASC,
Domain ASC,
Name ASC
) ON [PRIMARY]
GOThe issue is that the index drop is pointing at the wrong table (SecurityGroupUsers) instead of the Users table. The index commands immediately prior to this were against the SecurityGroupUsers table, so I suspect this was a copy/paste error. I went through the CloudAdminDataAccess.dll all the way back to 2015 Patch 2 and found that the error was there but since the index was probably created in patch 2, this wouldn't be caught.
To work around this issue, I had to manually delete IX_Users from the Users table, then launch ASG-RD and let it run the upgrade. The scripts were able to run as expected and I could get back in.
Please fix this resource script in CloudAdminDataAccess.dll in the next patch.
