Deleting taxonomy broke ability to edit user.
Hi All,
I am having an issue with user profiles.
I added 2 Classifications to the user profile but the related taxonomies were bad so I deleted them. Now I get an error when accessing the user:
----------------------------------------
Timestamp: 10/7/2015 5:51:09 PM
Message: HandlingInstanceID: 389aeb6b-1caf-4ac3-b497-664d7eeec9c5
An exception of type 'Telerik.Sitefinity.SitefinityExceptions.ItemNotFoundException' occurred and was caught.
-------------------------------------------------------------------------------------------------------------
10/07/2015 13:51:09
Type : Telerik.Sitefinity.SitefinityExceptions.ItemNotFoundException, Telerik.Sitefinity, Version=8.0.5710.0, Culture=neutral, PublicKeyToken=b28c218413bdf563
Message : You are trying to access item that no longer exists. The most probable reason is that it has been deleted by another user.
Source : Unity_ILEmit_DynamicClasses
Help link :
Data : System.Collections.ListDictionaryInternal
TargetSite : Telerik.Sitefinity.Taxonomies.Model.ITaxonomy GetTaxonomy(System.Guid)
HResult : -2146233088
Stack Trace : at DynamicModule.ns.Wrapped_OpenAccessTaxonomyProvider_141efa69118946b89de185bb70117b81.GetTaxonomy(Guid id)
at Telerik.Sitefinity.Taxonomies.TaxonomyManager.GetTaxonomy(Guid id)
at Telerik.Sitefinity.Web.UI.Fields.TaxonField.get_Taxonomy()
at Telerik.Sitefinity.Web.UI.Fields.HierarchicalTaxonField.InitializeControls(GenericContainer container)
at Telerik.Sitefinity.Web.UI.SimpleView.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Additional Info:
MachineName : DEV001
TimeStamp : 10/7/2015 5:51:09 PM
FullName : Telerik.Sitefinity.Utilities, Version=8.0.5710.0, Culture=neutral, PublicKeyToken=b28c218413bdf563
AppDomainName : /LM/W3SVC/4/ROOT-1-130887136338458614
ThreadIdentity : admin
WindowsIdentity : DEV001\XXXXXX
Requested URL :XXXXX.XXXXX.XXXXX.XXXXX/.../UserEditDialog
Category: ErrorLog
Priority: 0
EventId: 90000
Severity: Error
Title:Enterprise Library Exception Handling
Machine: DEV001
App Domain: /LM/W3SVC/4/ROOT-1-130887136338458614
ProcessId: 10076
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Thread Name:
Win32 ThreadId:8064
Extended Properties:
----------------------------------------
I have found this: www.telerik.com/.../error-when-creating-user and while it is the same issue, the answer does not fix my issue.
I simply need to remove this broken relationship so I can add info to the user profile. Can anyone point me at the DB table that contains this broken relationship?
Thanks,
as a follow up, the SQL profiler is showing the following being executed when clicking a user:
declare
@p1
int
<br>
set
@p1=74
exec
sp_prepexec @p1
output
,N
'@p0 uniqueidentifier'
,N
'SELECT [voa_class] AS COL1, [description_] AS COL2, [taxon_name_] AS COL3, [title_] AS COL4, [app_name] AS COL5, [can_inherit_permissions] AS COL6, [inherits_permissions] AS COL7, [last_modified] AS COL8, [nme] AS COL9, [ownr] AS COL10, [root_id] AS COL11, [root_id] AS COL12, [voa_version] AS COL13 FROM [sf_taxonomies] WHERE [id] = @p0 '
,@p0=
'18FC7793-8600-68C6-8594-FF0000193AE5'
select
@p1
The problem is the GUID it is using does not exist. I have searched all tables in the db and this GUID is not stored in the DB. I also checked the enitre solution as well as all the configuration files. Where is it getting this ID?????
Hello,
Please try to create a taxonomy with the same name as the one which has been deleted, then remove the taxonomy values from the profile and delete them again. As a workaround you can navigate to Administration -> Users -> Manage Profile types -> <choose your profile> and remove all fields that are based on taxonomies.
Regards,
Stefani Tacheva
Telerik