Server Error Page: Some part of your SQL statement is nested too deeply.
Hello. I've come across this error page with a Sharepoint Server 2007. I've seen a few forums that say that Microsoft was going to fix this issue in its next major version, but I couldn't find out what version that was. Is the 2007 version without a fix for this? Is there a patch I could get, or is this part of a bigger issue? I should mention, I've received this error page after simply editing html code in a web part. There was no editing of sql statements. Thanks in advance.
October 29th, 2010 8:20am
This error can actually also be a CAML error. Did you edit any part of a CAML query in that web part?
October 29th, 2010 10:07am
No. Not at all. -- Benjamin J. DeLong
October 29th, 2010 11:34am
Hi Bozdoz, Thanks to share your problem. To produce the error, make a new list and try executing the subsequent SQL Statement: … to make test table … CREATE TABLE [dbo].[T1]( [ID] [int] IDENTITY(1,1) NOT NULL, [TValue] [varchar](MAX) NULL, CONSTRAINT [PK_T1] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO … Test slot in statements … -- Ent SQL Statement INSERT INTO T1 VALUES ('A' + ... + 'A') GO -- Trrb SQL Statement INSERT INTO T1 VALUES ('A' + ... + 'A' + 'EXTRA') GO This is a proper answer; the other possible solutions may be as followed: http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/1014552a-5d4c-416d-9e63-ffd891668785 http://www.sharepointdev.net/sharepoint--workflow/sql-error-some-part-of-your-sql-statement-is-nested-too-deeply-43029.shtml Hope this can help! Leo
November 3rd, 2010 4:30am