Microsoft KB Archive/920823

= Error message when you try to add a search alert in SharePoint Portal Server 2003: &quot;An error has occurred on the server&quot; =

Article ID: 920823

Article Last Modified on 9/13/2006

-

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 (&quot;DAV:contentclass&quot;:0,&quot;urn:schemas.microsoft.com:fulltextqueryinfo:description&quot;:0,&quot;urn:schemas.microsoft. com:fulltextqueryinfo:sourcegroup&quot;:0,&quot;urn:schemas.microsoft.com:fulltextqueryinfo:cataloggroup&quot;:0,&quot;urn:schemas -microsoft-com:office:office#Keywords&quot;:1.0,&quot;urn:schemas-microsoft- com:office:office#Title&quot;:0.9,&quot;DAV:displayname&quot;:0.9,&quot;urn:schemas-microsoft- com:publishing:Category&quot;:0.8,&quot;urn:schemas-microsoft-com:office:office#Subject&quot;:0.8,&quot;urn:schemas-microsoft- com:office:office#Author&quot;:0.7,&quot;urn:schemas-microsoft-com:office:office#Description&quot;:0.5,&quot;urn:schemas-microsoft- com:sharepoint:portal:profile:PreferredName&quot;:0.2,&quot;urn:schemas-microsoft- com:publishing:HomeBestBetKeywords&quot;:0.0,contents:0.1,*:0.05) AS #WeightedProps ..((&quot;urn:schemas-microsoft- com:publishing:HomeBestBetKeywords&quot;= some array ['microsoft'] RANK BY COERCION(absolute, 999))..OR (FREETEXT (&quot;urn:schemas-microsoft-com:sharepoint:portal:profile:PreferredName&quot;, 'microsoft') RANK BY COERCION(multiply, 0.01))..OR FREETEXT(#WeightedProps, 'microsoft') ....OR CONTAINS(&quot;urn:schemas-microsoft- com:sharepoint:portal:profile:PreferredName&quot;, '&quot;microsoft&quot;') RANK BY COERCION(multiply, 0.01).. OR CONTAINS(#WeightedProps, '&quot;microsoft&quot;')..).... AND ((&quot;PKMEvent&quot;='ADD') OR (&quot;PKMEvent&quot;='MODIFY'))&quot;CONTAINS (#WeightedProps, '&quot;microsoft&quot;')..).... AND ((&quot;PKMEvent&quot;='ADD') OR (&quot;PKMEvent&quot;='MODIFY'))&quot; 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 &quot;Add an alert for content on the portal site&quot; topic in the SharePoint Portal Server 2003 Help file.

Keywords: kbexpertiseinter kberrmsg kbnofix kbbug kbtshoot KB920823

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.