Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

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
share|improve this question
    
Please include the version of Sharepoint also if you are using the latest update as there were some bugs regarding this message. Also you tagged this post as MySQL? –  Dennis G Oct 28 '10 at 8:00
    
Version of Sharepoint is on the bottom of the Error page pasted above: Version:2.0.50727.4200. –  bozdoz Oct 28 '10 at 11:35
    
Version 2.0.50727.4200 is the .Net framework version, not the SharePoint version. Based on this .Net version, I'm assuming it is either WSS 3.0 or MOSS 2007? –  SQL3D Oct 28 '10 at 18:55
    
I have found a page that says Sharepoint Server 2007. Is there anywhere else I could check this? –  bozdoz Oct 29 '10 at 2:38
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.