Technical: Microsoft – SQL Server – Analysis Services – Deployment – Error – Error Message – An error occurred while parsing the ‘StorageMode’ element at line 1, column 3346 (‘http://schemas.microsoft.com/analysisservices/2003/engine’ namespace) under Load/ObjectDefinition/Dimension/StorageMode.

Technical: Microsoft – SQL Server – Analysis Services – Deployment – Error – Error Message – An error occurred while parsing the ‘StorageMode’ element at line 1, column 3346 (‘http://schemas.microsoft.com/analysisservices/2003/engine’ namespace) under Load/ObjectDefinition/Dimension/StorageMode

Background

While deploying a Microsoft SQL Server Analysis Project ran into the error message pasted below:


Error	3	Internal error: Invalid enumeration value. Please call customer 
support! is not a valid value for this element.		0	0	 


Error	4	An error occurred while parsing the 'StorageMode' element at line 1, column 3346 ('http://schemas.microsoft.com/analysisservices/2003/engine' namespace) under Load/ObjectDefinition/Dimension/StorageMode. 

Error Image:

AnErrorOccurredWhileParsingTheStorageModel

Error Diagnosis

The problem seems to be due to a problem with the currently deployed Analysis Server database. 

Fix

There are a couple of fixes that work:

  • Deploy to a new database
  • Remove the old database

Deploy to a new database

As the problem is isolated to the current database on the server, you can choose to deploy to a new database

  • From the main menu, select the “Project” and properties option
  • Within the Configuration Properties panel, navigate to the “Deployment” option
  • In the right panel, select a new destination database

ProjectPropertiesNewDatabase

Remove old database

Again, since the problem is with the AS Server’s current database, let us back and remove the current one.

  • Launch SQL Server Management Studio
  • In “Object Explorer”, select “Connect to Analysis Services …”
  • From the list of databases, please select the database
  • Right click on the selected database, and choose to “Backup..” option
  • In the Backup, select a location on the Analysis Server
  • Right click on the selected database, and from the drop-down menu, choose the Delete option

Connect To Analysis Services

ConnectToAnalysisServices

Backup Database

As the problem is isolated to the current database on the server, you can choose to deploy to a new database

BackupUpDatabase

Delete Objects

DeleteObject

References

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s