Note: This issue is corrected in version 8.5
For 8.1
1. Run the following query in SQL Management Studio
--Enter Domain\Username of the affected user here
declare @user as nvarchar (250) = 'Domain\Username'
declare @ug as uniqueidentifier
set @ug = (select top 1 '{' + cast (Guid as nvarchar (50)) + '}'
from vRM_Trustee_Item where name = @user)
--select *--SUBSTRING (id, 34, 32) Guid
delete
from UserSettings
where LEN (Id) = 65
and id like '%_%'
and Sid = @ug
and SUBSTRING (id, 34, 32) in
( select replace (Guid, '-', '') Guid
from vitem
where ClassGuid = 'AA232A71-E633-4F4A-A48F-BCCCC7535269'
and ProductGuid = 'B1338338-5575-4A27-9808-23BEC40D79FA')
2. Restart IIS from CMD Prompt on SMP: IISReset
Note: Part of the data is stored in the IIS Metadata and needs to be cleared.
3. Open NS Console and Open the problem Report: As it is loading you may still see the old view but wait until the page has loaded and press the refresh button.
For 7.5, 7.6, and 8.0
Work through the following on the SMP
1. Log into the Notification Server as Problem User
2. In NS Console change view to NOT look at the problem report
3. Open a CMD Prompt and type
whoami /user
4. Copy the SID for the Problem User
It will look something like 'S-1-5-21-1212121212-3434343434-5656565656-500'
5. Run the following Script in SQL Server Management Studio:
declare @sid as nvarchar (max)
set @sid = 'Place SID Here'
delete us
from UserSettings us
join ResourceAssociation ra on ra.ParentResourceGuid = us.[Sid]
and ra.ResourceAssociationTypeGuid = '4582ADBC-43FA-4783-807A-A3CD7D58992C'--Account Credential
join item i on i.Guid= ra.ResourceAssociationTypeGuid
join ResourceKey rk on ra.ChildResourceGuid = rk.ResourceGuid
AND rk.KeyName = 'sid'
AND rk.KeyValue = @sid
where Id like '%MyReportView%'
6. Restart IIS from CMD Prompt on SMP:
IISReset
Note: Part of the data is stored in the IIS Metadata and needs to be cleared.
7. Open NS Console and Open the problem Report: As it is loading you may still see the old view but wait until the page has loaded and press the refresh button.
Thanks for your feedback. Let us know if you have additional comments below. (requires login)