Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Can't start Analysis Services on cluster after restoring system databases


Can't start Analysis Services on cluster after restoring system databases

Author
Message
matt.gyton
matt.gyton
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 295
Hi all,

Last night we had a suspected network issue which caused all connections to several of our SQL servers to drop out and resulted in one cluster having a corruption of it's master database. I rebuilt and restored the master from the latest backup using SQLCMD, then also restored the latest backups of MSDB and model.

The SQL Server and SQL Agent Services are now running fine, but the SQL Analysis services are refusing to start and I'm getting no useful messages in the error log.

Can anyone think of anything else I need to do? This is on SQL 2008 R2...

Thanks,

Matt
Rudyx - the Doctor
Rudyx - the Doctor
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3290 Visits: 2476
Have you checked the Windows evnet logs ? Specifically the System and Application ?

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Shaun Finnegan
Shaun Finnegan
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 471
Check the OLAP log to see if there is any info. You can find the location of the log on the advanced tab of the SSAS server in SQL Config manager

SQL Server Best Practices Supporter
matt.gyton
matt.gyton
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 295
I've found a couple of interesting entries in the OLAP log....

(30/09/2013 13:13:20) Message: Failed to initialize SQLSQM timer. One of the following can be the source of the problem: registry doesn't contain all necessary information, server instance name can not be retrieved correctly, failure during timer creation, etc. (Source: \\?\L:\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC121001B)
(9/30/2013 1:13:20 PM) Message: The file '\\?\D:\OLAP\Data\CryptKey.bin' could not be opened. Please check the file for permissions or see if other applications locked it. (Source: \\?\L:\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210023)

(10/8/2013 7:33:10 PM) Message: The file '\\?\D:\OLAP\Data\master.vmp' could not be opened. Please check the file for permissions or see if other applications locked it. (Source: \\?\L:\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210023)
(10/8/2013 7:33:10 PM) Message: The service cannot be started: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. File system error: The following error occurred while opening the file '\\?\D:\OLAP\Data\master.vmp'. (Source: \\?\L:\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210000)
matt.gyton
matt.gyton
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 295
On further investigation I've noticed that the master.vmp file is empty - it must have been wiped or corrupted when the service cut out. Do you know if there is a way to potentially recover this situation other than to reinstall SSAS? Unfortunately I know very little about SSAS....
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search