Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
savior faire
Posting Yak Master
194 Posts |
 Posted - 2010-04-18 : 12:16:52
|
| Wondering if anyone can give me some help.I have SQL Server 2008-Developer's Edition on my laptop and have installed the sample databases. I am running a Vista Home 32 bit system.I do not use my laptop much, yesterday I booted it up to review some exercises in a book I recently purchased and I tried to deploy a project and received an error.From the error text it seems like the Time Dimension is corrupted. I have two other SSAS databases on the server, projects I have been working with, and they do not appear in the SSMS tree view. I cannot do anything in SSMS, detach, bring up properties, browse Adventure Works, etc.Here is the cut/paste of the error I get in SSMS if I right click the database and select an option:TITLE: Microsoft SQL Server Management Studio------------------------------Cannot show requested dialog.------------------------------ADDITIONAL INFORMATION:File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Adventure Works DW 2008 SE.1.db\Dim Time.0.dim\1.Fiscal Year.bstore. Logical file .Errors in the metadata manager. An error occurred when loading the Date dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Adventure Works DW 2008 SE.1.db\Dim Time.1.dim.xml'.Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Adventure Works DW 2008 SE.1.db\Adventure Works DW.1.cub.xml'.(Microsoft.AnalysisServices)------------------------------BUTTONS: OK------------------------------______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-04-19 : 20:04:29
|
| I seem to have solved my problem.I navigated to the folder under "data" in the analysis services folder.I cut/pasted "AdventureWorks DW SE" analysis services database and moved it to a "temp" folder I had.I restarted Analysis Services, connected to AS in SSMS and everything was fine.Opened BIDS, and loaded a project I was working on, and it was fine.______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
|
|
|
|
|
Corrupt AdventureWorks Cube