locked
Error in application log - Event ID 5586 RRS feed

  • 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,
    Veronica

    Tuesday, 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
  • Yep, those could certainly make calls to the web service with CAML queries.  I'd check the date in the log file with any files that have been updated in the target site and see if you can pinpoint what action might have triggered it.

    Chris


    Chris Givens CEO, Architecting Connected Systems Blog Twitter
    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!
    Veronica

     

    Thursday, 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