Create OLAP Failed – XML parsing failed at line 1, column 0: A document must contain exactly one root element.
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 contain exactly one root element.
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'.
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'.
(type OperationException)
I tried to process the the cube using SQL Management Studio and everything end just fine.
Solution:
First thing is to try setting OLAP for full processing instead of incremental processing following those actions:
1. Open Web.config in C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Web Services\Warehouse folder.
2. Add the following “<add key=”ProcessingType” value=”Full” />” under <appSettings>.
Please also run the following commands in the AT to rebuild the warehouse relational and OLAP databases:
1. Rebuild relational database
SetupWarehouse -s <DT Server Name> -d TFSWarehouse -c warehouseschema.xml -a <Service Account> -ra <Reporting Account> -mturl <TFS URL> -rebuild -edt TfsBuild
2. Rebuild OLAP database
SetupWarehouse -o -s <DT Server Name> -d TFSWarehouse -c warehouseschema.xml -a <Service Account> -ra <Reporting Account> -mturl <TFS URL>
Hope this helped.