RTM TFS installed on combined AT/DT. reporting was working fine till a week ago, after that, i can still see the report, but there is no data.

e.g. for "remaining work" report, even though we still have the same number of tasks, but the work item count (active/resolved/closed) are all showing 0.

Report Generated: 8/23/2006 5:24:48 PM by xxxxx ; Last Warehouse Update: 8/14/2006 2:59:30 PM it seems the warehouse update has not happened since 8/14, event viewer doesn't reveal any obvious problem. how to kick start the warehouse update?

To process your warehouse on your ATDT browse to:

http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx

and invoke Run.

Go back and invoke GetWarehouseStatus - it should return to Idle in a little bit (depends on the size of your warehouse).

Check your eventvwr on this machine for errors.

The reports are cached when first viewed for an hour. You can disable the cache by (same machine):

http://localhost/Reports
Select directory with your project name
Select the report
Select properties
Select Execution (on left menu)
Select "Do not cache temporary copies of this report" -> Apply

that solved the problem, actually i had run similar command before and it didn't help. so why did the warehouse automatic update stopped?

again, event viewer doesn't show any error. all TFS* events looks ok.

It is hard to say why Warehouse updating stopped. Do you see any events from Source: TFS Warehouse in your eventvwr? Any errors from Reporting Services?

Another place to look for information is in the Trace information output by the adapters. This will not help diagnose the previous issue - but if you see this again it may help.

To enable tracing until the adapters are restarted (i.e. by iisreset) browse to:
http://localhost:8080/Warehouse/v1.0/tftrace.aspx?All=Verbose

View the trace info using a tool such as Dbgview.

TFSServerScheduler is indeed stopped due to logon failure. i had just updated the passwd and had it start. will see if this is the root of the problem.

btw, should TFSServerScheduler log such failure? i don't see any in event viewer.

You should see an error under System in the eventvwr when a service fails to start.

Source: Service Control Mananager

TFSServerScheduler doesn't start so it cannot throw an error.