Microsoft Knowledge Base Email Alertz

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

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 920823 - Last Review: September 13, 2006 - Revision: 1.2

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

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.

APPLIES TO
  • Microsoft Office SharePoint Portal Server 2003
Keywords: 
kbexpertiseinter kberrmsg kbnofix kbbug kbtshoot KB920823
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Gopi - gopi.athmakuru NOSPAM-AT-NOSPAM capgemini.com Report As Irrelevant  
Written: 8/2/2007 11:15 PM
The work around is not clear. What we can replace with CONTAINS predicate that uses the #WeightedProps.