|
Home > Archive > Commerce Server General > August 2004 > Error -- FreeTextPhraseSearch / Unclosed Quotation Mark
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error -- FreeTextPhraseSearch / Unclosed Quotation Mark
|
|
| Matthew 2004-08-27, 6:07 pm |
| I'm getting two errors that are unfamiliar to me when I perform a
FreeTextSearchPhrase CatalogSearch with large strings.
First Error:
If I run this search with a 8177 char FreeTextSearchPhrase string, the
browser returns a 'The page cannot be displayed' error, never making
it to the code in debug. I believe that this is a client POST
limitation issue. If so, what is the threshold or what do you suggest
as a workaround?
Second error:
If I perform the same search using 1665 chars, the search enters the
code, returns nothing from the Search method and throws the following
Commerce Server exception:
CatalogException --> "ICatalogManager::Search returned null. This can
happen if the specified catalog does not exist or if the
searchOptions.PropertiesToReturn is invalid."
And also throws the follow error message in the app log:
Commerce Server: Unclosed quotation mark before the character string
'8946ad35-d0fa-480f-a102-470f299594e0
bac94eef-2fdd-4c8e-8cd2-93eb928952a2
822dc86a-44be-438e-a9c0-99a2ea52e970
31e709b5-f826-404b-acdc-df4a1b330383
96356524-ff7a-4742-9f4a-9622a2b7acc1
e2af83e5-9ed0-400e-b440-428bd486e4c8
4f63c785-a8de-4b88-b329-78c646d97b62
65c1f617-094e-4517-9328-d418231d3202
cd9ac182-dbfa-4d86-b0f1-4e5dc9eff341 ecc7aec8-0...
The catalog does exist and the PropertiesToReturn are valid, so I
don't think that's the issue. Also, I tried the search with only 7
valid PropertiesToReturn with no luck. I am not using a virtual
catalog. I don't believe the string has an unclosed quotation mark.
Here is the following string that I'm sending:
"8946ad35-d0fa-480f-a102-470f299594e0
bac94eef-2fdd-4c8e-8cd2-93eb928952a2
822dc86a-44be-438e-a9c0-99a2ea52e970
31e709b5-f826-404b-acdc-df4a1b330383
96356524-ff7a-4742-9f4a-9622a2b7acc1
e2af83e5-9ed0-400e-b440-428bd486e4c8
4f63c785-a8de-4b88-b329-78c646d97b62
65c1f617-094e-4517-9328-d418231d3202
cd9ac182-dbfa-4d86-b0f1-4e5dc9eff341
ecc7aec8-09f6-446e-b9a7-3c6fe3bf9b0a
2a7ec057-de3b-463a-9e64-ea24a51dd16d
7e15b161-57b7-4efb-8c95-25a24c0fe15f
272d003f-785f-4a0f-b924-267a4cdde105
2c1bbd52-6595-451f-bfbb-e9ab0ea82994
0a85b66b-deec-49d4-a7b8-b8a4ef8ed116
a02760a0-c8a5-4015-b2e9-526a585954de
24b51b8a-caf4-42a3-b9e6-576bee8ca784
a94c9a52-9e0e-4309-9a3b-6e09a3b6eced
e0e69655-69bb-4d7d-acb9-15307c11f59d
1c121ffa-3d24-40bd-9d3e-bdda19555f5c
a55ceb33-2a32-4c6f-8c9d-f96ea727eb21
f8f10afd-e8a4-4717-8c36-3096e98cc346
8ce858f8-df65-4ed2-988f-3a54dbd555f7
f72154b3-d817-4cbd-acb1-574480513db4
1f9c3156-8887-4a4c-8458-a0801f449422
6e97bd26-6a71-43ba-bdef-8197172587ee
af24a470-3c05-42a6-a172-e35141b47821
c449e371-07dd-4be0-ba43-1d7e997731d9
08d614df-6ccb-46a8-a484-62c4ba5ae300
a6b18bb0-4797-44cb-a9b7-d608df711f7a
4def402c-200b-4287-9da7-42d0c82d8657
9a61cc7b-c619-4a2a-8bdd-a56c76786bba
6306e39f-9286-42b0-a8c2-b261ffe9539a
6324a9aa-b160-4b85-b57b-d844cb61f4f3
12905388-154c-49a6-b90a-74aa1bc8795e
40a8c203-3a13-4df1-b56d-d5b4f375d8b6
6e8d5473-d394-45bf-82a7-3fee91d13dec
e3b54819-08ec-460d-84a2-a684936f5d3e
c0f20154-26ab-432c-8f65-2439c7965832
588daf9a-dc18-4e01-99f2-8491061510c4
095198d8-b2be-4a64-b821-9812d669a8bd
aa1bad22-5bd4-4328-98a1-cc4ed6a8be57
fdbfa1d9-ccc6-4aaa-9578-cba9669b77ce
df75e2ff-c1f0-40c4-9371-636dfe7fdfab
62f26ddb-11ee-4432-9ae2-d7046755a3c4
6ecd680f-3718-4c46-984b-3153b09bbc49
93ab9968-b013-4556-8c90-e09ce3064f76
3728df29-d80a-4b48-b36e-68437a13fe4c "
What I'm thinking is maybe that 1665 chars is below the POST
threshold, but it is above the CatalogSeach threshold, causing a
truncation of the search string, resulting in the error seen in #2.
We can successfully search using up to 1628 characters.
Does this mean that the FreeTextSearchPhrase threshold lies somewhere
between 1628 chars and 1665 chars? If this is the case, can the
CatalogSearch threshold be modified?
| |
| Vinayak Tadas[MSFT] 2004-08-27, 6:07 pm |
| You are exceeding the limit of the freetext search phrase. The limit is
around 1600 characters.
Any reason you want to search for search large strings.
Can you describe your scenario.
--------------------
From: clemmonsm@yahoo.com (Matthew)
Newsgroups:
microsoft.public.commerceserver.catalog,microsoft.public.commerceserver.gene
ral
Subject: Error -- FreeTextPhraseSearch / Unclosed Quotation Mark
Date: 26 Aug 2004 14:17:16 -0700
Organization: http://groups.google.com
Lines: 97
Message-ID: <a0cb7688.0408261317.9461204@posting.google.com>
NNTP-Posting-Host: 169.146.191.10
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1093555036 13158 127.0.0.1 (26 Aug 2004
21:17:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 26 Aug 2004 21:17:16 +0000 (UTC)
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!n
ews.maxwell.syr.edu!postnews2.google.com!not-for-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:14640
microsoft.public.commerceserver.catalog:4903
X-Tomcat-NG: microsoft.public.commerceserver.general
I'm getting two errors that are unfamiliar to me when I perform a
FreeTextSearchPhrase CatalogSearch with large strings.
First Error:
If I run this search with a 8177 char FreeTextSearchPhrase string, the
browser returns a 'The page cannot be displayed' error, never making
it to the code in debug. I believe that this is a client POST
limitation issue. If so, what is the threshold or what do you suggest
as a workaround?
Second error:
If I perform the same search using 1665 chars, the search enters the
code, returns nothing from the Search method and throws the following
Commerce Server exception:
CatalogException --> "ICatalogManager::Search returned null. This can
happen if the specified catalog does not exist or if the
searchOptions.PropertiesToReturn is invalid."
And also throws the follow error message in the app log:
Commerce Server: Unclosed quotation mark before the character string
'8946ad35-d0fa-480f-a102-470f299594e0
bac94eef-2fdd-4c8e-8cd2-93eb928952a2
822dc86a-44be-438e-a9c0-99a2ea52e970
31e709b5-f826-404b-acdc-df4a1b330383
96356524-ff7a-4742-9f4a-9622a2b7acc1
e2af83e5-9ed0-400e-b440-428bd486e4c8
4f63c785-a8de-4b88-b329-78c646d97b62
65c1f617-094e-4517-9328-d418231d3202
cd9ac182-dbfa-4d86-b0f1-4e5dc9eff341 ecc7aec8-0...
The catalog does exist and the PropertiesToReturn are valid, so I
don't think that's the issue. Also, I tried the search with only 7
valid PropertiesToReturn with no luck. I am not using a virtual
catalog. I don't believe the string has an unclosed quotation mark.
Here is the following string that I'm sending:
"8946ad35-d0fa-480f-a102-470f299594e0
bac94eef-2fdd-4c8e-8cd2-93eb928952a2
822dc86a-44be-438e-a9c0-99a2ea52e970
31e709b5-f826-404b-acdc-df4a1b330383
96356524-ff7a-4742-9f4a-9622a2b7acc1
e2af83e5-9ed0-400e-b440-428bd486e4c8
4f63c785-a8de-4b88-b329-78c646d97b62
65c1f617-094e-4517-9328-d418231d3202
cd9ac182-dbfa-4d86-b0f1-4e5dc9eff341
ecc7aec8-09f6-446e-b9a7-3c6fe3bf9b0a
2a7ec057-de3b-463a-9e64-ea24a51dd16d
7e15b161-57b7-4efb-8c95-25a24c0fe15f
272d003f-785f-4a0f-b924-267a4cdde105
2c1bbd52-6595-451f-bfbb-e9ab0ea82994
0a85b66b-deec-49d4-a7b8-b8a4ef8ed116
a02760a0-c8a5-4015-b2e9-526a585954de
24b51b8a-caf4-42a3-b9e6-576bee8ca784
a94c9a52-9e0e-4309-9a3b-6e09a3b6eced
e0e69655-69bb-4d7d-acb9-15307c11f59d
1c121ffa-3d24-40bd-9d3e-bdda19555f5c
a55ceb33-2a32-4c6f-8c9d-f96ea727eb21
f8f10afd-e8a4-4717-8c36-3096e98cc346
8ce858f8-df65-4ed2-988f-3a54dbd555f7
f72154b3-d817-4cbd-acb1-574480513db4
1f9c3156-8887-4a4c-8458-a0801f449422
6e97bd26-6a71-43ba-bdef-8197172587ee
af24a470-3c05-42a6-a172-e35141b47821
c449e371-07dd-4be0-ba43-1d7e997731d9
08d614df-6ccb-46a8-a484-62c4ba5ae300
a6b18bb0-4797-44cb-a9b7-d608df711f7a
4def402c-200b-4287-9da7-42d0c82d8657
9a61cc7b-c619-4a2a-8bdd-a56c76786bba
6306e39f-9286-42b0-a8c2-b261ffe9539a
6324a9aa-b160-4b85-b57b-d844cb61f4f3
12905388-154c-49a6-b90a-74aa1bc8795e
40a8c203-3a13-4df1-b56d-d5b4f375d8b6
6e8d5473-d394-45bf-82a7-3fee91d13dec
e3b54819-08ec-460d-84a2-a684936f5d3e
c0f20154-26ab-432c-8f65-2439c7965832
588daf9a-dc18-4e01-99f2-8491061510c4
095198d8-b2be-4a64-b821-9812d669a8bd
aa1bad22-5bd4-4328-98a1-cc4ed6a8be57
fdbfa1d9-ccc6-4aaa-9578-cba9669b77ce
df75e2ff-c1f0-40c4-9371-636dfe7fdfab
62f26ddb-11ee-4432-9ae2-d7046755a3c4
6ecd680f-3718-4c46-984b-3153b09bbc49
93ab9968-b013-4556-8c90-e09ce3064f76
3728df29-d80a-4b48-b36e-68437a13fe4c "
What I'm thinking is maybe that 1665 chars is below the POST
threshold, but it is above the CatalogSeach threshold, causing a
truncation of the search string, resulting in the error seen in #2.
We can successfully search using up to 1628 characters.
Does this mean that the FreeTextSearchPhrase threshold lies somewhere
between 1628 chars and 1665 chars? If this is the case, can the
CatalogSearch threshold be modified?
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks
| |
| Matthew 2004-08-27, 6:07 pm |
| Thanks for quick your reply.
The client wants a keyword phrase search where the user can select
multiple keyword phrases from a listbox. Currently the client has
around 220 phrases in this list box.
In the string I provided above you'll notice I'm passing guids. The
guid is the value and the keyword phrase is the key. Both of these
strings are product properties in Commerce Server. The reason for
using a guid is so that I can return specific results for given
keyword phrases since many of the phrases will have similar words.
If we have to, I can tell the client that there will be a max number
of keywords we can search with and I could write some javascript to
limit the selection, but if there's a workaround, then I'd like to
give it a shot.
vtadas@online.microsoft.com ("Vinayak Tadas[MSFT]") wrote in message news:<BuprEd7iEHA.2516@cpmsftngxa10.phx.gbl>...
> You are exceeding the limit of the freetext search phrase. The limit is
> around 1600 characters.
> Any reason you want to search for search large strings.
> Can you describe your scenario.
| |
| Vinayak Tadas[MSFT] 2004-08-27, 6:07 pm |
| Unfortunately there is no workaround. You will have to limit the search
phrase to less than the 1600 or so character limit.
Thanks for explaining your scenario though!
--------------------
From: clemmonsm@yahoo.com (Matthew)
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: Error -- FreeTextPhraseSearch / Unclosed Quotation Mark
Date: 27 Aug 2004 12:04:47 -0700
Organization: http://groups.google.com
Lines: 23
Message-ID: <a0cb7688.0408271104.3950cdbe@posting.google.com>
References: <a0cb7688.0408261317.9461204@posting.google.com>
<BuprEd7iEHA.2516@cpmsftngxa10.phx.gbl>
NNTP-Posting-Host: 169.146.191.10
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1093633487 11221 127.0.0.1 (27 Aug 2004
19:04:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 27 Aug 2004 19:04:47 +0000 (UTC)
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!fr.ip.ndsoftware.net!proxad.net!postnews2.google.
com!not-for-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:14648
X-Tomcat-NG: microsoft.public.commerceserver.general
Thanks for quick your reply.
The client wants a keyword phrase search where the user can select
multiple keyword phrases from a listbox. Currently the client has
around 220 phrases in this list box.
In the string I provided above you'll notice I'm passing guids. The
guid is the value and the keyword phrase is the key. Both of these
strings are product properties in Commerce Server. The reason for
using a guid is so that I can return specific results for given
keyword phrases since many of the phrases will have similar words.
If we have to, I can tell the client that there will be a max number
of keywords we can search with and I could write some javascript to
limit the selection, but if there's a workaround, then I'd like to
give it a shot.
vtadas@online.microsoft.com ("Vinayak Tadas[MSFT]") wrote in message
news:<BuprEd7iEHA.2516@cpmsftngxa10.phx.gbl>...
> You are exceeding the limit of the freetext search phrase. The limit is
> around 1600 characters.
> Any reason you want to search for search large strings.
> Can you describe your scenario.
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks
| |
| Matthew 2004-08-30, 5:55 pm |
| Thanks for the help, Vinayak.
|
|
|
|
|