Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Matt 8 posts 28 karma points
    Apr 07, 2014 @ 19:51
    Matt
    0

    'Failed to retrieve data for application tree content' error in Umbraco 7.1.0

    Can someone please help, I can't see my content tree anymore. Here's a little extract from my log file; there's a lot more if you need it.

    2014-04-07 18:14:35,093 [41] INFO  umbraco.content - [Thread 21] Loading content from disk cache...

    2014-04-07 18:14:36,596 [41] INFO  Umbraco.Core.PluginManager - [Thread 43] Starting resolution types of Umbraco.Core.PropertyEditors.IParameterEditor

    2014-04-07 18:14:36,598 [41] INFO  Umbraco.Core.PluginManager - [Thread 43] Completed resolution of types of Umbraco.Core.PropertyEditors.IParameterEditor, found 43 (took 1ms)

    2014-04-07 18:14:45,257 [41] INFO  Umbraco.Core.PluginManager - [Thread 19] Starting resolution types of Umbraco.Core.Persistence.Mappers.BaseMapper

    2014-04-07 18:14:45,258 [41] INFO  Umbraco.Core.PluginManager - [Thread 19] Completed resolution of types of Umbraco.Core.Persistence.Mappers.BaseMapper, found 22 (took 0ms)

    2014-04-07 18:14:45,531 [41] INFO  Umbraco.Core.PluginManager - [Thread 19] Starting resolution types of umbraco.interfaces.ICacheRefresher

    2014-04-07 18:14:45,532 [41] INFO  Umbraco.Core.PluginManager - [Thread 19] Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 20 (took 0ms)

    2014-04-07 18:14:45,751 [41] INFO  Umbraco.Web.Security.WebSecurity - [Thread 19] User Id: 0 logged in

    2014-04-07 18:14:45,994 [41] INFO  Umbraco.Core.PluginManager - [Thread 44] Starting resolution types of Umbraco.Web.Trees.TreeController

    2014-04-07 18:14:45,994 [41] INFO  Umbraco.Core.PluginManager - [Thread 44] Completed resolution of types of Umbraco.Web.Trees.TreeController, found 4 (took 0ms)

    2014-04-07 18:14:46,089 [41] INFO  Umbraco.Core.PluginManager - [Thread 40] Starting resolution types of umbraco.interfaces.ITree

    2014-04-07 18:14:46,091 [41] INFO  Umbraco.Core.PluginManager - [Thread 40] Completed resolution of types of umbraco.interfaces.ITree, found 35 (took 1ms)

    2014-04-07 18:16:54,611 [41] INFO  Umbraco.Web.Security.WebSecurity - [Thread 29] User Id: 1 logged in

    2014-04-07 18:17:12,655 [41] INFO  Umbraco.Web.Security.WebSecurity - [Thread 29] User Id: 0 logged in

    Copy Link
  • Matt 8 posts 28 karma points
    Apr 08, 2014 @ 10:09
    Matt
    0

    Here is the stack trace:

    at Umbraco.Core.Mandate.That[TException](Boolean condition, Func`1 defer) in d:\Dev\Umbraco7\src\Umbraco.Core\Mandate.cs:line 98
   at Umbraco.Core.Models.ContentBase..ctor(String name, Int32 parentId, IContentTypeComposition contentType, PropertyCollection properties) in d:\Dev\Umbraco7\src\Umbraco.Core\Models\ContentBase.cs:line 44
   at Umbraco.Core.Models.Content..ctor(String name, Int32 parentId, IContentType contentType, PropertyCollection properties) in d:\Dev\Umbraco7\src\Umbraco.Core\Models\Content.cs:line 71
   at Umbraco.Core.Models.Content..ctor(String name, Int32 parentId, IContentType contentType) in d:\Dev\Umbraco7\src\Umbraco.Core\Models\Content.cs:line 56
   at Umbraco.Core.Persistence.Factories.ContentFactory.BuildEntity(DocumentDto dto) in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\Factories\ContentFactory.cs:line 32
   at Umbraco.Core.Persistence.Repositories.ContentRepository.CreateContentFromDto(DocumentDto dto, Guid versionId) in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\Repositories\ContentRepository.cs:line 593
   at Umbraco.Core.Persistence.Repositories.ContentRepository.PerformGet(Int32 id) in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\Repositories\ContentRepository.cs:line 75
   at Umbraco.Core.Persistence.Repositories.RepositoryBase`2.Get(TId id) in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\Repositories\RepositoryBase.cs:line 97
   at Umbraco.Core.Persistence.Repositories.ContentRepository.d__24.MoveNext() in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\Repositories\ContentRepository.cs:line 113
   at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
   at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source)
   at Umbraco.Web.Trees.ContentTreeControllerBase.GetTreeNodes(String id, FormDataCollection queryStrings)
   at Umbraco.Web.Trees.TreeControllerBase.GetNodes(String id, FormDataCollection queryStrings)
   at Umbraco.Web.Trees.ApplicationTreeExtensions.TryLoadFromControllerTree(ApplicationTree appTree, String id, FormDataCollection formCollection, HttpControllerContext controllerContext)
   at Umbraco.Web.Trees.ApplicationTreeController.d__17.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Umbraco.Web.Trees.ApplicationTreeController.d__4.MoveNext()
    Copy Link
  • Matt 8 posts 28 karma points
    Apr 08, 2014 @ 11:43
    Matt
    1

    Well, that was dissapointing. First time I've posted in a forum for years and this is why, once again I resolved it myself with no help. This is something that I think Umbraco team need to look into however because I resolved it by deleteing the last nodes I created and all their dependencies but why would have creating some content through the CMS have caused this all on its own anyway? Here are the tables I had to delete from to get it working again.

     

    DELETE FROM cmsPreviewXml WHERE nodeId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsContentVersion WHERE ContentId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsDocument WHERE nodeId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsContent WHERE nodeId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsDocumentType WHERE templateNodeId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsTemplate WHERE nodeId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsContentType2ContentType WHERE parentContentTypeId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsContentType2ContentType WHERE childContentTypeId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsContentTypeAllowedContentType WHERE Id IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsContentTypeAllowedContentType WHERE AllowedId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM cmsContentType WHERE nodeId IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    DELETE FROM umbracoNode WHERE id IN (2163, 2164, 2166, 2167, 2168, 2169, 2170, 2171);

    Copy Link
  • Edwin van Koppen 156 posts 270 karma points
    Jul 10, 2014 @ 15:31
    Edwin van Koppen
    0

    Thanks Matt, for the query! I've changed it somewhat and added the cmsPropertyData for version 7.1.4. Change the ids (or add / delete) for what nodes you want to delete.

    BEGIN TRAN

