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?
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2010 4:30am