Error in the Metadata Manager

I'm attempting to deploy a new solution on AS 2005 developer edition. Apparently, a previous, unrelated solution deployment has a problem, and this prevents me from deploying mine. I've cleaned up the data directory, tried all sorts of options, but still I get the same thing. Here's the error:

Error 1 XML parsing failed at line 2, 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, '\\?\E:\SQL 2005\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\cluster Population By Zip ~MC.0.cub\~CaseDetail ~MG.0.det.xml'. Errors in the metadata manager. The dimension with ID of 'Population By Zip', Name of 'Population By Zip' referenced by the 'cluster Population By Zip ~MC' cube, does not exist. Errors in the metadata manager. An error occurred when loading the cluster Population By Zip ~MC cube, from the file, '\\?\E:\SQL 2005\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\cluster Population By Zip ~MC.0.cub.xml'.

any ideas?

thanks, Chris

Chris,

Did you ever get to the bottom of this? I'm having a similar problem.

-Jamie

|||

OK, fixed it thanks to this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=125660&SiteID=1

Error in the Metadata Manager

I'm attempting to deploy a new solution on AS 2005 developer edition. Apparently, a previous, unrelated solution deployment has a problem, and this prevents me from deploying mine. I've cleaned up the data directory, tried all sorts of options, but still I get the same thing. Here's the error:

Error 1 XML parsing failed at line 2, 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, '\\?\E:\SQL 2005\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\cluster Population By Zip ~MC.0.cub\~CaseDetail ~MG.0.det.xml'. Errors in the metadata manager. The dimension with ID of 'Population By Zip', Name of 'Population By Zip' referenced by the 'cluster Population By Zip ~MC' cube, does not exist. Errors in the metadata manager. An error occurred when loading the cluster Population By Zip ~MC cube, from the file, '\\?\E:\SQL 2005\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\cluster Population By Zip ~MC.0.cub.xml'.

any ideas?

thanks, Chris

Chris,

Did you ever get to the bottom of this? I'm having a similar problem.

-Jamie

|||

OK, fixed it thanks to this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=125660&SiteID=1

Error in Metadata manager with Many-to-Many relationship

Hello,

For a while I've been trying, unsuccessfully, to get a many-to-many relationship to work. With so much help from this NG, I'm finally very close (I think).

But now, I am getting the following error when I deploy my cube... "Errors in the metadata manager." The 'Time' many-to-many dimension in the 'AwardBridge' measure group requires that the granularity of the 'AwardDimension' dimension is lower than that of the 'Facts' measure group."

While I get what the error is telling me, I don't know where to look for the granularity issue. It is unclear to me why this occurs when I think I have everything at the same granularity level.

Any help is greatly appreciated.

Thank you.

-Gumbatman

Crack open the Dimension Usage tab and take a look at the relationship between the directly-related dimensions and the bridge and 'Facts' measure groups. You can confirm the level in the dimension at which the relationships are formed.

B.

Error in Metadata manager with Many-to-Many relationship

Hello,

For a while I've been trying, unsuccessfully, to get a many-to-many relationship to work. With so much help from this NG, I'm finally very close (I think).

But now, I am getting the following error when I deploy my cube... "Errors in the metadata manager." The 'Time' many-to-many dimension in the 'AwardBridge' measure group requires that the granularity of the 'AwardDimension' dimension is lower than that of the 'Facts' measure group."

While I get what the error is telling me, I don't know where to look for the granularity issue. It is unclear to me why this occurs when I think I have everything at the same granularity level.

Any help is greatly appreciated.

Thank you.

-Gumbatman

Crack open the Dimension Usage tab and take a look at the relationship between the directly-related dimensions and the bridge and 'Facts' measure groups. You can confirm the level in the dimension at which the relationships are formed.

B.

Error in Metadata manager when trying to open calculations

Having an issue when I try to open the calculations tab in BIDS against an OLAP database or a MSAS project. BIDS hangs for a second than comes back with an "unexpected errror" in the middle of the screen and then shuts down. If I check the event viewer I get

Errors in the metadata manager. The configuration property updates were not persisted. Internal error: An unexpected exception occured

I can access every other tab in the project, just not the calculations tab.

Anyone run into this before?

Thanks

FJK,

I think I read some time ago that you could get this message if you have different msolap90.dll installed on your PC in different folders. Could you search for this dll on your PC and if different version found, try to replace dll to match.

Vidas Matelis

Error in metadata manager processing sample database/cubes

I've just installed SQL Server 2005 with Analysis Services and the sample AdventureWorks databases. When I try to process the database via SQL Server Management Studio, I get the following error - see below. I did check the xml file referenced by the name of the error and I do see the dimension listed Order Date key but not any attribute called Name of Date. Is there any workaround to enable processing of the database and cubes?

I did bump up to Sp1 and this did not fix my problem. I also tried installing the samples from the downloads section of microsoft.com. Alas, no success.

Any help appreciated,

Mairead

Errors in the metadata manager. The dimension with ID of 'Order Date Key - Dim Time', Name of 'Date' referenced by the 'Adventure Works' cube, does not exist.
Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Adventure Works DW.2.cub.xml'.
(Microsoft.AnalysisServices)

Program Location:

at Microsoft.AnalysisServices.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.SendRefresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.MajorObject.Refresh()
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at Microsoft.AnalysisServices.Server.Connect(String connectionString)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc, IServiceProvider site)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDataContainer(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

Here is simple way out of your situation

1. Stop Analysis Service.
2. Delete everything in your D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db folder.
3. Start the service
4. Re-deploy your sample project.

Hope that helps

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward, I finally did get everything working again by completely uninstalling/reinstalling and redeploying the samples again. I did try your workaround but still could not get the samples processed successfully.

Mairead