index > Team Foundation Server - Reporting > Another warehouse not updating :( - now FIXED :)

Another warehouse not updating :( - now FIXED :)

Hi folks,

i've noticed our warehouse reports are updating/working.

eg.

Remining Work

Report Generated: 6/06/2006 4:16:54 PM by Domain\User; Last Warehouse Update: 21/05/2006 5:41:04 AM.

I can use http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx in IE and it works (well, it says TRUE and pretty soon after that it (refresh IE) says FALSE).

There's no errors in the EVENT LOG anymore. The TFSServiceScheduler was off, so i had to double check the logon user (Domain\TFSService \ password) apply, and run (works). Suddenty i recieved a lot of alerts from our discussion board :P

Code analysis works (i hit run - 2 entries are logged. blah blah Start. Blah blah stop). That account logs on as Domain\TFSSetup \ password).

Finally, Sharepoint Timer Service is working. I changed that to Domain\TFSService and event log got filled with errors. Changing it to LogOn:Local system account fixed that (no more errors).

I've also tried to remove the 30 mins cache on the report mentioned above, but still the warehouse is not updated. :(

I've been added in tasks and bugs for the last few weeks before AND after the last warehouse update.

I've also rebooted the server a few times and no error messages in the event log.

Please help?! Do i need SQL sp1?

-Pure Krome-

Pure Krome

hi,

we do recommend that you upgrade to sql sp1 as it contains a number of bug fixes and performance improvements.

please check out rob caron's blog entry on upgrading: http://blogs.msdn.com/robcaron/archive/2006/05/04/590076.aspx

please also check out the warehouse troubleshooting guide: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=154526&SiteID=1

mauli

Mauli Shah - MSFT

Heya folks,

i've finally had a chance to download and apply the sql sp1 to the server. Download was 200+ MB and the service pack installed perfectly fine. I did a reboot and ... warehouse still not updating :(

I can manually update it via the webservice no probs. I kept coming back all day and checked to see if the warehouse updated - and it still hadn't.

All of my automatic services have started. The TFSServiceScheduler service has started. I've also made sure that's LogOn As <domain>\TFSService account which i'm pretty damn sure i used during the main install of TFS.

what are the services that i need to have running as 'LogOn As'? maybe that's stopping the scheduler?

is there any way to get some logging information for the scheduler?

-Pure Krome-

Pure Krome

Hi Pure,

You mention that the scheduler is not running.

Can you see if you can process the warehouse manually? The scheduler kicks off a call to this web service when it processes the warehouse.

Log on to your application tier
Navigate to: http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx?op=Run
Hit Invoke.

Please also go through the Warehouse Troubleshooting guide:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=154526&SiteID=1

The scheduler writes out to this file whenever it runs, so you can see if it has data in it:

D:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\TFSServerScheduler\ScheduledServices.xml

mauli

Mauli Shah - MSFT

Hi Mauli.

yep, i've been using that to manually get the reports updated. Secondly, i've also read that post before i posted here, which actually taught me how to use the Management Program to run all cube and the show me how to do it via the webservice (your link above). The xml file output doesn't give much info -> it's always saying when the service was last run - not when the warehouse was last updated (including manually by myself).

what services need to be using 'LogOn As' and what should they be running as (with respect to the demo usernames used in the install documentation)? maybe that's an issue.

What about the event log? lets have a look here. I'll reboot .. then check. ok .. ooooOO!! now this is interesting

event log errors (in order of date logged)

1) Starting up database 'TfsActivityLogging'.
2) Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.8.190]
3) #50070: Unable to connect to the database STS_Config_TFS on (computer name == App tier). Check the database connection information and make sure that the database server is running.

How do i fix this?! Thanks heaps in advance to any help.

-Pure Krome-

Pure Krome

Hi Pure,

From reading this thread I can see that at this point you don't have a problem on manually running the adapters form the web page and that your problem is having the scheduler do it for you.

I'm not familiar with the demo users you mention that you used to setup but the TFSServerScheduler service should be running under the same user that is running the web services. In order to find the user that is running the web services, open IIS manager and find the "Tfs AppPool" application pool, right click on it and look at the identity tab.

Then in order for us to try if this works quickly this is what you can do:

- Navigate to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx.

- Select the ChangeSetting method

- In settingID type this: RunIntervalSeconds

- In value type this: 60

- Click invoke.

With these steps what we are doing is telling the scheduler service that it should run the adapters every 60 seconds. The default value is 3600 seconds (one hour). You should change this back to 3600 after you are done.

