Sign In
Anjali's Blog
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Blog Home
Email Blog Author
Share this
RSS for posts
Atom
RSS for comments
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
After Properties
AllowUnsafeUpdates
ASP.NET Server Control
BreakRoleInheritance
CommonViewFields
content editor webpart
Content Query Webpart
crawling links
custom fields
DataColumnRenames
DateTime Field
discussion board
EventHandler
FormDigest
GetCustomListTemplates
HTTP 200
HTTP 301
security validation
SPListTemplateCollection
table styles
table templates
team discussions
templates
URL rewriting
Web Control Library
Archive
Archives
August 2009
(4)
June 2009
(8)
The maximum limit for the length of the QueryText property of FullTextSqlQuery is 4096 characters.
MSDN Blogs
>
Anjali's Blog
>
The maximum limit for the length of the QueryText property of FullTextSqlQuery is 4096 characters.
The maximum limit for the length of the QueryText property of FullTextSqlQuery is 4096 characters.
anjali_chelawat
15 Jun 2009 7:43 PM
Comments
0
Requirement:
I was working on case, where Customer's business requirement was to have the length of the
QueryText
property of
FullTextSqlQuery
to be
UNLIMITED
.
Troubleshooting:
Moment the code touches the limit of about 4093 it throws the error
Error: Specified argument was out of range of valid values; _COMPlusExceptionCode -532459699
Occurs When: Error comes when trying to assign the
string
value to the
QueryText
property itself.
Took help from our Escalation engineer Nishandv, to know the exact hard-code limit (if any) in SharePoint for
QueryText
property of
FullTextSqlQuery
object
Resolution / WorkAround:
When using
FullTextSqlQuery
objects for search; make sure the length of the
QueryText
Property
do not exceed 4096 characters
Reference :
Nishand's blog for reference:
http://blogs.msdn.com/nishand/archive/2008/10/02/fulltextsqlquery-with-querytext-length-gt-4096-throws-argumentoutofrange-exception.aspx
0 Comments
Blog - Comment List MSDN TechNet
Comments
Loading...
Leave a Comment
Name
Comment
Please add 8 and 7 and type the answer here:
Post