TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Errors in the metadata manager+SSAS error
Venkatesan Jayakantham
May 03, 2012
11.5
k
0
0
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
Errors in the metadata manager+SSAS error
Here is one of the SSAS error you will face,
Error 12 An error occurred while parsing the 'StorageMode' element at line 1, column 8368 ('http://schemas.microsoft.com/analysisservices/2003/engine' namespace) under Load/ObjectDefinition/Dimension/StorageMode. 0 0
Error 13 Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.SQLSERVER2008R2V\OLAP\Data\OLAP2.0.db\Fact Reseller Sales.5.dim.xml'. 0 0
Solution:
The issue is due to change in the dimensional data holds some conflicts on the existing measures data.
In this case,
1. Go to the specified location and delete this file... reprocess the dimensions and deploy the cube.
2. Delete the dimension and recreate the dimension. Add it to the cube.
3. Final option, delete the Analysis database and try to process and deploy the cube into the server.
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech, Chennai.
http://www.kaashivinfotech.com/
Errors in the metadata manager+SSAS error
Next Recommended Reading
A network-related or instance-specific error occurred while establishing a connection to SQL Server.