The report "Bug Rates" used to work great. It shows us how many Work Items were in the System, how many were resolved, new active etc. (the way it should).
I exported 250 Work Items from one of our products as a trial for TFS, threw them into Excel, and published. This worked great. The Report showed a huge spike of Work Items.
Now, I've gone through all those Work Items, and instead of having them assigned to me, I have them assigned to "Administrator" who we're using as a place holder for Work Items not yet assigned until we have our meeting on what we should do with these.
Now when I go to this report, it shows 0 for everything on the report. I still have 5 work items assigned to me. I just created a new one, yet the report isn't picking any of these up.
How do I check what's going on with this report
---Edit
This is also an issue on "remaining work"
Bug Rates Report - Getting very weird report
ghamm
I'm looking at the DataBase, and it seems that the "Current Work Item" table has a different column layout than the "Work Item" Table.
The "Current Work Item" table has all the fields I've added to the WorkItems, (ReleaseNumber etc.) but the "Work Item" table doesn't have those... would that be this issue
---Edit
I also got the 2nd query on Step 2 to work.:
-- total revisions in the relational warehouse
use
TfsWarehouseselect
top 1 __LastUpdatedTime as [LastVCWHWrite] from dbo.[Code Churn] with (nolock) order by __LastUpdatedTime descselect
top 1 __LastUpdatedTime as [LastWITWHWrite] from dbo.[Work Item History] with (nolock) order by __LastUpdatedTime descMy LastUPdatedTime needed 2 "_" infront... strange but ok. The Date/Time returned was the same +/- 4 seconds. (2006-05-24 11:05:09.313)
SlowBowler
Hi rternier,
Are you still running into any issues Please let me know if there is anything that we can do to help.
Thanks,
Alan
Lampy
I am having exactly the same problem with the "Bug rates" and "Remaining work" reports: suddenly (from the 1st of July 2006) all the 3 indicators (Active, New and Reactivated, Resolved as Fixed) dropped dead to zero.
The difference between me and rternier - the initiator of this Thread - is that I didn't modified any templates of any work item, but I did deleted a project and then recreate it by the same name, as specified in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=154526&SiteID=1. But I also followed the steps to fix that and didn't fixed the problem. So, I give you exactly my steps following the http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=154526&SiteID=1, at 5 of July 2006, 18.30 hour Eastern European Time:
At STEP 2 I got the results (after renaming "LastUpdatedTime" into "__LastUpdatedTime"):
LastCubeProcessing
- blank -
-------------------------
LastVCWHWrite
2006-06-16 16:27:25.557
-------------------------
LastWITWHWrite
2006-06-28 15:05:21.530
-------------------------
WH Reviosions
11299
-------------------------
WIT Revisions
11898
-------------------------
WH Changeset
15
-------------------------
VC Changeset
1682
-------------------------
WareHouse Identity Id
211
-------------------------
Integration Identity Id
212
-------------------------
WareHouseStructureId
192
-------------------------
Integration Structure Id
206
-------------------------
At STEP 3, when Enabling the method Run from http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx I got 2 logging errors:
1.
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 05.07.2006 15:32:45
Machine: SQL06
Application Domain: /LM/W3SVC/3/Root/Warehouse-6-127965849346697514
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 712
Thread Id: 5236
Account name: ASSOLUTIONS\matei.puiu
Detailed Message: Create OLAP failed
Exception Message: The following system error occurred: No mapping between account names and security IDs was done. .
(type OperationException)
Exception Stack Trace: at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String dataReaderAccount, Boolean dropDB)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
------------------------------------------------
and the second logging error:
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 05.07.2006 15:32:45
Machine: SQL06
Application Domain: /LM/W3SVC/3/Root/Warehouse-6-127965849346697514
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 712
Thread Id: 5236
Account name: ASSOLUTIONS\matei.puiu
Detailed Message: The pending configuration changes were not successfully added to the cube because of the following error: Microsoft.AnalysisServices.OperationException: The following system error occurred: No mapping between account names and security IDs was done. .
at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String dataReaderAccount, Boolean dropDB)
at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.EnsureCubeIsUpToDate()
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
--------------------------------------------------------------------------------------------------------------
I also did the UPDATE from 2. Are iterations or area nodes not showing up in reports
(because I deleted and recreated a project under the same name)
and the change from 3. Scenario Details and Related Workitem Reports show no data (specified in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=112925&SiteID=1 ), but nothing good changed to the Bug Rates report either.
Is there a way to repair the Bug Rates report
Big thanks,
Matei Puiu.
DarrenONeill111
I was looking around in the DB and all of the sudden I refreshed the report page and they all started working again...
Maybe something didn't get updated properly or a service wasn't running right...
All is working fine now :D
Yael
Thanks.
I'll run through it. This started when I added fields to the Bug "work item" and added my own work items. I added the duration/start time/ end time etc. fields that the Tasks work Item has so we can track Bugs in Project (seeing as Bugs do have duraton to fix).
PugRallye
Re: "Current Work Item" and "Work Item" table columns not matching
The "Work Item" shouldn't have new columns for DateTime dimensions and Measures (the field types that you added).
Re: Double underscore prepended to LastUpdateTime
Prepending the double underscore to LastUpdateTime was a change in the RTM version. As you have seen when looking at the tables, several field names are now prepended with __.
Re: Eventvwr error
When you manually process the warehouse do you always get the error:
Detailed Message: The pending configuration changes were not successfully added to the cube because of the following error: Microsoft.AnalysisServices.OperationException: The following system error occurred: No mapping between account names and security IDs was done. .
In your eventvwr You can manually process the warehouse by:
From the application Tier machine - Browse to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx, click Run then Invoke. True means the warehouse is processing.
To check the status, from the link above, click GetWarehouseStatus - Invoke. When this returns Idle processing has completed.
KindSword
Hi,
Hmm... it sounds like something may be going wacky with the warehouse processing. can you follow the steps in the warehouse troubleshooting guide to see if the data is getting updated
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=154526&SiteID=1
mauli
aant10
Just ran through those steps.
The first step was fine.
On the 2nd step, the SQL Queries, I got Query Errors. Here's the results:
use TfsWarehouse
select Setting as [Last Cube Processing] from _WarehouseConfig where ID = 'LastProcessedTime'
Returned nothing.
-- total revisions in the relational warehouse
use TfsWarehouse
select top 1 LastUpdatedTime as [LastVCWHWrite] from dbo.[Code Churn] with (nolock) order by LastUpdatedTime desc
select top 1 LastUpdatedTime as [LastWITWHWrite] from dbo.[Work Item History] with (nolock) order by LastUpdatedTime desc
Returned:
Msg 207, Level 16, State 1, Line 3
Invalid column name 'LastUpdatedTime'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'LastUpdatedTime'.
Msg 207, Level 16, State 1, Line 4
Invalid column name 'LastUpdatedTime'.
Msg 207, Level 16, State 1, Line 4
Invalid column name 'LastUpdatedTime'.
use TfsWarehouse
select count(*) as [WH Revisions] from [dbo].[Work Item History] with (nolock)
where [Record Count] <> -1
returned: 259
use TfsWorkitemTracking
select count(*) as [WIT Revisions] from [dbo].[WorkitemsLatestAndWere] with (nolock)
returned: 445
use TfsWarehouse
select max ([Changeset ID]) as [WH Changeset] from [dbo].Changeset with (nolock)
where DimensionMemberActive = 1
returned:
Msg 207, Level 16, State 1, Line 2
Invalid column name 'DimensionMemberActive'.
use TfsVersionControl
select max(ChangeSetId) as [VC Changeset] from tbl_Changeset with (nolock)
returned: 39
-- identities
use TfsWarehouse
select Property_Value as [Warehouse Identity Id] from _PropertyBag
where Property_Key = 'CSS Identity Sequence Id'
returned : 23
use TfsIntegration
select max(sequence_Id) as [Integration Identity Id] from tbl_security_identity_cache
returned: 23
-- structure
use TfsWarehouse
select Property_Value as [Warehouse Structure Id] from _PropertyBag
where Property_Key = 'CSS Structure Sequence Id'
returned: 95
use
TfsIntegrationselect max(sequence_Id) as [Integration Structure Id] from tbl_nodes with (nolock)
returned 95
In the 3rd Step I do see errors in the APplicaiton Log: (This same error occurs every 1+/- a minute)
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 5/23/2006 4:20:17 PM
Machine: APPSERVER01
Application Domain: /LM/W3SVC/3/Root/Warehouse-1-127928748028939644
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 4288
Thread Id: 4356
Account name: ICT\TFSSERVICE
Detailed Message: The pending configuration changes were not successfully added to the cube because of the following error: Microsoft.AnalysisServices.OperationException: The following system error occurred: No mapping between account names and security IDs was done. .
at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String dataReaderAccount, Boolean dropDB)
at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.EnsureCubeIsUpToDate()
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
We are using the 180 Day Demo version. This report error only started a few days ago after I updated the "bug" work Item and added my own "Implementation" work item.
To the Bug work Item I added these fields: Remaining Work (hours), Completed WOrk (hours), Start Date, Finish Date.
I just copy/pasted these fields from the Task Work Item. Everything works fine, except the reports.