report designer don`t find all fields
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!
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
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
