In the released VS Team Explorer accessing the released TFS server, the project alert "My work item is changed by others" throws the error "TF50304: There is a syntax error in the subscription statement. Check the syntax." when clicking OK after selecting the alert and typing the email address. The other alerts can be set without error. How can I resolve this problem.

We have changed the temaplate. Would you be able to let me know what fields the filter is using? In the mean time we will see if we can locate the error.

Thanks

I have validated the web config file and the template. I am a TFS and Windows administrator. Another admin is able to create the alert successfully. I get the error using the Team Foundation Client on both my client PC and on the server.

I am unable to restart the server at this time to see if it clears this up. What else do you recommend.

Thanks

Michael

Let's see, first of all to check the filter the alert is using, you can just create the alert with the user is working, and check the subscription data in the database "TfsIntegration" in the table "tbl_subscription".

Second, with that, you can try to create the subscrition in the command line using bissubscribe.exe, with the same filter and user, to check if the problem is in the Visual Studio IDE, or in the user, Team Foundation or something else.

I think you should try this, as it seems pretty strange this problem

The default work item subscription only uses system fields, System.AssignedTo and System.AuthorizedAs. Customizing the process template cannot remove them.

The AssignedTo value is based on your display name. Do you have any wierd characters in your display name that might be causing the parser to blow up?

Also, make sure that you didn't accidentally delete the schema of the WorkItemChanged event. The schema is used to parse the filter string (and the event), and it's located here:

..\Microsoft Team Foundation 2005\Web Services\Services\v1.0\Transforms

If I register for 'My work items are changed by others', I also get the error "TF50304: There is a syntax error in the subscription condition. Check the syntax."

What is the solution to this problem.

That's strange. Were you able to create a work item changed subscription previously? It may be a permission issue.

Is this something to do with the single quote character in my surname O'Rourke? If I look at another users registration in the tbl_subscriptions table it contains the following:

"PortfolioProject" = 'MyProjectName' AND ("CoreFields/StringFields/Field[ReferenceName='System.AssignedTo']/OldValue" = 'Surname, Firstname' OR "CoreFields/StringFields/Field[ReferenceName='System.AssignedTo']/NewValue" = 'Surname, Firstname') AND "CoreFields/StringFields/Field[ReferenceName='System.AuthorizedAs']/NewValue" <> 'Surname, Firstname'

If this is the case how do I get the server to work with my user name?