Hi David, Have a look at this MSDN article: Troubleshooting the Data Warehouse. http://msdn.microsoft.com/en-us/library/ms244674.aspx
During your restore based move, did you rebuild the Team System Cube? http://msdn.microsoft.com/en-us/library/cc668753.aspx Grant -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of FEILEN,David Sent: Monday, October 27, 2008 9:25 PM To: [email protected] Subject: RE: [OzTFS] RE: TFS Warehouse Issues There is nothing in the event logs that indicate any issue to do with the issue at all. There is nothing in the trace output that suggests any particular adapter is failing either. It looks like the last good results were produced on the day before our upgrade from TFS 2005 to TFS 2008. The upgrade was a restore based move followed by an upgrade to 2008. Cheers, David Feilen ES - Release and Technical Support Team Employment Systems Group Department of Education, Employment and Workplace Relations http://www.deewr.gov.au Ph. 6121 8393 Ext. 68393 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Wes MacDonald > Sent: Tuesday, October 28, 2008 12:24 PM > To: [email protected] > Subject: [OzTFS] RE: TFS Warehouse Issues > > Hi, > > Anything in the event logs that is of any use to help > diagnose the problem, also when was the last time the > warehouse produced good results and what has changed if > anything since then? SQL updates? OS updates? > > Wes > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of FEILEN,David > Sent: Monday, October 27, 2008 8:47 PM > To: [email protected] > Subject: [OzTFS] TFS Warehouse Issues > > I have an issue with an out of date TFS Warehouse, I can't get it to > update at all. > > The TFSWarehouse SQL database is empty and there is nothing related to > the > warehouse in the event logs on either the application or data tiers. > > I have tried forcing a warehouse update by invoking 'Run' on the > warehouse > controller. 'Run' returns true and warehouse status briefly changes to > 'Processing > OLAP' before returning to 'Idle'. It returns 'Idle' after one or two > seconds. > > http://localhost:8080/Warehouse/v1.0/WarehouseController.asmx > > I have also rebuilt both the TFS Warehouse database and the OLAP cube > using > SetupWarehouse.exe and it is still not getting updated. > > According to the values in the _WarehouseConfig table of the > TFSWarehouse > database, the update has never run. > > ConfigChangeTimeStamp 2008-10-24T00:08:28.980 > CubeChangeTimeStamp 2008-10-24T00:10:24.517 > LastDataPumpEndedTimeStamp 0001-01-01T00:00:00.000 > LastFullProcessTimeStamp 0001-01-01T00:00:00.000 > LastIncrementalProcessTimeStamp 0001-01-01T00:00:00.000 > > The most puzzling thing is that there is no indication of an error > anywhere. Has > anyone got any ideas about this? > > David Feilen > ES - Release and Technical Support Team > Employment Systems Group > Department of Education, Employment and Workplace Relations > http://www.deewr.gov.au > Ph. 6121 8393 > Ext. 68393 > > Notice: > The information contained in this email message and any attached files > may be confidential information, and may also be the subject of legal > professional privilege. If you are not the intended recipient any use, > disclosure or copying of this email is unauthorised. If you received > this email in error, please notify the DEEWR Service Desk and > delete all > copies of this transmission together with any attachments. > > > > OzTFS.com - to unsubscribe from this list, send a message > back to the list with 'unsubscribe' as the subject. View the > web archives at http://www.mail-archive.com/[email protected]/ > Powered by mailenable.com, supported by www.readify.net > > > > > OzTFS.com - to unsubscribe from this list, send a message > back to the list with 'unsubscribe' as the subject. View the > web archives at http://www.mail-archive.com/[email protected]/ > Powered by mailenable.com, supported by www.readify.net > > > Notice: The information contained in this email message and any attached files may be confidential information, and may also be the subject of legal professional privilege. If you are not the intended recipient any use, disclosure or copying of this email is unauthorised. If you received this email in error, please notify the DEEWR Service Desk and delete all copies of this transmission together with any attachments. OzTFS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. View the web archives at http://www.mail-archive.com/[email protected]/ Powered by mailenable.com, supported by www.readify.net OzTFS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. View the web archives at http://www.mail-archive.com/[email protected]/ Powered by mailenable.com, supported by www.readify.net
