locked
"Some part of your SQL statement is nested too deeply .." RRS feed

  • Question

  • I am currently experiencing some issues with a custom list on my companies SharePoint site. Certain list items (only 2 at present) appear to have corruted, or at least can no longer be opened. The error in the server application log is below.


    Event Type:    Error
    Event Source:    Windows SharePoint Services 3
    Event Category:    Database
    Event ID:    5586
    Date:        15/03/2011
    Time:        14:18:08
    User:        N/A
    Computer:    SV-SHAREPOINT
    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.


    I have had a look in the Diagnostic logs on the server and they list the below information. From what I can work out its because the SQL Select Statement is too big, but I have done no custom code, nothing is being used except OOTB features. Can anyone point me in the right direction to resolve this issue, or at very least how to stop it from happening again.

     

    SqlCommand: ' SELECT TOP 2147483648 t1.[Type] AS c0,UserData.[ntext2],UserData.[datetime1],t2.[tp_ID] AS c5c7,UserData.[nvarchar10],t5.[nvarchar4] AS c14c8,t6.[tp_Created] AS c15c10,t5.[tp_Created] AS c14c10,UserData.[tp_ItemOrder],UserData.[tp_Created],UserData.[tp_ModerationStatus],UserData.[nvarchar1],t3.[nvarchar1] AS c11c6,UserData.[nvarchar6],UserData.[bit2],UserData.[tp_WorkflowInstanceID],t1.[Id] AS c3,t3.[tp_Created] AS c11c10,UserData.[ntext1],UserData.[nvarchar14],t5.[nvarchar1] AS c14c6,UserData.[ntext6],UserData.[int2],t6.[tp_ID] AS c15c7,t1.[DirName] AS c18,UserData.[tp_ID],UserData.[nvarchar5],t3.[nvarchar5] AS c11c9,UserData.[bit1],t4.[Status1] AS c12c13,UserData.[tp_GUID],CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirN...
    
    ...ame ELSE t1.DirName + N'/' + t1.LeafName END AS c1,t2.[nvarchar4] AS c5c8,UserData.[tp_Author],t5.[nvarchar5] AS c14c9,UserData.[tp_Editor],UserData.[int1],UserData.[nvarchar13],UserData.[ntext5],t3.[tp_ID] AS c11c7,UserData.[tp_ContentTypeId],UserData.[tp_WorkflowVersion],t1.[LeafName] AS c16,UserData.[tp_Version],t1.[ScopeId] AS c4,UserData.[nvarchar4],UserData.[nvarchar9],t5.[tp_ID] AS c14c7,UserData.[tp_IsCurrentVersion],UserData.[tp_HasCopyDestinations],UserData.[tp_Level],t2.[nvarchar1] AS c5c6,UserData.[nvarchar12],UserData.[ntext4],UserData.[datetime3],UserData.[ntext9],t6.[nvarchar4] AS c15c8,UserData.[tp_HasAttachment],t1.[TimeLastModified] AS c19,t1.[MetaInfo] AS c2,UserData.[nvarchar3],t2.[nvarchar5] AS c5c9,UserData.[nvarchar8],UserData.[tp_Modified],UserData.[tp_UIVersion],U...
    
    ...serData.[tp_CopySource],UserData.[datetime2],t2.[tp_Created] AS c5c10,UserData.[nvarchar11],UserData.[ntext3],UserData.[uniqueidentifier1],UserData.[tp_InstanceID],UserData.[int4],t3.[nvarchar4] AS c11c8,UserData.[ntext8],UserData.[ntext10],t6.[nvarchar1] AS c15c6,UserData.[tp_UIVersionString],t1.[TimeCreated] AS c17,UserData.[nvarchar7],UserData.[nvarchar2],UserData.[bit3],UserData.[tp_ContentType],t1.[ProgId] AS c20,UserData.[nvarchar15],UserData.[ntext7],UserData.[int3],t6.[nvarchar5] AS c15c9 FROM UserData LEFT OUTER LOOP JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1 AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = UserData.tp_DirName AND t1.LeafName = UserData.tp_LeafName AND t1.Level = UserData.tp_Level AND t1.IsCurrentVersion =...
    
    ... 1 AND (1 = 1)) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[int1]=t2.[tp_ID] AND UserData.[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 = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t3 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[int4]=t3.[tp_ID] AND UserData.[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 = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN Workflow AS t4 WITH(NOLOCK) ON ( CAST ( CAST (UserData.[nvarchar15]AS VARBINARY) AS UNIQUEIDENTIFIER)=t4.[ID] AND UserData.[tp_RowOrdi...
    
    ...nal] = 0 AND t4.SiteId = @L2 AND t4.ListId = UserData.tp_ListId AND t4.ItemId = UserData.tp_Id AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t5 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_Author]=t5.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t5.[tp_RowOrdinal] = 0 AND ( (t5.tp_IsCurrent = 1) ) AND t5.[tp_CalculatedVersion] = 0 AND t5.[tp_DeleteTransactionId] = 0x AND t5.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t6 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_Editor]=t6.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t6.[tp_RowOrdinal] = 0 AND ( (t6.tp_IsCurrent = 1) ) AND t6.[tp_CalculatedVersion] = 0 AND t6.[tp_DeleteTransactionId] = 0x AND t6.tp_ListId = @L3 AND UserData.tp_ListId = @L4) WHERE UserData.tp_ListID=@L4 A...
    
    ...ND ( (UserData.tp_IsCurrent = 1) ) AND UserData.tp_SiteId=@L2 AND (UserData.tp_DirName=@DN) AND UserData.tp_RowOrdinal=0 AND (((UserData.[tp_WorkflowInstanceID] = N'184fc5b4-8c7b-4080-b4fe-005624355982') OR ((UserData.[tp_WorkflowInstanceID] = N'255b3465-840a-4a19-b27b-00d6920624c7') OR ((UserData.[tp_WorkflowInstanceID] = N'08199637-d1e1-45f0-a946-02b5e382f6d4') OR ((UserData.[tp_WorkflowInstanceID] = N'cf6f404b-07ee-4a6c-9918-0affdd4e0b42') OR ((UserData.[tp_WorkflowInstanceID] = N'77c307f8-3953-4358-9bab-0c68d19d9019') OR ((UserData.[tp_WorkflowInstanceID] = N'0ed4a99e-c47d-45cf-9326-0d03dc500301') OR ((UserData.[tp_WorkflowInstanceID] = N'4599203e-735b-4605-8989-0dbb9c0d72f5') OR ((UserData.[tp_WorkflowInstanceID] = N'76916aa7-7576-475a-9778-0e582be80fd3') OR ((UserData.[tp_WorkflowIn...
    
    ...stanceID] = N'202eedbe-8600-4371-8892-0e999853b03a') OR ((UserData.[tp_WorkflowInstanceID] = N'cd621f51-d471-4271-81ef-0f1029d35dd1') OR ((UserData.[tp_WorkflowInstanceID] = N'c6b373be-e91f-4aa0-8c39-165534d10de0') OR ((UserData.[tp_WorkflowInstanceID] = N'c9e0276f-6b7b-445a-a6d5-172169e8748e') OR ((UserData.[tp_WorkflowInstanceID] = N'e0ceba35-bd2c-4ed7-8265-1847f7fe2701') OR ((UserData.[tp_WorkflowInstanceID] = N'30a82553-67b9-4c98-a3ff-1907b659362b') OR ((UserData.[tp_WorkflowInstanceID] = N'1183677a-aaea-49db-ad11-1ca12b907df3') OR ((UserData.[tp_WorkflowInstanceID] = N'22055fe6-3716-4b4e-bd6f-1e9008f83b9b') OR ((UserData.[tp_WorkflowInstanceID] = N'c075582e-565d-4fd2-a160-1f027a120abf') OR ((UserData.[tp_WorkflowInstanceID] = N'4f9523cd-d563-42e3-b2ee-1f5cec98a854') OR ((UserData.[tp_...
    
    ...WorkflowInstanceID] = N'2223c191-2ace-45cd-9db5-1f8876e3e4f6') OR ((UserData.[tp_WorkflowInstanceID] = N'e9dfb9e0-d663-469d-9a70-1f9d9ca93683') OR ((UserData.[tp_WorkflowInstanceID] = N'9455800f-1d71-4c22-b391-231444073948') OR ((UserData.[tp_WorkflowInstanceID] = N'199aabb3-f7ce-4baa-a357-25b9109227ba') OR ((UserData.[tp_WorkflowInstanceID] = N'0b639cca-26d3-44c0-bd9c-2663ae8b7a6e') OR ((UserData.[tp_WorkflowInstanceID] = N'8834b64c-5969-4288-8546-27e7c231d98e') OR ((UserData.[tp_WorkflowInstanceID] = N'a0fe53fb-1062-4e49-b45e-2be79230963f') OR ((UserData.[tp_WorkflowInstanceID] = N'0697fa69-0e26-4f3b-8a5c-2c989897665a') OR ((UserData.[tp_WorkflowInstanceID] = N'ec36e356-0427-4651-a0d3-308b3197b5f2') OR ((UserData.[tp_WorkflowInstanceID] = N'9ad14fb7-28cd-4209-ae57-33fd9a7463ee') OR ((Use...
    
    ...rData.[tp_WorkflowInstanceID] = N'e6210db6-c0a6-4c7d-9974-36840211a11a') OR ((UserData.[tp_WorkflowInstanceID] = N'48473e8c-6529-471c-a4c4-37fc02523f3f') OR ((UserData.[tp_WorkflowInstanceID] = N'23dfd06e-a663-4596-9296-38a1f62f4dac') OR ((UserData.[tp_WorkflowInstanceID] = N'81d35174-c167-48ac-930f-400e2b15e66c') OR ((UserData.[tp_WorkflowInstanceID] = N'e2bee210-5aa5-4d1f-bdf6-410cfb054bf5') OR ((UserData.[tp_WorkflowInstanceID] = N'd5d95720-c409-42e7-8351-463aea7d5cff') OR ((UserData.[tp_WorkflowInstanceID] = N'b8fd26f4-c67d-43f7-bf4a-4cab38f28bd7') OR ((UserData.[tp_WorkflowInstanceID] = N'95c6d650-256d-4cd3-810a-4d2f47081202') OR ((UserData.[tp_WorkflowInstanceID] = N'49b97f94-85a2-4493-8b18-518afeb154bb') OR ((UserData.[tp_WorkflowInstanceID] = N'ffd81977-2dc1-4417-a123-51fb31c0ae20'...
    
    ...) OR ((UserData.[tp_WorkflowInstanceID] = N'e9cf7608-56d3-4131-b302-559a6fed3ce4') OR ((UserData.[tp_WorkflowInstanceID] = N'00343914-bd9b-4859-9919-574b4b41cac1') OR ((UserData.[tp_WorkflowInstanceID] = N'1f2dc015-554c-41cf-bbab-584efa65aa98') OR ((UserData.[tp_WorkflowInstanceID] = N'cf44e927-8eb7-4848-a238-58fc0891febc') OR ((UserData.[tp_WorkflowInstanceID] = N'11ea2fe3-3a36-4601-85aa-593b2e55065b') OR ((UserData.[tp_WorkflowInstanceID] = N'6170be61-1f88-4df4-a6ae-5a73fc35dd2d') OR ((UserData.[tp_WorkflowInstanceID] = N'09cdc5a6-9173-411f-a04f-5a7e88fec703') OR ((UserData.[tp_WorkflowInstanceID] = N'1678589c-cdef-4063-ad94-5c90f2073688') OR ((UserData.[tp_WorkflowInstanceID] = N'bb49f2a6-a3be-4131-9b86-5d9a5fd7624d') OR ((UserData.[tp_WorkflowInstanceID] = N'537bf099-13d4-4541-8828-5dc...
    
    ...be62142ab') OR ((UserData.[tp_WorkflowInstanceID] = N'ba3db8b4-8254-40d7-b0f4-5de90b714b9a') OR ((UserData.[tp_WorkflowInstanceID] = N'5c321849-c720-4324-80e6-5e5eed0e57cb') OR ((UserData.[tp_WorkflowInstanceID] = N'd1e567da-18cf-468c-9214-63121334b24e') OR ((UserData.[tp_WorkflowInstanceID] = N'ada15c29-60a2-4461-a759-64ef5f6ea8b2') OR ((UserData.[tp_WorkflowInstanceID] = N'ea9469b6-678d-4e0b-a955-6535a9459301') OR ((UserData.[tp_WorkflowInstanceID] = N'c05487f1-bb0c-4d61-9351-65918f01bc22') OR ((UserData.[tp_WorkflowInstanceID] = N'9c7c8610-bec0-464b-9ed7-67bdaf2b1dc6') OR ((UserData.[tp_WorkflowInstanceID] = N'5d50b211-16ea-4895-8508-6bb59c03257e') OR ((UserData.[tp_WorkflowInstanceID] = N'fe056f49-9e40-4900-9989-6e75bb5b8795') OR ((UserData.[tp_WorkflowInstanceID] = N'03b7224f-50ee-43a...
    
    ...9-8907-70cedd359e55') OR ((UserData.[tp_WorkflowInstanceID] = N'8c0d0ef3-49ae-4a49-b9c6-70f7f179cf7b') OR ((UserData.[tp_WorkflowInstanceID] = N'303c62b5-7f75-4d7a-a25a-71fec2170b61') OR ((UserData.[tp_WorkflowInstanceID] = N'127dc709-8419-42c3-a9a6-72158dbe4d5f') OR ((UserData.[tp_WorkflowInstanceID] = N'907e382b-6357-4376-8b2f-723309b67ea5') OR ((UserData.[tp_WorkflowInstanceID] = N'745545b6-7774-48e6-9636-7252df454df2') OR ((UserData.[tp_WorkflowInstanceID] = N'747a7054-a90d-4df5-ae6b-7258f97c8b00') OR ((UserData.[tp_WorkflowInstanceID] = N'af1dfd3b-e98c-48f4-86c4-7259b91010a7') OR ((UserData.[tp_WorkflowInstanceID] = N'02cd3a80-fc1d-4c61-ab70-72914f8c25a4') OR ((UserData.[tp_WorkflowInstanceID] = N'8eef99b0-5cbd-437a-8b02-73a761375957') OR ((UserData.[tp_WorkflowInstanceID] = N'e0ed1e7...
    
    ...b-4206-4b11-9e54-73d36f5f884e') OR ((UserData.[tp_WorkflowInstanceID] = N'fcc2d449-8264-4a14-b622-75ee2a43054a') OR ((UserData.[tp_WorkflowInstanceID] = N'93bd736a-5fe3-448b-9704-763d54f93e70') OR ((UserData.[tp_WorkflowInstanceID] = N'11495b8b-8393-4d71-9e6b-7a3aa94e0b7c') OR ((UserData.[tp_WorkflowInstanceID] = N'f132076b-11bb-4ea7-a7f3-7af0706d1d14') OR ((UserData.[tp_WorkflowInstanceID] = N'7310e25d-01fd-4010-a821-7b6cc928a3f4') OR ((UserData.[tp_WorkflowInstanceID] = N'3bdc6e76-5988-4021-bcce-7bf9d2396e12') OR ((UserData.[tp_WorkflowInstanceID] = N'acbbbb97-d61c-4229-885d-7e58b0bf16fa') OR ((UserData.[tp_WorkflowInstanceID] = N'68e43d11-a0b0-41a2-b94f-83f723bcc11b') OR ((UserData.[tp_WorkflowInstanceID] = N'7219c79e-a054-4992-b533-8464fe516c21') OR ((UserData.[tp_WorkflowInstanceID] =...
    
    ... N'e78062d6-4bd0-4ea8-8e45-851110694397') OR ((UserData.[tp_WorkflowInstanceID] = N'4750aef7-76e8-4cff-b995-855a1c45e108') OR ((UserData.[tp_WorkflowInstanceID] = N'0b4932ce-fc07-48ac-99cf-858cc53d349e') OR ((UserData.[tp_WorkflowInstanceID] = N'5e5317e4-750f-4a95-b46d-86261ae28f99') OR ((UserData.[tp_WorkflowInstanceID] = N'a15a21ff-f69e-4ff1-9948-863be9fce301') OR ((UserData.[tp_WorkflowInstanceID] = N'8a1320da-5cfa-435c-b0c3-865dfa3949b0') OR ((UserData.[tp_WorkflowInstanceID] = N'c2d968c4-04c8-4a20-ad5b-87f96aaae125') OR ((UserData.[tp_WorkflowInstanceID] = N'e6671a10-9880-4f81-aa04-89a6426d0472') OR ((UserData.[tp_WorkflowInstanceID] = N'38352291-d247-4192-b068-8d710f847003') OR ((UserData.[tp_WorkflowInstanceID] = N'f140b126-930a-4bf6-a7f3-909ed31d6155') OR ((UserData.[tp_WorkflowIns...
    
    ...tanceID] = N'1ce7e139-d767-48bb-a982-931122ea8133') OR ((UserData.[tp_WorkflowInstanceID] = N'a6714653-4883-4743-b976-93261a2ac537') OR ((UserData.[tp_WorkflowInstanceID] = N'e0c7beab-056a-4ab2-9c46-9337eac745e0') OR ((UserData.[tp_WorkflowInstanceID] = N'c555e42f-09ba-4863-97e6-9433ccebb54b') OR ((UserData.[tp_WorkflowInstanceID] = N'f62a6968-bff4-4577-8ad5-954f716fa4f8') OR ((UserData.[tp_WorkflowInstanceID] = N'46f0e4c3-3ccd-4f18-9d3f-99cbd77eebe2') OR ((UserData.[tp_WorkflowInstanceID] = N'43f2d7a8-963e-49b3-89f9-9a1e915c0297') OR ((UserData.[tp_WorkflowInstanceID] = N'6ce6bc60-b198-4f34-8a0c-9ad64eae6304') OR ((UserData.[tp_WorkflowInstanceID] = N'a9cb6a5e-ac49-4e4f-af36-9b8d24ee52a3') OR ((UserData.[tp_WorkflowInstanceID] = N'd5faafe9-2bb8-4859-8e71-9e33b16dcb83') OR ((UserData.[tp_W...
    
    ...orkflowInstanceID] = N'a9c30bd1-6258-4b07-b578-9e96c1695b66') OR ((UserData.[tp_WorkflowInstanceID] = N'd1d5426f-6127-4e03-a541-9e9fd77703c4') OR ((UserData.[tp_WorkflowInstanceID] = N'2162a2b7-4704-4bf9-83c5-9f8f772c8181') OR ((UserData.[tp_WorkflowInstanceID] = N'ac5e6afc-2ad7-4984-9022-9fb859ec3d3a') OR ((UserData.[tp_WorkflowInstanceID] = N'd24334cf-ae53-4558-a5a1-a1bc3bb823f9') OR ((UserData.[tp_WorkflowInstanceID] = N'4c381b22-658d-4b75-a9d3-a4510365ce77') OR ((UserData.[tp_WorkflowInstanceID] = N'2c4804c2-021e-4154-a7fe-a7babe3e1a51') OR ((UserData.[tp_WorkflowInstanceID] = N'6fe336e4-0c24-4f85-94af-a85251535c0a') OR ((UserData.[tp_WorkflowInstanceID] = N'd0630f5b-756f-4a26-ad3e-a909060f1610') OR ((UserData.[tp_WorkflowInstanceID] = N'bfc69f89-61c6-4088-9188-a9c7eab70abe') OR ((User...
    
    ...Data.[tp_WorkflowInstanceID] = N'8709f1d2-2eeb-481b-90f7-ab13d34eca1e') OR ((UserData.[tp_WorkflowInstanceID] = N'500b4fa3-6aa0-4e5d-a6ce-ab3ed6b1b4ed') OR ((UserData.[tp_WorkflowInstanceID] = N'e04c1e0a-b5e5-4715-8688-ac1082134360') OR ((UserData.[tp_WorkflowInstanceID] = N'5f05ce0d-f418-4805-9598-adc7703e4240') OR ((UserData.[tp_WorkflowInstanceID] = N'99ad4b40-92f6-4f8e-a1ed-ae1db5d1ec07') OR ((UserData.[tp_WorkflowInstanceID] = N'69670eaa-1236-47d3-a495-aea5ce50884e') OR ((UserData.[tp_WorkflowInstanceID] = N'38227707-c4fb-4fd5-b4e6-b144f5274220') OR ((UserData.[tp_WorkflowInstanceID] = N'5a9774d8-e64a-4b84-8645-b23d3a5f94b4') OR ((UserData.[tp_WorkflowInstanceID] = N'481c6e47-351b-4246-86a1-b7f585033aaa') OR ((UserData.[tp_WorkflowInstanceID] = N'8a8434ef-b7a4-41e7-ac24-bb1fad488f71')...
    
    ... OR ((UserData.[tp_WorkflowInstanceID] = N'6d8db2cc-e846-48e2-a7a6-bbff2b357278') OR ((UserData.[tp_WorkflowInstanceID] = N'e6c0bca9-fdd2-44bf-a39a-bc023e640745') OR ((UserData.[tp_WorkflowInstanceID] = N'4411522e-640b-4023-a0e8-bc65b5480ca8') OR ((UserData.[tp_WorkflowInstanceID] = N'635fedaa-b682-4955-a52a-bce1b9c0d074') OR ((UserData.[tp_WorkflowInstanceID] = N'1d11a10b-4359-4c30-928e-c38b38ba52d1') OR ((UserData.[tp_WorkflowInstanceID] = N'bd780e02-19c5-410d-9970-c51dbffddf9e') OR ((UserData.[tp_WorkflowInstanceID] = N'e6ed94a8-cdf5-4476-9530-c57be91732ac') OR ((UserData.[tp_WorkflowInstanceID] = N'5d99897e-6f5c-4b2a-b6b4-c6307358313e') OR ((UserData.[tp_WorkflowInstanceID] = N'81b9c1a4-3632-41e5-b2d2-c73c8fa30c98') OR ((UserData.[tp_WorkflowInstanceID] = N'72e68dd3-5c9b-4c55-a449-c748...
    
    ...f98b482c') OR ((UserData.[tp_WorkflowInstanceID] = N'fb150136-f690-4720-9f41-cbcf015632b2') OR ((UserData.[tp_WorkflowInstanceID] = N'90ab3486-180b-49e0-90ce-cc22b58efa58') OR ((UserData.[tp_WorkflowInstanceID] = N'41195bec-8c8b-4929-990f-cc645b56f778') OR ((UserData.[tp_WorkflowInstanceID] = N'a390a87f-4d6e-4cf7-86a1-ce2a5e89120f') OR ((UserData.[tp_WorkflowInstanceID] = N'1dd1a909-7a54-4576-b332-d1380e70516b') OR ((UserData.[tp_WorkflowInstanceID] = N'2cc0a0d4-a9f7-4e88-970f-d38332d78d46') OR ((UserData.[tp_WorkflowInstanceID] = N'ae341733-5f6e-4621-ab04-d53c69188675') OR ((UserData.[tp_WorkflowInstanceID] = N'3fb81c38-5e0f-45a4-8a04-d66e93806869') OR ((UserData.[tp_WorkflowInstanceID] = N'888d0a0d-8dd3-4849-af2e-dc58bfbd3178') OR ((UserData.[tp_WorkflowInstanceID] = N'4470d363-bdec-4ae6...
    
    ...-8ed2-dd2b786b2daf') OR ((UserData.[tp_WorkflowInstanceID] = N'b52704de-6315-4db7-ab3a-dd3124e4adb6') OR ((UserData.[tp_WorkflowInstanceID] = N'c0209840-848e-4200-8098-ddb9488e9153') OR ((UserData.[tp_WorkflowInstanceID] = N'5cc784dc-fada-47ce-8cf6-ddffcc7f563f') OR ((UserData.[tp_WorkflowInstanceID] = N'4b67f2d9-efc5-44c7-af60-de41b979d17d') OR ((UserData.[tp_WorkflowInstanceID] = N'664751c6-2b83-45c0-99aa-dea497182cfc') OR ((UserData.[tp_WorkflowInstanceID] = N'ef12ac50-4d84-4954-bd0b-df5fafa30061') OR ((UserData.[tp_WorkflowInstanceID] = N'7da7d460-b2ec-4b0b-8f6b-e107943d6f74') OR ((UserData.[tp_WorkflowInstanceID] = N'ccd5fb5d-eeef-4266-a25f-e3c2f95c1172') OR ((UserData.[tp_WorkflowInstanceID] = N'f126c555-9325-4bb8-8ed7-e5c4a80afea4') OR ((UserData.[tp_WorkflowInstanceID] = N'2948bc16...
    
    ...-a534-40ce-ac47-e8fa8646b6e2') OR ((UserData.[tp_WorkflowInstanceID] = N'544b4622-84ca-4016-9e17-ea3b2192f2f3') OR ((UserData.[tp_WorkflowInstanceID] = N'1e35350b-fa8e-47be-990d-ebca577226c9') OR ((UserData.[tp_WorkflowInstanceID] = N'c21d0af3-309f-4ce2-88b7-ec4cd17d49a5') OR ((UserData.[tp_WorkflowInstanceID] = N'd3aab850-37f1-4921-ba75-ee6d6a31ae12') OR ((UserData.[tp_WorkflowInstanceID] = N'fc2da0db-95e8-4dfd-a15f-f11dea6e5933') OR ((UserData.[tp_WorkflowInstanceID] = N'5f9e6e97-4b15-46ad-9e70-f3fcfdc26169') OR ((UserData.[tp_WorkflowInstanceID] = N'bb0d202e-320b-4f08-8a13-f424b86f9dc3') OR ((UserData.[tp_WorkflowInstanceID] = N'6ad26ab7-6727-4129-86d4-f640b87634e7') OR ((UserData.[tp_WorkflowInstanceID] = N'8fb7ee85-e9ca-4992-a503-f8c21c4ce4c9') OR ((UserData.[tp_WorkflowInstanceID] = ...
    
    ...N'570db6db-f183-41b9-8933-f997a49db38b') OR ((UserData.[tp_WorkflowInstanceID] = N'1bdd73f6-0798-44ed-87ee-f9e228ebc6f7') OR ((UserData.[tp_WorkflowInstanceID] = N'4b51c4dd-0386-4b67-b7c2-f9e62b73560b') OR ((UserData.[tp_WorkflowInstanceID] = N'584833dd-7759-43e9-a452-fa16f0632b78') OR ((UserData.[tp_WorkflowInstanceID] = N'302f99eb-bf66-44df-a860-fc0a3e98cfd1') OR ((UserData.[tp_WorkflowInstanceID] = N'1e2f9dd5-0fca-4907-ae4e-fced6ee73009') OR ((UserData.[tp_WorkflowInstanceID] = N'2f89e799-4aeb-4920-9672-fd5b5ecef163') OR (UserData.[tp_WorkflowInstanceID] = N'b1ce4e5a-207d-4904-9e4d-ff344d7c2e3c')))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND t1.SiteId=@L2 AND (t1.DirN...
    
    ...ame=@DN)) ORDER BY UserData.[tp_ID] Asc OPTION (FORCE ORDER) '  CommandType: Text CommandTimeout: 0  Parameter: '@L0' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00000000-0000-0000-0000-000000000000'  Parameter: '@L2' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'a272332d-b864-45ca-93e9-ffe4534d2d9b'  Parameter: '@L3' Type: UniqueIdentifier Size: 0 Direction: Input Value: '2d1a3016-f091-4199-88fe-4fcd8190f943'  Parameter: '@L4' Type: UniqueIdentifier Size: 0 Direction: Input Value: '3ee2645b-679a-4f51-ba95-3c393f5722d9'  Parameter: '@DN' Type: NVarChar Size: 260 Direction: Input Value: 'ICT/Lists/FSoC'
    
    Unknown SPRequest error occurred. More information: 0x80131904
    
    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.SqlInternalConnection.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.Fini...
    
    ...shExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)  at System.Data.SqlClient.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(SqlComm...
    
    ...and command, CommandBehavior behavior)

     


    • Edited by Mike Walsh FIN Tuesday, March 15, 2011 3:35 PM Quotes put around error message. ... within quotes indicates a longer message. Text SharePoint Error in title unnecessary and removed
    Tuesday, March 15, 2011 3:21 PM

Answers

All replies