Trying to run

Trying to run

• SanjeevUpd

  here's a relevant link
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=139746&SiteID=1
  
  

• Hazel

  I did delete a project and re-add it with the same name.
  
  Is there a workaround for this
  
  Thanks,
  
  
  

• Adi.Condor

  You might have two issues - the first is your cube is not processing.  Is your locale of the server not english (we had a bug in beta 3):
  
  If it's that, go to the web.config (path mentioned in guide) and look for the section to add application settings - they look like
  <add key="..." value="..."/>
  
  and add
  <add key="ProcessingType" value="Full"/>
  
  Then, manually kick the warehouse (step 3 in the guide) and see if you get that error in the event log.
  
  If that's it, we had a datetime local issue when we generate incremental cube processing instructions and forcing full works around it.  It's fixed in RTM.   I should add that to the troubleshooting guide.
  
  The other option is to go into enterprise manage, select analysis services in the drop down in upper left, expand down to the TfsWarehouse, right click, process and initiate a full process manually.
  
  That should get your cube up to date and the processing time should be updated.
  
  Let us know if you see the iterations after that.  We have another bug where if you delete and project and then recreate it by the same name, we have issues. 
  
  let me know (bryanmac)
  

• Richard_T

  My last cube processing time was Nov 28 (four days ago), although everything else looked upto date. I've run through the document and the reports still don't work. This is in the Event Log
  
  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/12/2005 07:50:16
  Machine: VSTSSERVER
  Application Domain: /LM/W3SVC/3/Root/Warehouse-1-127779828979113355
  Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
  Process Details:
    Process Name: w3wp
    Process Id: 3276
    Thread Id: 428
    Account name: VSTS\TFSSetup
  
  Detailed Message: Cube processing runtime error: \r\nMicrosoft.TeamFoundation.Warehouse.WarehouseException: OLE DB error: OLE DB or ODBC error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.; 22007.
     at Microsoft.TeamFoundation.Warehouse.OlapCreator.ProcessOlap(Boolean schemaUpdated, UpdateStatusStore updateStatus)
     at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.RunCubeProcess()
  
  and thinking about it I've seen this error many times in the log over the last few days
  
  
  

• Yanbiao Zhao - MSFT

  I've been deleteing and re-adding projects all the time (this is a test environment)
  
  
  

• PeterM

  We are trying to come up with a workaround sql script - essentially the project dimension table should have two entries by that name but the older one needs to go or be renamed and then the cube should be fully processed.
  
  I'll update this link with the sql to fix this when we have it.  We're getting the DBs from one customer who has hit this and I will post what we do:
  
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=156444&SiteID=1
  
  

• Youtham

  BTW - did you ever delete a project

  
  

• Jack Stone

  It would be interesting to see if that data made it into the warehouse.  Do the other reports work
  
  Here's a link to see the state of the warehouse:
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=154526&SiteID=1 
  
  

• Firas Saltaji

  BTW
  
  I seem to have fixed the problem with the date by setting adding <add key="ProcessingType" value="Full" /> to eweb.config.
  
  It seems I can run any report that doesn't require an iteration or an area
  
  
  

• YongLi

  Duh - I replied to a stale page so I didn't see you already did the full processing workaround. 
  
  For the area/iteration, please confirm if you deleted a project and then readded it by the same name - we logged this bug today.  Looks like you have two issues - looks like your doing a good job of testing :)
  
• Trying to run