views:

33

answers:

0

I'm editing a page on a site built with Sharepoint. I'm only editing small bits of html code here and there, and not touching any SQL statements. However, recently when I've tried to save said page I've come across an error page which reads the code below. Any ideas on how to fix this, or what the issue is? Thanks. Much appreciated. Version information is located at the bottom of the copied error page.

Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 


[SqlException (0x80131904): Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.]
   Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback(String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pSchemaCallback) +0
   Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback(String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pSchemaCallback) +265
   Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData() +2191
   Microsoft.SharePoint.SPListItemCollection.get_Count() +70
   Microsoft.SharePoint.Workflow.SPWorkflowTaskCollection.Undirty() +208
   Microsoft.SharePoint.SPBaseCollection.System.Collections.IEnumerable.GetEnumerator() +110
   Microsoft.SharePoint.Publishing.CachedListItem.GetWorkflowInfo(SPListItem item) +733
   Microsoft.SharePoint.Publishing.CachedListItem..ctor(SPListItem item, SPListItem alternateItem, NodeTypes nodeType, String id, String parentId, String title, String url, String description, CachedObjectFactory factory, List`1& fieldInfo) +8274
   Microsoft.SharePoint.Publishing.CachedPage..ctor(PublishingPage page, SPListItem altItem, String id, String parentId, String title, String url, String description, CachedObjectFactory factory, List`1& fieldInfo) +326
   Microsoft.SharePoint.Publishing.CachedPage.CreateCachedPage(PublishingPage page, SPListItem altItem, CachedObjectFactory factory, List`1& fieldInfo) +672
   Microsoft.SharePoint.Publishing.CachedPage.CreateCachedPage(PublishingPage page, CachedObjectFactory factory, List`1& fieldInfo) +63
   Microsoft.SharePoint.Publishing.CachedListItem.CreateCachedListItem(SPListItem item, SPListItem alternateItem, Boolean parentIsWeb, CachedObjectFactory factory, List`1& fieldInfo) +853
   Microsoft.SharePoint.Publishing.CachedObjectFactory.CreateListItemFromUrl(String url, SPWeb contextWeb, Boolean enableCheckedOutItem) +2279
   Microsoft.SharePoint.Publishing.CachedObjectFactory.CreateListItemFromUrl(String url, SPWeb contextWeb) +64
   Microsoft.SharePoint.Publishing.CachedObjectFactory.CreateObject(SPListItem listItem, List`1& fieldInfo) +1068
   Microsoft.SharePoint.Publishing.CachedObjectFactory.CreateObject(PublishingPage page) +120
   Microsoft.SharePoint.Publishing.CachedObjectFactory.GetPageForCurrentItem() +242
   Microsoft.SharePoint.Publishing.TemplateRedirectionPage.ComputeRedirectionVirtualPath(TemplateRedirectionPage basePage) +1969
   Microsoft.SharePoint.Publishing.Internal.CmsVirtualPathProvider.CombineVirtualPaths(String basePath, String relativePath) +132
   System.Web.Hosting.VirtualPathProvider.CombineVirtualPaths(VirtualPath basePath, VirtualPath relativePath) +60
   System.Web.UI.DependencyParser.AddDependency(VirtualPath virtualPath) +20
   System.Web.UI.DependencyParser.ProcessDirective(String directiveName, IDictionary directive) +10934561
   System.Web.UI.PageDependencyParser.ProcessDirective(String directiveName, IDictionary directive) +30
   System.Web.UI.DependencyParser.ParseString(String text) +86
   System.Web.UI.DependencyParser.ParseFile(String physicalPath, VirtualPath virtualPath) +318
   System.Web.UI.DependencyParser.GetVirtualPathDependencies() +10936743
   Microsoft.SharePoint.ApplicationRuntime.SPVirtualFile.CalculateFileDependencies(HttpContext context, SPRequestModuleData basicRequestData, ICollection& directDependencies, ICollection& childDependencies) +1072
   Microsoft.SharePoint.ApplicationRuntime.SPDatabaseFile.EnsureDependencies(HttpContext context, SPRequestModuleData requestData) +1541
   Microsoft.SharePoint.ApplicationRuntime.SPDatabaseFile.EnsureCacheKeyAndViewStateHash(HttpContext context, SPRequestModuleData requestData) +1939
   Microsoft.SharePoint.ApplicationRuntime.SPDatabaseFile.GetVirtualPathProviderCacheKey(HttpContext context, SPRequestModuleData requestData) +61
   Microsoft.SharePoint.ApplicationRuntime.SPVirtualFile.GetVirtualPathProviderCacheKey(String virtualPath) +379
   Microsoft.SharePoint.ApplicationRuntime.SPVirtualPathProvider.GetCacheKey(String virtualPath) +102
   Microsoft.SharePoint.Publishing.Internal.CmsVirtualPathProvider.GetCacheKey(String virtualPath) +90
   System.Web.Compilation.BuildManager.GetCacheKeyFromVirtualPath(VirtualPath virtualPath, Boolean& keyFromVPP) +38
   System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +82
   System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +116
   System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +175
   System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +52
   System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +50
   System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +503
   System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +142
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +263

Version Information: Microsoft .NET Framework Version:2.0.50727.4200; ASP.NET Version:2.0.50727.4205