Answered by:
Error in application log - Event ID 5586

Question
-
Hi everyone,
I keep getting this error, intermittently, on one of my servers (MOSS 2007 SP2 WFE with SQL 2005 SP3 separate backend) and my research is not coming up with anything conclusive. Has someone seen this before and can share some information (solution, what to try, etc)?
From the application log:
Event ID: 5586
Source: Windows SharePoint Services
Category: Database
Description: Unknown SQL Exception 191 occured. Additional error information from SQL Server is included below.Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.
From the diagnostic log:
04/13/2010 10:45:26.73 w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880i High System.Data.SqlClient.SqlException: Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.Sql...
04/13/2010 10:45:26.73* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880i High ...Client.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior)
04/13/2010 10:45:26.73 w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880j High SqlError: 'Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.' Source: '.Net SqlClient Data Provider' Number: 191 State: 1 Class: 15 Procedure: '' LineNumber: 1 Server: 'karelian\karelian_sp'
04/13/2010 10:45:26.73 w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 5586 Critical Unknown SQL Exception 191 occured. Additional error information from SQL Server is included below. Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.
04/13/2010 10:45:26.73 w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880k High at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean& bSucceed) at Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback(String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pSchemaCallback) at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback(String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pSchemaCallback) at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData() at Microsoft.SharePoint.SPListItemCollection.GetXmlInternal(Boolean allow...
04/13/2010 10:45:26.73* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880k High ...RichText) at Microsoft.SharePoint.SoapServer.ListDataImpl.ExecuteQuery(String strRootFolder, String strListName, String strViewName, String strQuery, String strViewFields, String strRowLimit, String strSince, String strQueryOptions, String strContains, SPWeb web, SPQueryOpt queryOpts) at Microsoft.SharePoint.SoapServer.ListDataImpl.GetItemsFromQuery(String strListName, String strInnerQuery, String strViewFields, String strRowLimit) at Microsoft.SharePoint.SoapServer.ListDataImpl.GetOriginalData(String strListName, XmlTextReader reader) at Microsoft.SharePoint.SoapServer.ListDataImpl.ResyncBeforeUpdates(String strXmlData, String strListName) at Microsoft.SharePoint.SoapServer.ListDataImpl.ConstructCaml(String strListName, String strXmlData) at Microsoft.SharePoint.So...
04/13/2010 10:45:26.73* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880k High ...apServer.ListDataImpl.UpdateListItems(String strListName, String strXmlData) at Microsoft.SharePoint.SoapServer.ListDataValidatorImpl.UpdateListItems(String strListName, String strXmlData) at Microsoft.SharePoint.SoapServer.Lists.UpdateListItems(String listName, SoapXmlElement updates) at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System....
04/13/2010 10:45:26.73* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880k High ...Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values) at System.Web.Services.Protocols.WebServiceHandler.Invoke() at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest() at System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) at System.Web.HttpRuntime.ProcessRequestInt...
04/13/2010 10:45:26.73* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880k High ...ernal(HttpWorkerRequest wr) at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
04/13/2010 10:45:26.73 w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880l High ConnectionString: 'Data Source=karelian\karelian_sp;Initial Catalog=WSS_WSTS_Content;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15
04/13/2010 10:45:26.74 w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High SqlCommand: ' SELECT TOP 1729 t1.[Type] AS c0,AllUserData.[nvarchar2],AllUserData.[bit3],t2.[tp_ID] AS c5c7,AllUserData.[datetime1],AllUserData.[ntext4],AllUserData.[tp_ID],AllUserData.[tp_HasCopyDestinations],t1.[TimeLastModified] AS c15,AllUserData.[int3],AllUserData.[tp_ModerationStatus],t3.[nvarchar1] AS c11c6,t1.[Id] AS c3,AllUserData.[nvarchar1],AllUserData.[bit2],t3.[tp_Created] AS c11c10,AllUserData.[ntext3],AllUserData.[tp_ContentType],AllUserData.[tp_ItemOrder],AllUserData.[nvarchar3],AllUserData.[bit4],AllUserData.[int2],t2.[tp_Created] AS c5c10,t3.[nvarchar5] AS c11c9,t1.[TimeCreated] AS c13,AllUserData.[tp_WorkflowInstanceID],AllUserData.[bit1],AllUserData.[datetime2],CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELS...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...E t1.DirName + N'/' + t1.LeafName END AS c1,AllUserData.[tp_ContentTypeId],t2.[nvarchar4] AS c5c8,t3.[nvarchar4] AS c11c8,t1.[LeafName] AS c12,AllUserData.[tp_Created],AllUserData.[tp_CopySource],AllUserData.[tp_Version],AllUserData.[ntext2],AllUserData.[int4],AllUserData.[nvarchar5],AllUserData.[tp_Author],AllUserData.[tp_Editor],AllUserData.[tp_UIVersion],AllUserData.[tp_UIVersionString],AllUserData.[int1],t3.[tp_ID] AS c11c7,t1.[ProgId] AS c16,t1.[ScopeId] AS c4,AllUserData.[tp_Modified],AllUserData.[tp_WorkflowVersion],AllUserData.[tp_IsCurrentVersion],AllUserData.[ntext1],AllUserData.[uniqueidentifier1],AllUserData.[nvarchar4],t2.[nvarchar1] AS c5c6,AllUserData.[tp_HasAttachment],AllUserData.[datetime3],t1.[DirName] AS c14,AllUserData.[tp_GUID],t1.[MetaInfo] AS c2,AllUserData.[tp_Lev...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...el],t2.[nvarchar5] AS c5c9 FROM AllUserData WITH (INDEX=AllUserData_PK) INNER JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1 AND AllUserData.[tp_RowOrdinal] = 0 AND t1.SiteId = AllUserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = AllUserData.tp_DirName AND t1.LeafName = AllUserData.tp_LeafName AND t1.Level = AllUserData.tp_Level AND t1.IsCurrentVersion = 1 AND (1 = 1) AND AllUserData.tp_ListId = @L3 AND AllUserData.[tp_CalculatedVersion] = 0 AND AllUserData.[tp_DeleteTransactionId] = 0x ) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK, INDEX=AllUserData_PK) ON (AllUserData.[tp_Author]=t2.[tp_ID] AND AllUserData.[tp_RowOrdinal] = 0 AND t2.[tp_RowOrdinal] = 0 AND ( (t2.tp_IsCurrent = 1) ) AND t2.[tp_CalculatedVersion] = 0 AND t2.[tp_DeleteTransactionId] = 0x AND t2.tp_ListId = @L4 AND ...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...AllUserData.tp_ListId = @L3 AND AllUserData.[tp_CalculatedVersion] = 0 AND AllUserData.[tp_DeleteTransactionId] = 0x ) LEFT OUTER JOIN AllUserData AS t3 WITH(NOLOCK, INDEX=AllUserData_PK) ON (AllUserData.[tp_Editor]=t3.[tp_ID] AND AllUserData.[tp_RowOrdinal] = 0 AND t3.[tp_RowOrdinal] = 0 AND ( (t3.tp_IsCurrent = 1) ) AND t3.[tp_CalculatedVersion] = 0 AND t3.[tp_DeleteTransactionId] = 0x AND t3.tp_ListId = @L4 AND AllUserData.tp_ListId = @L3 AND AllUserData.[tp_CalculatedVersion] = 0 AND AllUserData.[tp_DeleteTransactionId] = 0x ) WHERE AllUserData.tp_ListID=@L3 AND ( (AllUserData.tp_IsCurrent = 1) ) AND AllUserData.tp_RowOrdinal=0 AND (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((AllUserData.[tp_ID] = ...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...N'6') OR (AllUserData.[tp_ID] = N'7')) OR (AllUserData.[tp_ID] = N'28')) OR (AllUserData.[tp_ID] = N'8')) OR (AllUserData.[tp_ID] = N'40')) OR (AllUserData.[tp_ID] = N'2')) OR (AllUserData.[tp_ID] = N'1')) OR (AllUserData.[tp_ID] = N'3')) OR (AllUserData.[tp_ID] = N'4')) OR (AllUserData.[tp_ID] = N'43')) OR (AllUserData.[tp_ID] = N'45')) OR (AllUserData.[tp_ID] = N'10')) OR (AllUserData.[tp_ID] = N'11')) OR (AllUserData.[tp_ID] = N'12')) OR (AllUserData.[tp_ID] = N'50')) OR (AllUserData.[tp_ID] = N'14')) OR (AllUserData.[tp_ID] = N'15')) OR (AllUserData.[tp_ID] = N'64')) OR (AllUserData.[tp_ID] = N'63')) OR (AllUserData.[tp_ID] = N'20')) OR (AllUserData.[tp_ID] = N'67')) OR (AllUserData.[tp_ID] = N'16')) OR (AllUserData.[tp_ID] = N'44')) OR (AllUserData.[tp_ID] = N'73')) OR (AllUserData.[t...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...p_ID] = N'17')) OR (AllUserData.[tp_ID] = N'61')) OR (AllUserData.[tp_ID] = N'70')) OR (AllUserData.[tp_ID] = N'71')) OR (AllUserData.[tp_ID] = N'72')) OR (AllUserData.[tp_ID] = N'66')) OR (AllUserData.[tp_ID] = N'18')) OR (AllUserData.[tp_ID] = N'75')) OR (AllUserData.[tp_ID] = N'94')) OR (AllUserData.[tp_ID] = N'76')) OR (AllUserData.[tp_ID] = N'81')) OR (AllUserData.[tp_ID] = N'83')) OR (AllUserData.[tp_ID] = N'88')) OR (AllUserData.[tp_ID] = N'95')) OR (AllUserData.[tp_ID] = N'85')) OR (AllUserData.[tp_ID] = N'98')) OR (AllUserData.[tp_ID] = N'54')) OR (AllUserData.[tp_ID] = N'87')) OR (AllUserData.[tp_ID] = N'102')) OR (AllUserData.[tp_ID] = N'96')) OR (AllUserData.[tp_ID] = N'100')) OR (AllUserData.[tp_ID] = N'103')) OR (AllUserData.[tp_ID] = N'104')) OR (AllUserData.[tp_ID] = N'55')...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...) OR (AllUserData.[tp_ID] = N'105')) OR (AllUserData.[tp_ID] = N'106')) OR (AllUserData.[tp_ID] = N'107')) OR (AllUserData.[tp_ID] = N'108')) OR (AllUserData.[tp_ID] = N'78')) OR (AllUserData.[tp_ID] = N'109')) OR (AllUserData.[tp_ID] = N'74')) OR (AllUserData.[tp_ID] = N'113')) OR (AllUserData.[tp_ID] = N'86')) OR (AllUserData.[tp_ID] = N'99')) OR (AllUserData.[tp_ID] = N'114')) OR (AllUserData.[tp_ID] = N'65')) OR (AllUserData.[tp_ID] = N'118')) OR (AllUserData.[tp_ID] = N'77')) OR (AllUserData.[tp_ID] = N'58')) OR (AllUserData.[tp_ID] = N'82')) OR (AllUserData.[tp_ID] = N'117')) OR (AllUserData.[tp_ID] = N'112')) OR (AllUserData.[tp_ID] = N'116')) OR (AllUserData.[tp_ID] = N'110')) OR (AllUserData.[tp_ID] = N'59')) OR (AllUserData.[tp_ID] = N'111')) OR (AllUserData.[tp_ID] = N'119')) OR...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ... (AllUserData.[tp_ID] = N'120')) OR (AllUserData.[tp_ID] = N'29')) OR (AllUserData.[tp_ID] = N'125')) OR (AllUserData.[tp_ID] = N'53')) OR (AllUserData.[tp_ID] = N'122')) OR (AllUserData.[tp_ID] = N'123')) OR (AllUserData.[tp_ID] = N'133')) OR (AllUserData.[tp_ID] = N'124')) OR (AllUserData.[tp_ID] = N'30')) OR (AllUserData.[tp_ID] = N'134')) OR (AllUserData.[tp_ID] = N'135')) OR (AllUserData.[tp_ID] = N'139')) OR (AllUserData.[tp_ID] = N'141')) OR (AllUserData.[tp_ID] = N'142')) OR (AllUserData.[tp_ID] = N'31')) OR (AllUserData.[tp_ID] = N'32')) OR (AllUserData.[tp_ID] = N'143')) OR (AllUserData.[tp_ID] = N'60')) OR (AllUserData.[tp_ID] = N'144')) OR (AllUserData.[tp_ID] = N'145')) OR (AllUserData.[tp_ID] = N'33')) OR (AllUserData.[tp_ID] = N'146')) OR (AllUserData.[tp_ID] = N'97')) OR (A...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...llUserData.[tp_ID] = N'34')) OR (AllUserData.[tp_ID] = N'148')) OR (AllUserData.[tp_ID] = N'149')) OR (AllUserData.[tp_ID] = N'89')) OR (AllUserData.[tp_ID] = N'136')) OR (AllUserData.[tp_ID] = N'90')) OR (AllUserData.[tp_ID] = N'91')) OR (AllUserData.[tp_ID] = N'35')) OR (AllUserData.[tp_ID] = N'154')) OR (AllUserData.[tp_ID] = N'36')) OR (AllUserData.[tp_ID] = N'158')) OR (AllUserData.[tp_ID] = N'37')) OR (AllUserData.[tp_ID] = N'147')) OR (AllUserData.[tp_ID] = N'46')) OR (AllUserData.[tp_ID] = N'162')) OR (AllUserData.[tp_ID] = N'164')) OR (AllUserData.[tp_ID] = N'38')) OR (AllUserData.[tp_ID] = N'161')) OR (AllUserData.[tp_ID] = N'153')) OR (AllUserData.[tp_ID] = N'39')) OR (AllUserData.[tp_ID] = N'183')) OR (AllUserData.[tp_ID] = N'185')) OR (AllUserData.[tp_ID] = N'184')) OR (AllUse...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...rData.[tp_ID] = N'150')) OR (AllUserData.[tp_ID] = N'186')) OR (AllUserData.[tp_ID] = N'169')) OR (AllUserData.[tp_ID] = N'188')) OR (AllUserData.[tp_ID] = N'171')) OR (AllUserData.[tp_ID] = N'172')) OR (AllUserData.[tp_ID] = N'173')) OR (AllUserData.[tp_ID] = N'156')) OR (AllUserData.[tp_ID] = N'191')) OR (AllUserData.[tp_ID] = N'190')) OR (AllUserData.[tp_ID] = N'127')) OR (AllUserData.[tp_ID] = N'128')) OR (AllUserData.[tp_ID] = N'166')) OR (AllUserData.[tp_ID] = N'157')) OR (AllUserData.[tp_ID] = N'170')) OR (AllUserData.[tp_ID] = N'192')) OR (AllUserData.[tp_ID] = N'167')) OR (AllUserData.[tp_ID] = N'200')) OR (AllUserData.[tp_ID] = N'174')) OR (AllUserData.[tp_ID] = N'92')) OR (AllUserData.[tp_ID] = N'93')) OR (AllUserData.[tp_ID] = N'201')) OR (AllUserData.[tp_ID] = N'199')) OR (All...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...UserData.[tp_ID] = N'202')) OR (AllUserData.[tp_ID] = N'203')) OR (AllUserData.[tp_ID] = N'204')) OR (AllUserData.[tp_ID] = N'129')) OR (AllUserData.[tp_ID] = N'205')) OR (AllUserData.[tp_ID] = N'175')) OR (AllUserData.[tp_ID] = N'160')) OR (AllUserData.[tp_ID] = N'151')) OR (AllUserData.[tp_ID] = N'187')) OR (AllUserData.[tp_ID] = N'211')) OR (AllUserData.[tp_ID] = N'206')) OR (AllUserData.[tp_ID] = N'177')) OR (AllUserData.[tp_ID] = N'209')) OR (AllUserData.[tp_ID] = N'115')) OR (AllUserData.[tp_ID] = N'212')) OR (AllUserData.[tp_ID] = N'178')) OR (AllUserData.[tp_ID] = N'176')) OR (AllUserData.[tp_ID] = N'216')) OR (AllUserData.[tp_ID] = N'207')) OR (AllUserData.[tp_ID] = N'226')) OR (AllUserData.[tp_ID] = N'223')) OR (AllUserData.[tp_ID] = N'224')) OR (AllUserData.[tp_ID] = N'208')) OR...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ... (AllUserData.[tp_ID] = N'168')) OR (AllUserData.[tp_ID] = N'235')) OR (AllUserData.[tp_ID] = N'227')) OR (AllUserData.[tp_ID] = N'121')) OR (AllUserData.[tp_ID] = N'179')) OR (AllUserData.[tp_ID] = N'236')) OR (AllUserData.[tp_ID] = N'238')) OR (AllUserData.[tp_ID] = N'222')) OR (AllUserData.[tp_ID] = N'180')) OR (AllUserData.[tp_ID] = N'193')) OR (AllUserData.[tp_ID] = N'194')) OR (AllUserData.[tp_ID] = N'246')) OR (AllUserData.[tp_ID] = N'247')) OR (AllUserData.[tp_ID] = N'259')) OR (AllUserData.[tp_ID] = N'260')) OR (AllUserData.[tp_ID] = N'215')) OR (AllUserData.[tp_ID] = N'261')) OR (AllUserData.[tp_ID] = N'262')) OR (AllUserData.[tp_ID] = N'267')) OR (AllUserData.[tp_ID] = N'268')) OR (AllUserData.[tp_ID] = N'131')) OR (AllUserData.[tp_ID] = N'264')) OR (AllUserData.[tp_ID] = N'249'...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...)) OR (AllUserData.[tp_ID] = N'266')) OR (AllUserData.[tp_ID] = N'195')) OR (AllUserData.[tp_ID] = N'198')) OR (AllUserData.[tp_ID] = N'182')) OR (AllUserData.[tp_ID] = N'197')) OR (AllUserData.[tp_ID] = N'196')) OR (AllUserData.[tp_ID] = N'237')) OR (AllUserData.[tp_ID] = N'272')) OR (AllUserData.[tp_ID] = N'273')) OR (AllUserData.[tp_ID] = N'271')) OR (AllUserData.[tp_ID] = N'274')) OR (AllUserData.[tp_ID] = N'278')) OR (AllUserData.[tp_ID] = N'284')) OR (AllUserData.[tp_ID] = N'229')) OR (AllUserData.[tp_ID] = N'287')) OR (AllUserData.[tp_ID] = N'281')) OR (AllUserData.[tp_ID] = N'263')) OR (AllUserData.[tp_ID] = N'286')) OR (AllUserData.[tp_ID] = N'288')) OR (AllUserData.[tp_ID] = N'289')) OR (AllUserData.[tp_ID] = N'290')) OR (AllUserData.[tp_ID] = N'285')) OR (AllUserData.[tp_ID] = N...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...'291')) OR (AllUserData.[tp_ID] = N'293')) OR (AllUserData.[tp_ID] = N'282')) OR (AllUserData.[tp_ID] = N'225')) OR (AllUserData.[tp_ID] = N'283')) OR (AllUserData.[tp_ID] = N'292')) OR (AllUserData.[tp_ID] = N'294')) OR (AllUserData.[tp_ID] = N'295')) OR (AllUserData.[tp_ID] = N'298')) OR (AllUserData.[tp_ID] = N'297')) OR (AllUserData.[tp_ID] = N'301')) OR (AllUserData.[tp_ID] = N'299')) OR (AllUserData.[tp_ID] = N'217')) OR (AllUserData.[tp_ID] = N'300')) OR (AllUserData.[tp_ID] = N'304')) OR (AllUserData.[tp_ID] = N'303')) OR (AllUserData.[tp_ID] = N'251')) OR (AllUserData.[tp_ID] = N'302')) OR (AllUserData.[tp_ID] = N'218')) OR (AllUserData.[tp_ID] = N'307')) OR (AllUserData.[tp_ID] = N'233')) OR (AllUserData.[tp_ID] = N'234')) OR (AllUserData.[tp_ID] = N'277')) OR (AllUserData.[tp_ID...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...] = N'309')) OR (AllUserData.[tp_ID] = N'219')) OR (AllUserData.[tp_ID] = N'165')) OR (AllUserData.[tp_ID] = N'308')) OR (AllUserData.[tp_ID] = N'311')) OR (AllUserData.[tp_ID] = N'310')) OR (AllUserData.[tp_ID] = N'312')) OR (AllUserData.[tp_ID] = N'220')) OR (AllUserData.[tp_ID] = N'323')) OR (AllUserData.[tp_ID] = N'320')) OR (AllUserData.[tp_ID] = N'324')) OR (AllUserData.[tp_ID] = N'306')) OR (AllUserData.[tp_ID] = N'276')) OR (AllUserData.[tp_ID] = N'322')) OR (AllUserData.[tp_ID] = N'254')) OR (AllUserData.[tp_ID] = N'327')) OR (AllUserData.[tp_ID] = N'152')) OR (AllUserData.[tp_ID] = N'313')) OR (AllUserData.[tp_ID] = N'316')) OR (AllUserData.[tp_ID] = N'328')) OR (AllUserData.[tp_ID] = N'239')) OR (AllUserData.[tp_ID] = N'317')) OR (AllUserData.[tp_ID] = N'240')) OR (AllUserData.[...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...tp_ID] = N'332')) OR (AllUserData.[tp_ID] = N'253')) OR (AllUserData.[tp_ID] = N'333')) OR (AllUserData.[tp_ID] = N'241')) OR (AllUserData.[tp_ID] = N'334')) OR (AllUserData.[tp_ID] = N'335')) OR (AllUserData.[tp_ID] = N'329')) OR (AllUserData.[tp_ID] = N'342')) OR (AllUserData.[tp_ID] = N'341')) OR (AllUserData.[tp_ID] = N'340')) OR (AllUserData.[tp_ID] = N'338')) OR (AllUserData.[tp_ID] = N'339')) OR (AllUserData.[tp_ID] = N'255')) OR (AllUserData.[tp_ID] = N'343')) OR (AllUserData.[tp_ID] = N'232')) OR (AllUserData.[tp_ID] = N'344')) OR (AllUserData.[tp_ID] = N'305')) OR (AllUserData.[tp_ID] = N'256')) OR (AllUserData.[tp_ID] = N'345')) OR (AllUserData.[tp_ID] = N'245')) OR (AllUserData.[tp_ID] = N'257')) OR (AllUserData.[tp_ID] = N'279')) OR (AllUserData.[tp_ID] = N'330')) OR (AllUserD...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...ata.[tp_ID] = N'347')) OR (AllUserData.[tp_ID] = N'331')) OR (AllUserData.[tp_ID] = N'351')) OR (AllUserData.[tp_ID] = N'242')) OR (AllUserData.[tp_ID] = N'367')) OR (AllUserData.[tp_ID] = N'368')) OR (AllUserData.[tp_ID] = N'369')) OR (AllUserData.[tp_ID] = N'363')) OR (AllUserData.[tp_ID] = N'371')) OR (AllUserData.[tp_ID] = N'374')) OR (AllUserData.[tp_ID] = N'337')) OR (AllUserData.[tp_ID] = N'373')) OR (AllUserData.[tp_ID] = N'375')) OR (AllUserData.[tp_ID] = N'376')) OR (AllUserData.[tp_ID] = N'390')) OR (AllUserData.[tp_ID] = N'391')) OR (AllUserData.[tp_ID] = N'385')) OR (AllUserData.[tp_ID] = N'314')) OR (AllUserData.[tp_ID] = N'381')) OR (AllUserData.[tp_ID] = N'366')) OR (AllUserData.[tp_ID] = N'377')) OR (AllUserData.[tp_ID] = N'382')) OR (AllUserData.[tp_ID] = N'380')) OR (All...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...UserData.[tp_ID] = N'404')) OR (AllUserData.[tp_ID] = N'399')) OR (AllUserData.[tp_ID] = N'398')) OR (AllUserData.[tp_ID] = N'410')) OR (AllUserData.[tp_ID] = N'411')) OR (AllUserData.[tp_ID] = N'353')) OR (AllUserData.[tp_ID] = N'378')) OR (AllUserData.[tp_ID] = N'270')) OR (AllUserData.[tp_ID] = N'414')) OR (AllUserData.[tp_ID] = N'417')) OR (AllUserData.[tp_ID] = N'402')) OR (AllUserData.[tp_ID] = N'419')) OR (AllUserData.[tp_ID] = N'413')) OR (AllUserData.[tp_ID] = N'350')) OR (AllUserData.[tp_ID] = N'403')) OR (AllUserData.[tp_ID] = N'416')) OR (AllUserData.[tp_ID] = N'269')) OR (AllUserData.[tp_ID] = N'418')) OR (AllUserData.[tp_ID] = N'422')) OR (AllUserData.[tp_ID] = N'436')) OR (AllUserData.[tp_ID] = N'425')) OR (AllUserData.[tp_ID] = N'405')) OR (AllUserData.[tp_ID] = N'406')) OR...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ... (AllUserData.[tp_ID] = N'435')) OR (AllUserData.[tp_ID] = N'432')) OR (AllUserData.[tp_ID] = N'438')) OR (AllUserData.[tp_ID] = N'437')) OR (AllUserData.[tp_ID] = N'427')) OR (AllUserData.[tp_ID] = N'440')) OR (AllUserData.[tp_ID] = N'280')) OR (AllUserData.[tp_ID] = N'356')) OR (AllUserData.[tp_ID] = N'401')) OR (AllUserData.[tp_ID] = N'442')) OR (AllUserData.[tp_ID] = N'426')) OR (AllUserData.[tp_ID] = N'444')) OR (AllUserData.[tp_ID] = N'439')) OR (AllUserData.[tp_ID] = N'441')) OR (AllUserData.[tp_ID] = N'429')) OR (AllUserData.[tp_ID] = N'357')) OR (AllUserData.[tp_ID] = N'447')) OR (AllUserData.[tp_ID] = N'434')) OR (AllUserData.[tp_ID] = N'448')) OR (AllUserData.[tp_ID] = N'424')) OR (AllUserData.[tp_ID] = N'445')) OR (AllUserData.[tp_ID] = N'431')) OR (AllUserData.[tp_ID] = N'365'...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...)) OR (AllUserData.[tp_ID] = N'452')) OR (AllUserData.[tp_ID] = N'457')) OR (AllUserData.[tp_ID] = N'455')) OR (AllUserData.[tp_ID] = N'454')) OR (AllUserData.[tp_ID] = N'450')) OR (AllUserData.[tp_ID] = N'459')) OR (AllUserData.[tp_ID] = N'354')) OR (AllUserData.[tp_ID] = N'409')) OR (AllUserData.[tp_ID] = N'392')) OR (AllUserData.[tp_ID] = N'467')) OR (AllUserData.[tp_ID] = N'470')) OR (AllUserData.[tp_ID] = N'465')) OR (AllUserData.[tp_ID] = N'469')) OR (AllUserData.[tp_ID] = N'460')) OR (AllUserData.[tp_ID] = N'326')) OR (AllUserData.[tp_ID] = N'348')) OR (AllUserData.[tp_ID] = N'471')) OR (AllUserData.[tp_ID] = N'358')) OR (AllUserData.[tp_ID] = N'453')) OR (AllUserData.[tp_ID] = N'472')) OR (AllUserData.[tp_ID] = N'433')) OR (AllUserData.[tp_ID] = N'477')) OR (AllUserData.[tp_ID] = N...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...'478')) OR (AllUserData.[tp_ID] = N'479')) OR (AllUserData.[tp_ID] = N'443')) OR (AllUserData.[tp_ID] = N'480')) OR (AllUserData.[tp_ID] = N'482')) OR (AllUserData.[tp_ID] = N'483')) OR (AllUserData.[tp_ID] = N'481')) OR (AllUserData.[tp_ID] = N'488')) OR (AllUserData.[tp_ID] = N'489')) OR (AllUserData.[tp_ID] = N'490')) OR (AllUserData.[tp_ID] = N'491')) OR (AllUserData.[tp_ID] = N'493')) OR (AllUserData.[tp_ID] = N'494')) OR (AllUserData.[tp_ID] = N'495')) OR (AllUserData.[tp_ID] = N'492')) OR (AllUserData.[tp_ID] = N'498')) OR (AllUserData.[tp_ID] = N'496')) OR (AllUserData.[tp_ID] = N'463')) OR (AllUserData.[tp_ID] = N'501')) OR (AllUserData.[tp_ID] = N'346')) OR (AllUserData.[tp_ID] = N'504')) OR (AllUserData.[tp_ID] = N'497')) OR (AllUserData.[tp_ID] = N'359')) OR (AllUserData.[tp_ID...
04/13/2010 10:45:26.74* w3wp.exe (0x2290) 0x22C8 Windows SharePoint Services Database 880m High ...] = N'502')) OR (AllUserData.[tp_ID] = N'506')) OR (AllUserData.[tp_ID] = N'503')) OR (AllUserData.[tp_ID] = N'507')) OR (AllUserData.[tp_ID] = N'499')) OR (AllUserData.[tp_ID] = N'510')) OR (AllUserData.[tp_ID] = N'486')) OR (AllUserData.[tp_ID] = N'560')) OR (AllUserData.[tp_ID] = N'508')) OR (AllUserData.[tp_ID] = N'513')) OR (AllUserData.[tp_ID] = N'361')) OR (AllUserData.[tp_ID] = N'514')) OR (AllUserData.[tp_ID] = N'372')) OR (AllUserData.[tp_ID] = N'515')) OR (AllUserData.[tp_ID] = N'521')) OR (AllUserData.[tp_ID] = N'522')) OR (AllUserData.[tp_ID] = N'509')) OR (AllUserData.[tp_ID] = N'519')) OR (AllUserData.[tp_ID] = N'523')) OR (AllUserData.[tp_ID] = N'520')) OR (AllUserData.[tp_ID] = N'528')) OR (AllUserData.[tp_ID] = N'530')) OR (AllUserData.[tp_ID] = N'529')) OR (AllUserData.[...Please let me know if you need more or less information. :)
TIA,
VeronicaTuesday, April 13, 2010 7:39 PM
Answers
-
Looks like someone is calling the lists webserivce and passing in a CAML query that is really big and trying to update a list. You will need to check to see what applications have been written that are making these calls to your Farm.
Chris
Chris Givens CEO, Architecting Connected Systems Blog Twitter- Marked as answer by GuYuming Wednesday, April 21, 2010 5:59 AM
Tuesday, April 13, 2010 8:20 PM
All replies
-
Looks like someone is calling the lists webserivce and passing in a CAML query that is really big and trying to update a list. You will need to check to see what applications have been written that are making these calls to your Farm.
Chris
Chris Givens CEO, Architecting Connected Systems Blog Twitter- Marked as answer by GuYuming Wednesday, April 21, 2010 5:59 AM
Tuesday, April 13, 2010 8:20 PM -
Hi Chris, thanks for the reply!
Might an InfoPath form or an Excel spreadsheet be reasonable suspects? Those are the only two "applications" that I know of for sure connect to our farm. No other custom application (or standard for that matter) have been connected to any lists.
Tuesday, April 13, 2010 9:13 PM -
Tuesday, April 13, 2010 11:41 PM
-
Do you know how to reproduce this error in user interface?
Most probably you don't, we can see in the error message that some operation generated a huge T-SQL query:
SELECT TOP 1729 why 1729 number of list item? Anyway, this information may be useless because the 1729 number maybe computed by previous statements, do you have many lists that contain more than 1729 number of items?
FROM AllUserData WITH (INDEX=AllUserData_PK) INNER JOIN Docs It tries to get list items , however, from which list?
AllUserData.tp_ListId = @L3
LEFT OUTER JOIN AllUserData AS t2
t2.tp_ListId = @L4
LEFT OUTER JOIN AllUserData AS t3
t3.tp_ListId = @L4
seems that the query tries to get list item from two lists @L3,@L4(maybe @L3 left outer join @L4, I guess, I had not analysis the T-SQL clearly). Unfortunately, the value for variable @L3 and @4 is not logged;
However, there are so many tp_id value as filter later in the log :
AllUserData.tp_ListID=@L3 AND ( (AllUserData.tp_IsCurrent = 1) )
OR (AllUserData.[tp_ID] = N'503')) OR (AllUserData.[tp_ID] = N'507')) OR (AllUserData.[tp_ID] = N'499')) OR (AllUserData.[tp_ID] = N'510')) OR (AllUserData.[tp_ID] = N'486')) OR (AllUserData.[tp_ID] = N'560')) OR (AllUserData.[tp_ID] = N'508')) OR (AllUserData.[tp_ID] = N'513')) OR (AllUserData.[tp_ID] = N'361')) OR (AllUserData.[tp_ID] = N'514')) OR (AllUserData.[tp_ID] = N'372')) OR (AllUserData.[tp_ID] = N'515')) OR (AllUserData.[tp_ID] = N'521'))
Item from different list can have the same tp_id, if we run the following T-SQL in SharePoint content database,
Select tp_ListID from AllUserData where tp_ID=N’521’ and tp_IsCurrent=1
We may get a lot of ListID returned, we still don’t know which one is @L3. If we try
Select L521.tp_ListID
From (Select tp_ListID from AllUserData where tp_ID=N’521’ and tp_IsCurrent=1) L521
inner join (Select tp_ListID from AllUserData where tp_ID=N’508’ and tp_IsCurrent=1) L508
on L521.tp_ListID=L508.tp_ListID
chances are some ListID will disappear in the result set since they may not contain both 508 and 521 (item 508 in that list may have been deleted)
If you future expend this kind query pattern, using large tp_id values from the log, you may finally determine with list the variable @L3 stands for.
Disclaimer:
This is really not “orthodoxical” approach to troubleshoot this kind of error, just write in hoping that you can find the operation that cause the error.
Gu Yuming
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact tngfb@microsoft.com
Wednesday, April 14, 2010 9:53 AM -
Hello Gu,
Thanks for the reply! :) I'm not quite understanding what you want me to try. Can you try "dumming it down" as I'm not a SQL gal?
Thanks!
VeronicaThursday, April 15, 2010 7:13 PM -
Forget the SQLs if you are not a SQL gal, I agree with Chris that “Looks like someone is calling the lists webserivce and passing in a CAML query that is really big”. Maybe the CAML is not so lengthy, but the engine translate it to lengthy SQL.
However, from the log information you post, we cannot find out which List is queried. I can only see so many AllUserData.[tp_ID] values. Since item from different lists can have the same tp_ID values, yet chance are not all the lists can have all the items 503,507,499,510… , I was trying to find the list that haveall these items. Find out the list involved may help you to find out the operation that generated this lengthy SQL in the log.
Now, I think that this is really not a clever idea, since we can also find out what operation caused this error by review the SharePoint audit log, or SharePoint usage log, or just IIS log. Find out what URL was visited at the time of the error log.
Friday, April 16, 2010 1:40 AM