Another TFS Warehouse problem...

hello,

our tfs warehouse cube has not been updated long time , affects of course our reports. when in event log @ tfs server can see many errors 'tfs warehouse' , 'mssqlserverolapservice'. list event details below , hopefulle here can me it. way - using latest version of tfs single server installation.

thanks thomas
------------------------------------------------------------------------------
event type: error
event source: tfs warehouse
event category: none
event id: 3000
date:  2006-08-15
time:  12:11:13
user:  n/a
computer: cmmpltapp
description:
tf53010: unexpected condition has occurred in team foundation component. information contained here should made available site administrative staff.
technical information (for administrative staff):
date (utc): 2006-08-15 10:11:13
machine: cmmpltapp
application domain: /lm/w3svc/3/root/warehouse-1-128000922376692872
assembly: microsoft.teamfoundation.warehouse, version=8.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a; v2.0.50727
process details:
  process name: w3wp
  process id: 6112
  thread id: 2100
  account name: cmmplt\tfsservice

detailed message: pending configuration changes not added cube because of following error: microsoft.analysisservices.operationexception: xml parsing failed @ line 36, column 1424: unexpected end of input.
.
errors in metadata manager. error occurred when instantiating metadata object file, '\\?\c:\program files\microsoft sql server\mssql.2\olap\data\tfswarehouse.0.db\today.628.dim.xml'.
errors in metadata manager. error occurred when instantiating metadata object file, '\\?\c:\program files\microsoft sql server\mssql.2\olap\data\tfswarehouse.0.db\today.628.dim.xml'.

   @ microsoft.analysisservices.analysisservicesclient.sendexecuteandreadresponse(impactdetailcollection impacts, boolean expectemptyresults, boolean throwiferror)
   @ microsoft.analysisservices.analysisservicesclient.alter(imajorobject obj, objectexpansion expansion, impactdetailcollection impact, boolean allowcreate)
   @ microsoft.analysisservices.server.update(imajorobject obj, updateoptions options, updatemode mode, xmlawarningcollection warnings, impactdetailcollection impactresult)
   @ microsoft.analysisservices.server.sendupdate(imajorobject obj, updateoptions options, updatemode mode, xmlawarningcollection warnings, impactdetailcollection impactresult)
   @ microsoft.analysisservices.majorobject.update(updateoptions options, updatemode mode, xmlawarningcollection warnings)
   @ microsoft.analysisservices.majorobject.update(updateoptions options)
   @ microsoft.teamfoundation.warehouse.olapcreator.createolap(warehouseconfig whconf, string accessuser, string datareaderaccount, boolean dropdb)
   @ microsoft.teamfoundation.warehouse.adapterscheduler.ensurecubeisuptodate()

for more information, see , support center @ http://go.microsoft.com/fwlink/events.asp.
------------------------------------------------------------------------------
event type: error
event source: mssqlserverolapservice
event category: (289)
event id: 18
date:  2006-08-15
time:  12:11:13
user:  n/a
computer: cmmpltapp
description:
errors in metadata manager. error occurred when instantiating metadata object file, '\\?\c:\program files\microsoft sql server\mssql.2\olap\data\tfswarehouse.0.db\today.628.dim.xml'.

for more information, see , support center @ http://go.microsoft.com/fwlink/events.asp.
------------------------------------------------------------------------------------

hello mauli,
just restarting analysis service , run warehousecontroller webservice didn't solve problem. opened "c:\program files\microsoft sql server\mssql.2\olap\data\tfswarehouse.0.db\today.628.dim.xml'" , noticed xml file invalid - how can happen mystery. i took similair xml file on tfs installation server , manually replaced invalid fields - restarted analysis server , , running.

thanks!
thomas

Archived Forums V  >  Team Foundation Server - Reporting & Warehouse