hi,
i`m using report designer to create reports on my self-created work-items. but i did not find all fields and types in the selection in the report designer.
i create a new report project. connect to the ms sql server 2005 analysis service. use the following conneciton properties:
server-name: atvie-tfs01
database-name: TFSWarehouse
i tested the connection and the connection is ok.
in the query builder i choose the "team system" cube.
and then i get the first problem. i added work item - System.WorkItemType to a filter with "Add to filter".
in the filter i want to choose in the filter expression one of my newly created work-items. one is called ReleaseItem. but it is not available in the drop-down! but i imported already this work-item to the tfs and i already created a project which uses this work-item. so i have expected that it would be in the data-cube.
furthermore i have updated the data-cube with the controller service web-service:
http://localhost:8080/Warehouse/v1.0/WarehouseController.asmx
another problem is i did not find all fields that i have defined in my work-items. for example i did not find the following type:
<FIELD name="Typ" refname="pweb.pm.typ" type="String" reportable="dimension">
<REQUIRED/>
<ALLOWEDVALUES>
<GLOBALLIST name="ReqTypeListe" />
</ALLOWEDVALUES>
</FIELD>
i hope you understand what i mean and can help me!
| | thomaskremmel | and furthermore i looked into the sql server management studio. browsed there the data-cube Team System and searched for some data. and i don`t find there data about a project which i created yesterday. it is called test1-pweb. no specific work-items show up. for example i created new work-items called ReleaseItem, Run or ChangeRequest. But they are not shown up in the drop-down of Work Item.Work Item Type. but i see "old" work-items that i have created. for example Runv01. But not the newly created Work-Item "Run".
so what can i do?
and if i run the "related work-items" report, the report doesnt show any results. but the warehouse is up to date and i related work-items with the links section.
furthermore when i view the related work items report there is a drop down labeled with "Work Item Type". In this drop-down i can`t choose the work-items of my project. but the import of the process template works fine and i`m able to create work-items and save them.
queries work without problem. so the problem is the data is not transfered to the cube. but what can be the problem if the process template with the work-items is uploaded successfully and creating work-items is no problem!???
some hints? we want to use tfs in a first productive test-cycle. but without reports it is not a good idea!
| | thomaskremmel | Hi Thomas
It looks like you've tried a bunch of things already. Let's first see if the work item field that you have created has made it to the warehouse.
1) My understanding is that you modified the process template to create a work item type called "Run" (this is analogous to "Bug" or "Task" that TFS ships with). In "Run" you have a work item field called "Typ" . Then you created a team project that uses this work item type. And you created "Run" work items. Is my understanding correct?
2) It sounds like if my undesrtanding in (1) is correct, then if the warehouse has processed and picked up your changes, then your work items should be showing up in the cube. Please check the event log on the Application Tier to see if there are any warnings/errors from the source TfsWarehouse.
3) On the application tier, process the warehouse. Navigate to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx and choose "Run". Click "Invoke".
4) When processing is finished, check the event log again. You can check if processing is finished by navigating to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx and choosing "GetWarehouseStatus". Click "Invoke". It should return "Idle" when it's done.
5) if there are no warnings/errors, then using Sql Server Management Studio, browse the relational warehouse to see if this item is there: [TfsWarehouse].[dbo].[Work Item].[pweb.pm.typ] <- this is your new work item field
Browse the cube to see if these items are there:
[Team System].[Work Item].Work Item.Typ
[Team System].[Related Work Item].Work Item.Typ
Please let me know how that goes.
Mauli | | Mauli Shah - MSFT | hi mauli,
your assumptions are almost correct. i created a process template with 5 new work-items. and i created a project based on the new process template.
i executed the steps 3 +4 and checked the application error logs. and there i found a lot of errors :-) error d) happened before executing steps 3+4
so i hope you can help me. i don`t know what i can do!
a) warning
source tfs warehouse
event id : 3018
type: warning
description:
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): 03.08.2006 07:46:04
Machine: ATVIE-TFS01
Application Domain: /LM/W3SVC/3/Root/Warehouse-2-127990632093433744
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 4068
Thread Id: 1856
Account name: ATVIE-TFS01\Administrator
Detailed Message: Processing OLAP failed
Exception Message: Thread was being aborted. (type ThreadAbortException)
b) error
source tfs warehouse
event id : 3000
type: error
description:
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): 03.08.2006 07:46:05
Machine: ATVIE-TFS01
Application Domain: /LM/W3SVC/3/Root/Warehouse-2-127990632093433744
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 4068
Thread Id: 1856
Account name: ATVIE-TFS01\Administrator
Detailed Message: Cube processing runtime error: \r\nSystem.InvalidOperationException: The Server object is not connected.
at Microsoft.AnalysisServices.Server.RollbackTransaction()
at Microsoft.TeamFoundation.Warehouse.OlapCreator.ProcessOlap(Boolean schemaUpdated, UpdateStatusStore updateStatus)
at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.RunCubeProcess()
For more information, see Help and Support Center at
c) warning
source tfs warehouse
event id : 3000
type: warning
description:
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): 03.08.2006 07:45:40
Machine: ATVIE-TFS01
Application Domain: /LM/W3SVC/3/Root/Warehouse-2-127990632093433744
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 4068
Thread Id: 4060
Account name: ATVIE-TFS01\Administrator
Detailed Message: Microsoft.TeamFoundation.WorkItemTracking.Adapter: Schema changes have been detected but cannot be processed at this time. To prevent data loss, the adapter will cancel this run and only add data once the schema changes have been processed at the start of the next run.
For more information, see Help and Support Center at
d)
error
source TFS Services
event id : 3031
type: error
description:
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): 03.08.2006 07:20:13
Machine: ATVIE-TFS01
Application Domain: /LM/W3SVC/3/Root/services-1-127990631528721728
Assembly: Microsoft.TeamFoundation.Server, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 4068
Thread Id: 3084
Account name: ATVIE-TFS01\TFSSERVICE
Detailed Message: Unrecognized default notification 'From' address:
For more information, see Help and Support Center at
e) source: sql browser
eventid = 9
type = warning
description:
The SQLBrowser service was unable to establish Analysis Services discovery.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
f) warning
source SQL Browser
event id : 3
type: warning
description:
The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
g) error
source TFS Warehouse
event id : 3000
type: warning
description:
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): 02.08.2006 11:56:21
Machine: ATVIE-TFS01
Application Domain: /LM/W3SVC/3/Root/Warehouse-4-127989910240198960
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 2424
Thread Id: 4508
Account name: ATVIE-TFS01\TFSSERVICE
Detailed Message: Microsoft.TeamFoundation.WorkItemTracking.Adapter: Schema changes have been detected but cannot be processed at this time. To prevent data loss, the adapter will cancel this run and only add data once the schema changes have been processed at the start of the next run.
For more information, see Help and Support Center at
h)
error
source TFS Warehouse
event id : 3000
type: warning
description:
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): 02.08.2006 11:53:32
Machine: ATVIE-TFS01
Application Domain: /LM/W3SVC/3/Root/Warehouse-4-127989910240198960
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 2424
Thread Id: 1336
Account name: ATVIE-TFS01\TFSSERVICE
Detailed Message: Microsoft.TeamFoundation.WorkItemTracking.Adapter: Schema changes have been detected but cannot be processed at this time. To prevent data loss, the adapter will cancel this run and only add data once the schema changes have been processed at the start of the next run.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
i)
error
source TFS Services
event id : 3031
type: warning
description:
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): 02.08.2006 11:05:28
Machine: ATVIE-TFS01
Application Domain: /LM/W3SVC/3/Root/services-1-127989902931088976
Assembly: Microsoft.TeamFoundation.Server, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 2424
Thread Id: 5176
Account name: ATVIE-TFS01\TFSSERVICE
Detailed Message: Unrecognized default notification 'From' address:
For more information, see Help and Support Center at
j) error
source TFS Warehouse
event id : 3000
type: warning
description:
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): 02.08.2006 09:09:09
Machine: ATVIE-TFS01
Application Domain: /LM/W3SVC/3/Root/Warehouse-4-127989828999881120
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 492
Thread Id: 3912
Account name: ATVIE-TFS01\TFSSERVICE
Detailed Message: Cube processing runtime error: \r\nSystem.InvalidOperationException: The Server object is not connected.
at Microsoft.AnalysisServices.Server.RollbackTransaction()
at Microsoft.TeamFoundation.Warehouse.OlapCreator.ProcessOlap(Boolean schemaUpdated, UpdateStatusStore updateStatus)
at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.RunCubeProcess()
For more information, see Help and Support Center at
k) error
source TFS Warehouse
event id : 3018
type: warning
description:
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): 02.08.2006 09:09:08
Machine: ATVIE-TFS01
Application Domain: /LM/W3SVC/3/Root/Warehouse-4-127989828999881120
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 492
Thread Id: 3912
Account name: ATVIE-TFS01\TFSSERVICE
Detailed Message: Processing OLAP failed
Exception Message: Thread was being aborted. (type ThreadAbortException)
Exception Stack Trace: at System.Net.UnsafeNclNativeMethods.OSSOCK.recv(IntPtr socketHandle, Byte* pinnedBuffer, Int32 len, SocketFlags socketFlags)
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags, SocketError& errorCode)
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.TcpStream.GetDataType()
at Microsoft.AnalysisServices.CompressedReaderStream.GetDataType()
at Microsoft.AnalysisServices.XmlaClient.EndRequest()
at Microsoft.AnalysisServices.XmlaClient.SendExecuteAndReadResponse(Boolean skipResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Execute(String command)
at Microsoft.AnalysisServices.Server.Execute(String command)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.ProcessOlap(Boolean schemaUpdated, UpdateStatusStore updateStatus)
For more information, see Help and Support Center at
| | thomaskremmel | i dont know if it is the root of all evil ;-) but i know that i have to change the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS. the warning explained above tells me that they are not correct.
the settings in the sql server configuration manager are like the following:
-shared memory: enabled
- named pipes: enabled
- tcp/ ip : enabled
- via: disabled
i tried to change these settings but it doesn`t help and i do get the warning message in the logs.
| | thomaskremmel | i don`t want to do it now. but is it possible to re-install sql-server 2005 without re-installing tfs? ok data will loss, but that s no problem. i do have just test-data.
| | thomaskremmel | just wondering where can i get this report designer?
A little less sixteen candles, a little more "touch me" | | Kardi | http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=21600&SiteID=1
you have to install work-station components of the sql server 2005. then you can call report designer in visual studio with creating a new 'business intelligence project" project
| | thomaskremmel | ok now it seems that most is working fine.
i reinstalled everything , and i think the problem was that i didn`t installed the hotfixes for service pack1 of sql server 2005!
| | thomaskremmel | Glad to hear you resolved your issue - sorry we were not of more help.
Would you please mark this as resolved? | | Nick Ericson - MSFT | you mean "mark as answer" ? that i have done now.
| | thomaskremmel |
|
index > Team Foundation Server - Reporting > report designer don`t find all fields