Create OLAP Failed – XML parsing failed at line 1, column 0: A document must contain exactly one root element. I’ve visit one of my customers and saw a strange error in the event log: Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\TfsWarehouse.0.db\Today.886.dim.xml'. Detailed Message: Create OLAP failed Exception Message: XML parsing failed at line 1, column 0: A document must...
Cannot open database "TfsWarehouse" requested by the login I Installed TFS 2008 on Server 2008 with SQL 2008, everything during the installation went fine except the reports. When I tried to process the cube using SSMS I got the following error: Detailed Message: Cube processing runtime error: \r\nMicrosoft.AnalysisServices.OperationException: Internal error: The operation terminated unsuccessfully.Internal error: The operation terminated unsuccessfully.OLE DB error: OLE DB or ODBC error...
Working With TFS Data Manager In the post I talked about Disaster Recovery for VSTS 2008 and now I will show how to work with TFS Data Manager. Every one can download the trial version and check for your self Download Page After downloading (9.5mb) the install is very simple. Choose the backup location, make sure you have al least 800mb , basiclly it’s like SQL backup. Select your Team System database and proper User & Password After the installation you can open TFS Data Manager, Perform Backup...