Error message when you try to add a search alert in SharePoint Portal Server 2003: "An error has occurred on the server" (920823)


The information in this article applies to:

  • Microsoft Office SharePoint Portal Server 2003

SYMPTOMS

Consider the following scenario. You try to add a search alert in Microsoft Office SharePoint Portal Server 2003 to track new matches to a search query. To do this, you search the portal site for content, and then you click Alert Me on the Search Results page. You specify the options that you want for the search alert on the Add Search Alert page. However, when you click OK, you receive the following error message:
Error

An error has occurred on the server.

CAUSE

This issue occurs when the search query contains a wildcard character. An example of a search query for which you experience this issue is as follows.
select contents from scope() where WITH
("DAV:contentclass":0,"urn:schemas.microsoft.com:fulltextqueryinfo:description":0,"urn:schemas.microsoft.
com:fulltextqueryinfo:sourcegroup":0,"urn:schemas.microsoft.com:fulltextqueryinfo:cataloggroup":0,"urn:schemas
-microsoft-com:office:office#Keywords":1.0,"urn:schemas-microsoft-
com:office:office#Title":0.9,"DAV:displayname":0.9,"urn:schemas-microsoft-
com:publishing:Category":0.8,"urn:schemas-microsoft-com:office:office#Subject":0.8,"urn:schemas-microsoft-
com:office:office#Author":0.7,"urn:schemas-microsoft-com:office:office#Description":0.5,"urn:schemas-microsoft-
com:sharepoint:portal:profile:PreferredName":0.2,"urn:schemas-microsoft-
com:publishing:HomeBestBetKeywords":0.0,contents:0.1,*:0.05) AS #WeightedProps ..(("urn:schemas-microsoft-
com:publishing:HomeBestBetKeywords"= some array ['microsoft'] RANK BY COERCION(absolute, 999))..OR (FREETEXT
("urn:schemas-microsoft-com:sharepoint:portal:profile:PreferredName", 'microsoft') RANK BY COERCION(multiply, 
0.01))..OR FREETEXT(#WeightedProps, 'microsoft') ....OR CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:PreferredName", '"microsoft"') RANK BY COERCION(multiply, 0.01).. 
OR CONTAINS(#WeightedProps, '"microsoft"')..).... AND (("PKMEvent"='ADD') OR ("PKMEvent"='MODIFY'))"CONTAINS
(#WeightedProps, '"microsoft"')..).... AND (("PKMEvent"='ADD') OR ("PKMEvent"='MODIFY'))"
In this example, the CONTAINS predicate uses a #WeightedProps property.

WORKAROUND

To work around this issue, modify the search query. To do this for this example, rewrite the CONTAINS predicate that uses the #WeightedProps property as multiple CONTAINS predicates that use the AND operator and the OR operator.

MORE INFORMATION

You can use the Alerts feature in SharePoint Portal Server 2003 to notify you when content on the portal site changes. You can add alerts to track different types of items. Add a search alert when you want to track new matches to a search query.

For more information about how to add a search alert in SharePoint Portal Server 2003, see the "Add an alert for content on the portal site" topic in the SharePoint Portal Server 2003 Help file.
Modification Type:MajorLast Reviewed:9/13/2006
Keywords:kbExpertiseInter kberrmsg kbnofix kbBug kbtshoot KB920823 kbAudKnowledgeWorker
©2004 Microsoft Corporation. All rights reserved.