- Now restart the scheduler. In ~60 seconds (and every ~60 seconds) the scheduler should call the adatpers and you should be able to verify that new data was added. In order to check the status of the adapters you can use the GetWarehouseStatus method in the web page. The different values are: Idle, Running Adapters, Processing Olap.

Also if you are having problems with the accounts in the system like the error you are getting on TfsActivityLogging account you may want to take a look at the documentation of the TfsAdminUtil.exe utility that can be used to change accounts in the system, update passwords, etc. I'm not very familiar with that tool but if after reading the docs for it you need help let me know and I'll find somebody here that can help.

I hope this helps.

Federico

Federico Kolliker Frers - MSFT

Thanks Federico - that solved my problem.

Pure Krome

I am having a similar error, but that does not seem to resolve my issue.

#50070: Unable to connect to the database STS_Config_TFS on Servername. Check the database connection information and make sure that the database server is running.

For more information, see Help and Support Center at . I ran a status on that account and did not see anything that stood out as an issue. I have also confirmed that the account has rights into the database. In addition when I try to connect to the defaultpage that page does not load I get

The page cannot be displayed
ntschultz
Hello, you say you are having a similar error but the error you provide mentions STS_Config_TFS database and that is the Sharepoint database. If you are having problems opening the Sharepoint project portal site please try to post to the (Team Foundation Server - Process Templates)http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=482&SiteID=1 forum and maybe they can help.

If you are having problems opening individual reports can you please provide the error you are seeing and also if you think the Warehouse is not being updated can you look at the Application Tier even log and see if you have any event log errors coming from "TFS Warehouse".

Thanks.

Federico
Federico Kolliker Frers - MSFT
I have a similar problem. In my case:

1. I have TFS RTM, SQL Server 2005 SP1.
2. Warehouse is not updating (select Setting as [Last Cube Processing] from _WarehouseConfig where ID = 'LastProcessedTime') returns 31 march 2006.
3. WarehouseController.Run returns false, GetWarehouseStatus returns Idle.
4. No events were recorded in Application event log. (the only error is from WorkItemTracking, that also needs to be investigated)
5. TFSServerScheduler is started
6. I enabled debugging information by changing (<add name="General" value="0" />, from "0" to "4".) DebugView didn't report any exceptions.
7. I rebuilt the Warehouse database as it was suggested in thread, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=317697&SiteID=1 , but it doesn't help.

What should I do next?
Sergei Almazov
Hi Sergei,

Does Warehouse.Run always return false? Could you capture the trace using Dbgview.exe; do an iis reset and then invoke the webservice again. The Warehouse controller should initialize and the adapters should be loaded, once you invoke the webservice they should start running. If any of these steps do not run as expected, you should be able to capture it in the trace.

Thanks,
Othmane
Othmane Rahmouni-MSFT
Warehouse.Run always returns false. I reset the iis, run the ControllerService, it returns false every time. it looks like all adapters are initialized properly, but still nothing happens. Here is a part of DbgView trace, the only question is about "Retrying failed notifications" row:

