Friday, November 14, 2008

Visual Studio TFS Data Warehouse isn't refreshing, EventID 3000

Environment
==========
Microsoft Visual Studio Team System 2008 Team Foundation Server
MS Windows Server 2003 Standard SP2 32 Bit

Issue
==========
TFS Data Warehouse isn't refreshing, EventID 3000

Details:
==========
Every hour data is pulled to refresh the data warehouse. It picks up the EVENT ID 3000
Event ID: 3000 Event Source: TFS Warehouse Exception Message: XML parsing failed at line 1, column 0: A document must contain exactly one root element. Stopped on Saturday. Drive Space issue was corrected but still not working. Saturday we ran out of disk space.

Troubleshooting
=============
Rebuild TFS Relational Data Warehouse ; SetupWarehouse

Detailed Actions:
=======
• Step 1
To rebuild the warehouse, log in with a local admin account or domain admin account
 
1) Log into SQL management studio and delete the TfsWareshouse from both the database engine and analysis services
2) Switch to a command prompt and run the following:
 
C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe /setup /install -n -s "dataserver" -d "TFSWarehouse" -c "C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\warehouseschema.xml" -ra "domain\tfsreports" -a "domain\tfsservice" -v –l
 
Then we will need to run the warehouse

• Step 2
Find Username
http://localhost/reports ; SQL Server Reporting Services ; TFS Support
Credentials stored = Username = JDNET\tfsservice

• Step 3 Rebuild TFS Warehouse and OLAP

• Step 4 in IIS Manager
IIS Manager ; Team Foundation Server ; Warehouse ; v1.0 ; warehousecontroller.asmx
Right Click ; Run ControllerService ; Press Invoke button ; Run
Received WarehouseStatus = Idle

smlns="http://schemas.microsoft.com/TeamFoundation/2005/06/Services/Controller/03">Idle
Still received EventID: 3000
The hierarchy '[System_Id]' was nout found in the cube when the string, [Work Item].[System_Id], was parsed.

• Step 5
Copy TfsVersionControl ; Extended Properties ; TFS_INSTANCE Value
and pasted to Database Properties TFSWharehouse and added TFS_INSTANCE Value
Once again Run ControllerService was run and received status of Idle
===
• Step 6 Consult with other engineer and examined Work Item (dbo.Work Item) through MS Visual Studio Code
This time Rebuild only OLAP instead of rebuilding TFSWharehouse and OLAP

• Step 7 GetWarehouseStatus - this time changed: Status = RunningAdapters
smlns="http://schemas.microsoft.com/TeamFoundation/2005/06/Services/Controller/03">RunningAdapaters

6 comments:

Anonymous said...

Wow Bucky..you are a life saver...I mean I was sweating and working on the way to solve the matter for about...well let's just say a LOT of time...I mean I tried a lot of so called solutions for fixing TFS Data Warehouse refreshing ---but your solution is the only one that actually worked..so again..thanks a lot!

Bucky said...

Your very welcome! Thanks for the comments! :-)
- Bucky

Anonymous said...

Thanks Bucky
Also had the same problem and this sorted it.

cheers

Amir said...

Do you how long the process of "RunningAdapaters" should take??? Mine's been stuck there for about 45 minutes now, and I'm wondering is something is wrong.

Thanks

Anonymous said...

Hi,

I'm facing an issue regarding data pulling from TFS work item tracking database to TFS Warehouse database.

I have tried re-building the Warehouse and OLAP databases manually through SetupWarehouse.exe and I have tried manually invoking the warehouseController.asmx's run method. But still I don't see any data in warehouse database except in a table (team project).

I have investigated the event log and the stack logs by enabling the tracing. But still I could not pinpoint the reason why no data is being pulled from TFS work item tracking database into Warehouse.

I had created one new work item type.

Initially I also changed the column schema of WorkItemsAre, WorkItemsLatest and WorkItemsWere tables to make the nvarChar(256) columns to nVarChar(max). I thought that could be the reason of the error, I reverted back the tables to their original schema, but still facing the same error.

When the asmx is running, The event viewer log does not show any error. It shows only a warning: "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"

I have tried installing all service packs and hotfixes of Sql Server 2005. Still no luck.

I are using Visual Studio Team Foundation Server 2008 SP1 and SQL Server 2005 SP4.

Any help will be much appreciated.

albina N muro said...

Already registered? Click here. Once you register, you will receive an email from us that includes your username and password. l4d survival warehouse