Problem

 When trying to process a database cube the following error is received:

 Internal error: An unexpected exception occured.

 

After the restart of the SSAS service the event view shows the following error:

The file '\\?\X:\...\Data\master.vmp' could not be deleted. Please check the file for permissions.

 

Solution

Note that even if the SSAS Service is up and running when trying to execute some operation, even if they complete successfully, no modification are actually done. For example after restoring a cube database from a backup, although the operation completes successfully, the new database doesn?t appear in the Management Studio list.

The ?master.vmp could not be deleted? error message can appear sometimes if you just moved the SSAS databases from one location to another on the same server.

In this situation the solution is to grant rights "Modify" on this new data folder to the service account used to start the SSAS service. More information about this scenario you can find in this article: http://blogs.technet.com/b/mdegre/archive/2012/10/03/moving-ssas-database-to-a-new-drive-on-same-server.aspx

If previous suggestion didn?t solved the issue you can try to find out if there is another process that is locking the master.vmp file. To do this you can use the Process Explorer tool, which can be found here: http://www.microsoftnow.com/2008/10/unlocking-files-that-are-in-use.html

 

...

To find out if this is the case, stop the SSAS service and use the Process Explorer tool to discover if the file is locked or not.

In my situation it turns out that the NetBackup utility was locking the master.vmp file (you can see more details in the below screenshots).

  

 

 

After ulocking the master.vmp (right click -> Close Handle) the SSAS service starts without the ?master.vmp could not be deleted? error and the cube processing operation completes successfully.

 You can find more information about the master.vmp file in the this article: http://blogs.msdn.com/b/sqlserverfaq/archive/2009/07/08/tampering-master-vmp-file-may-result-in-losing-all-analysis-services-databases.aspx

 

 


2 comments

Comment from: sql server masters [Visitor]
sql server mastersFantastic article ! You havemade some very astute statements and I appreciate the the effort you have put into your writing. Its clear that you know what you are writing about. I am excited to read more of your sites content.

http://www.sqlservermasters.com/
06/04/13 @ 10:20
Comment from: admin [Member] Email
Thanks for the appreciation :)
06/04/13 @ 11:38

This post has 1 feedback awaiting moderation...

Leave a comment


Your email address will not be revealed on this site.
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)