00000180 17.23594093 [2800] [DW] [Info, PID 2800, TID 688, 06:32:31.795] Created the adapter: Microsoft.TeamFoundation.Warehouse.CommonStructureAdapter
00000181 17.96008873 [2800] [DW] [Info, PID 2800, TID 688, 06:32:32.420] Initializing Adapter Microsoft.TeamFoundation.Warehouse.CommonStructureAdapter.
00000182 18.95553398 [2800] [DW] [Info, PID 2800, TID 688, 06:32:33.514] Adapter Microsoft.TeamFoundation.Warehouse.CommonStructureAdapter has initialized successfully.
00000183 18.95677757 [2800] [DW] [Info, PID 2800, TID 688, 06:32:33.514] Created the adapter: Microsoft.TeamFoundation.Build.Adapter.TeamBuildAdapter
00000184 19.55900002 [2800] [CS] [Info, PID 2800, TID 3680, 06:32:34.014] Retrying failed notifications.
00000185 19.71482086 [2800] [DW] [Info, PID 2800, TID 688, 06:32:34.030] Initializing Adapter Microsoft.TeamFoundation.Build.Adapter.TeamBuildAdapter.
00000186 19.71561050 [2800] [DW] [Info, PID 2800, TID 688, 06:32:34.139] Microsoft.TeamFoundation.Build.Adapter: Initializing Team Build Adapter.
00000187 19.72050285 [2800] [DW] [Info, PID 2800, TID 688, 06:32:34.280] Adapter Microsoft.TeamFoundation.Build.Adapter.TeamBuildAdapter has initialized successfully.
00000188 19.72108841 [2800] [DW] [Info, PID 2800, TID 688, 06:32:34.280] Created the adapter: Microsoft.TeamFoundation.VersionControl.Adapter.VCAdapter
00000189 20.30252266 [2800] [DW] [Info, PID 2800, TID 688, 06:32:34.780] Initializing Adapter Microsoft.TeamFoundation.VersionControl.Adapter.VCAdapter.
00000190 20.30314445 [2800] [DW] [Info, PID 2800, TID 688, 06:32:34.874] Microsoft.TeamFoundation.VersionControl.Adapter: Using source control at http://xvndkhdev006:8080/
00000191 20.46509933 [2800] [DW] [Info, PID 2800, TID 688, 06:32:34.874] Adapter Microsoft.TeamFoundation.VersionControl.Adapter.VCAdapter has initialized successfully.
00000192 20.59001350 [2800] [DW] [Info, PID 2800, TID 688, 06:32:34.874] Created the adapter: Microsoft.TeamFoundation.WorkItemTracking.Adapter.Adapter
00000193 20.99538994 [2800] [DW] [Info, PID 2800, TID 688, 06:32:35.545] Initializing Adapter Microsoft.TeamFoundation.WorkItemTracking.Adapter.Adapter.
00000194 21.01197624 [2800] [DW] [Info, PID 2800, TID 688, 06:32:35.561] Microsoft.TeamFoundation.WorkItemTracking.Adapter: Initialize called
00000195 21.08109665 [2800] [DW] [Info, PID 2800, TID 688, 06:32:35.608] Adapter Microsoft.TeamFoundation.WorkItemTracking.Adapter.Adapter has initialized successfully.
00000196 21.08152390 [2800] [DW] [Info, PID 2800, TID 688, 06:32:35.639] Created the adapter: Microsoft.VisualStudio.TestTools.WarehouseAdapter.Adapter
00000197 21.62959290 [2800] [DW] [Info, PID 2800, TID 688, 06:32:36.139] Initializing Adapter Microsoft.VisualStudio.TestTools.WarehouseAdapter.Adapter.
00000198 21.62979126 [2800] [DW] [Info, PID 2800, TID 688, 06:32:36.186] Adapter Microsoft.VisualStudio.TestTools.WarehouseAdapter.Adapter has initialized successfully.
00000199 21.62998390 [2800] [DW] [Info, PID 2800, TID 688, 06:32:36.186] Finishing the initialization for AdapterScheduler.
00000200 21.63571739 [2800] [DW] [Info, PID 2800, TID 688, 06:32:36.186] Warehouse controller initialization complete.
00000201 21.65516090 [2800] [DW] [Info, PID 2800, TID 688, 06:32:36.202] Warehouse controller application started.
00000202 21.68636322 [2800] [DW] [Verbose, PID 2800, TID 688, 06:32:36.217] Request authentication type: NTLM
00000203 21.68686104 [2800] [DW] [Verbose, PID 2800, TID 4012, 06:32:36.248] Request authentication type: NTLM
00000204 22.78649902 [2800] [CS] [Verbose, PID 2800, TID 3680, 06:32:37.139] Request authentication type: NTLM
00000205 23.21400261 [2800] [CS] [Verbose, PID 2800, TID 3680, 06:32:37.717] Request authentication type: NTLM
00000206 23.21405220 [2800] [CS] [Verbose, PID 2800, TID 3680, 06:32:37.764] Request authentication type: NTLM
00000207 23.88063049 [2800] [CS] [Verbose, PID 2800, TID 688, 06:32:38.436] Request authentication type: NTLM
00000208 23.94738388 [2800] [DW] [Verbose, PID 2800, TID 688, 06:32:38.498] Request authentication type: NTLM
00000209 23.95996857 [2800] [CS] [Verbose, PID 2800, TID 4012, 06:32:38.514] Request authentication type: NTLM
00000210 83.96189117 [2800] [DW] [Verbose, PID 2800, TID 4012, 06:33:38.528] Request authentication type: NTLM
00000211 84.39128113 [2800] [CS] [Verbose, PID 2800, TID 688, 06:33:38.950] Request authentication type: NTLM
00000212 84.44451904 [2800] [CS] [Verbose, PID 2800, TID 688, 06:33:39.013] Request authentication type: NTLM
00000213 84.50203705 [2800] [DW] [Verbose, PID 2800, TID 688, 06:33:39.060] Request authentication type: NTLM
00000214 84.53821564 [2800] [CS] [Verbose, PID 2800, TID 4012, 06:33:39.106] Request authentication type: NTLM
00000215 123.65616608 [696] ReportingServicesService!library!d!04.10.2006-09:34:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
Sergei Almazov
So... is there any chance to fix it???
Sergei Almazov