DECLARE @Ids TABLE (
id int
)
INSERT INTO @Ids SELECT 2200
INSERT INTO @Ids SELECT 2201 

DELETE FROM cmsPreviewXml WHERE nodeId IN (SELECT Id FROM @Ids);
DELETE FROM cmsContentVersion WHERE ContentId IN (SELECT Id FROM @Ids);
DELETE FROM cmsDocument WHERE nodeId IN (SELECT Id FROM @Ids);
DELETE FROM cmsContent WHERE nodeId IN (SELECT Id FROM @Ids);
DELETE FROM cmsDocumentType WHERE templateNodeId IN (SELECT Id FROM @Ids);
DELETE FROM cmsTemplate WHERE nodeId IN (SELECT Id FROM @Ids);
DELETE FROM cmsContentType2ContentType WHERE parentContentTypeId IN (SELECT Id FROM @Ids);
DELETE FROM cmsContentType2ContentType WHERE childContentTypeId IN (SELECT Id FROM @Ids);
DELETE FROM cmsContentTypeAllowedContentType WHERE Id IN (SELECT Id FROM @Ids);
DELETE FROM cmsContentTypeAllowedContentType WHERE AllowedId IN (SELECT Id FROM @Ids);
DELETE FROM cmsContentType WHERE nodeId IN (SELECT Id FROM @Ids);
DELETE FROM cmsPropertyData WHERE contentNodeId IN (SELECT Id FROM @Ids);
DELETE FROM umbracoNode WHERE id IN (SELECT Id FROM @Ids);

COMMIT TRAN
    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies