Event Handler Service - update "Work Remaining (hours)" in Product Backlog item - Scrum for Team System
Welcome to Scrum for Team System Sign in | Join

Scrum for Team System - v2.x Support

Started by pietergheysens at 06-06-2008 12:55 PM. Topic has 10 replies.

Print Search
Sort Posts:    
   06-06-2008, 12:55 PM
pietergheysens is not online. Last active: 6/6/2008 11:46:21 AM pietergheysens

Top 150 Posts
Joined on 06-06-2008
Posts 5
Event Handler Service - update "Work Remaining (hours)" in Product Backlog item
My installation : Windows Server 2008, TFS2008, SrumForTeamSystem v2.1

The "Work Remaining (hours)" field is not updated. This is probably caused by the Event Handler Service that's not working/installed on my machine. How can I find out what's wrong with the Event Handler Service? Where to look for the web service?

   Report 
   06-06-2008, 1:17 PM
Crispin Parker is not online. Last active: 11/13/2008 8:15:53 PM Crispin Parker

Top 10 Posts
Joined on 11-13-2007
Posts 664
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item
Hello,

Regarding the event handler service:

Their isn't actually a service running, instead there is a web service endpoint that is called from TFS when changes are made to work items. The default location of the web service is:

http://[TFSHost]/ScrumforTeamSystem/WorkItemChangedEvent.asmx

It is possible to enable trace file logging on the service by specifing an output file within the web.config. I've explained how to accomplish this in this forum thread:

Hope this helps.


Regards,

Crispin Parker,
Technical Consultant,
Conchango.


"It is better to light a candle than to curse the darkness"
   Report 
   06-06-2008, 1:49 PM
pietergheysens is not online. Last active: 6/6/2008 11:46:21 AM pietergheysens

Top 150 Posts
Joined on 06-06-2008
Posts 5
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item
Thx for your quick reply Crispin. I managed already to activate the logging. The field is not recalculated after changes to a SBI, but when I manually call the webservice, the field gets updated! So my question now : why isn't this working automatically after changes to the SBIs?
   Report 
   06-06-2008, 2:00 PM
Crispin Parker is not online. Last active: 11/13/2008 8:15:53 PM Crispin Parker

Top 10 Posts
Joined on 11-13-2007
Posts 664
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item
Is TFS calling the web service when work items are changed (are there any trace file entries)?
Is there any messages in the Event log [on the TFS machine] that indicate a problem?

Crispin.

"It is better to light a candle than to curse the darkness"
   Report 
   06-06-2008, 2:11 PM
pietergheysens is not online. Last active: 6/6/2008 11:46:21 AM pietergheysens

Top 150 Posts
Joined on 06-06-2008
Posts 5
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item
The web service is not called : no trace file entries. No messages in the Event log on the TFS machine ...
   Report 
   06-06-2008, 2:42 PM
Crispin Parker is not online. Last active: 11/13/2008 8:15:53 PM Crispin Parker

Top 10 Posts
Joined on 11-13-2007
Posts 664
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item
OK, next thing to check is that  the subscription entry exists in the TFS database.

To do this, open a SQL Management Studio instance on the TFS machine and then execute the below script:

SELECT [id]
      ,[event_type]
      ,[expression]
      ,[subscriber]
      ,[schedule]
      ,[delivery_type]
      ,[address]
      ,[classification]
  FROM [TfsIntegration].[dbo].[tbl_subscription]

If the server is correctly set up, there should be an entry that specifies the"WorkItemChangedEvent" and points to the scrum service endpoint.

If this entry does not exist, then you will need to re-install the SfTS template.

Another thing to check is that the "Visual Studio Team Foundation Server Task Scheduler" service is running. This service is required in order to broadcasting the work item changed events.

Crispin.

"It is better to light a candle than to curse the darkness"
   Report 
   06-06-2008, 3:04 PM
pietergheysens is not online. Last active: 6/6/2008 11:46:21 AM pietergheysens

Top 150 Posts
Joined on 06-06-2008
Posts 5
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item
The service was running and an entry was found in the database for "WorkItemChanged", but I noticed that the address didn't match the actual location of the webservice. I installed the ScrumForTeamSystem webservice on the TFS website on port 8080, but the address in the tbl_subscription table pointed to the default port 80. After setting the port correctly in the address field everything worked. Problem solved. Thx for pointing me in the right direction!
   Report 
   10-07-2008, 11:24 PM
buildboy is not online. Last active: 10/7/2008 10:18:32 PM buildboy

Top 500 Posts
Joined on 03-03-2008
Posts 2
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item

I am having the same issue, except that there is only one event definition in the subscription table and we have 4 scrum projects.  So the behavior we are seeing is that the other project are not getting updated.  How  can I add the other subscriptions?  AND how do I tell TFS to update itself after a subscription has changed?


   Report 
   10-07-2008, 11:41 PM
Crispin Parker is not online. Last active: 11/13/2008 8:15:53 PM Crispin Parker

Top 10 Posts
Joined on 11-13-2007
Posts 664
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item
Hi BuildBoy,

The subscription you have spotted in the table covers all projects. The "WorkItemChanged" event is triggered whenever a work item is saved to the tfsWorkItem database regardless of source project.

If one of the projects is getting updated and the others are not, then the issue is not with subscriptions. I suggest that you enable logging in the event handling service and see if that revels any clues to the cause of the problem.

The following post details how to enable event logging.

http://scrumforteamsystem.com/cs/forums/2048/ShowPost.aspx#2048

You will need to restart IIS in order for the TFS process to pick up changes to the Subscription table.


Hope this helps, post back if you need to.


Regards,

Crispin Parker,
Technical Consultant,
Conchango.

"It is better to light a candle than to curse the darkness"
   Report 
   10-08-2008, 12:35 AM
buildboy is not online. Last active: 10/7/2008 10:18:32 PM buildboy

Top 500 Posts
Joined on 03-03-2008
Posts 2
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item

That makes sense except for the filter that is part of the Subscription. The filter expression look like this:

"PortfolioProject" = '<project name>' AND ("CoreFields/StringFields/Field[ReferenceName = 'System.WorkItemType']/NewValue" = "Sprint Backlog Item") OR ("CoreFields/StringFields/Field[ReferenceName = 'System.WorkItemType']/NewValue" = "Product Backlog Item") OR ("CoreFields/StringFields/Field[ReferenceName = 'System.WorkItemType']/NewValue" = "Bug")

Is this wrong?  I thought that this subscription & filter was created by the Scrum plug-in.  We had another subscription that did not contain a filter and we needed to remove because it kept throwing a null exception.  We found that one the fields it was expecting had been removed from the work item from.

Thank you

   BuildBoy

 


   Report 
   10-08-2008, 9:28 AM
Crispin Parker is not online. Last active: 11/13/2008 8:15:53 PM Crispin Parker

Top 10 Posts
Joined on 11-13-2007
Posts 664
Re: Event Handler Service - update "Work Remaining (hours)" in Product Backlog item
This is the default contents of the "expression" field after the Scrum for Team System installation:

("CoreFields/StringFields/Field[ReferenceName = 'System.WorkItemType']/NewValue" = "Sprint Backlog Item") OR
("CoreFields/StringFields/Field[ReferenceName = 'System.WorkItemType']/NewValue" = "Product Backlog Item") OR
("CoreFields/StringFields/Field[ReferenceName = 'System.WorkItemType']/NewValue" = "Bug")

The "PortfolioProject" field detailed in your post must have been added manually at some point after the installation.

Crispin.

"It is better to light a candle than to curse the darkness"
   Report 
Scrum for Team ... » Version 2.x - T... » Scrum for Team ... » Event Handler Service - update "Work Remaining (hours)" in Product Backlog item

Powered by Community Server, by Telligent Systems