Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> Visual Studio Team System >> Team Foundation Server - Reporting & Warehouse

Bug Rates Report - Getting very weird report

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"

[917 byte] By [rternier] at [2008-3-6]

«« Building a Windows Form using .NET Managed C++ in VS 2003
»» Issue with threading

# 1

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

MauliShah-MSFT at 2007-9-10 >

top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...

# 2

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).

rternier at 2007-9-10 >

# 3

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 TfsIntegration
select 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.

rternier at 2007-9-10 >

# 4

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 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

My LastUPdatedTime needed 2 "_" infront... strange but ok. The Date/Time returned was the same +/- 4 seconds. (2006-05-24 11:05:09.313)

rternier at 2007-9-10 >

# 5

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:

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.

NickEricson at 2007-9-10 >

# 6

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

AlanHebert-MSFT at 2007-9-10 >

# 7

It is working correctly now, I guess I should've mentioned :D

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

rternier at 2007-9-10 >

# 8

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

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:

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: