Description: You'll try to create a new content type or save a new copy of an existing content and get the error "selected user does not exist." (This issue typically happens after a migration to the cloud involving Ad-Hoc permissions)
The reason this occurs is that multiple admin accounts are set for the site, one or more of which is no longer valid.
Software Version: ecmcloud.piftech.com
Solution:
SQL code
SELECT TOP 1000 [ContentTypeId]
,[UserId]
,[PermissionLevel]
FROM [dbo].[ContentTypeUserPermission]
where userid not in (select id from Astria_Host.dbo.[User])
---***Step two if results are returned***---
-- DELETE FROM [dbo].[ContentTypeUserPermission]
--where userid not in (select id from Astria_Host.dbo.[User])
,[UserId]
,[PermissionLevel]
FROM [dbo].[ContentTypeUserPermission]
where userid not in (select id from Astria_Host.dbo.[User])
---***Step two if results are returned***---
-- DELETE FROM [dbo].[ContentTypeUserPermission]
--where userid not in (select id from Astria_Host.dbo.[User])