Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cube file corrupted, cant restore backup Expand / Collapse
Author
Message
Posted Friday, July 18, 2014 10:26 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, November 24, 2014 5:15 AM
Points: 856, Visits: 804
Hi guys, i am getting an error which looks like the cube file is corrupt.


TITLE: Microsoft SQL Server Management Studio
ADDITIONAL INFORMATION:

File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\TseboCube.0.db\Account Budget Import.0.dim\8190.(All).kstore. Logical file .
Errors in the metadata manager. An error occurred when loading the Account Budget Import dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\TseboCube.0.db\Account Budget Import.8190.dim.xml'.
Errors in the metadata manager. An error occurred when loading the Budget Forecast cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\TseboCube.0.db\Budget Forecast.16294.cub.xml'.
(Microsoft.AnalysisServices)

when I try to delete it snd restore from a back up, i get same error.
Any idea how i can remove it and restore from back up?
thanks guys


Ian Cockcroft
MCITP BI Specialist
Post #1594146
Posted Saturday, July 19, 2014 6:02 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:16 AM
Points: 3,176, Visits: 797
I would re-deploy the cube from Visual Studio With Full Deploy and Process All Data.

Thomas


Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1594306
Posted Thursday, July 24, 2014 4:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 19, 2014 9:48 AM
Points: 2,128, Visits: 1,488
Did that solution work for you? If not, there are some extra steps you may need to do which are covered in this link.
Post #1595839
Posted Thursday, July 24, 2014 4:13 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, November 24, 2014 5:15 AM
Points: 856, Visits: 804
Hi guys, thanks for the replies.
I switched of the service. deleted the cub file and redeployed. worked.
cheers
Ian


Ian Cockcroft
MCITP BI Specialist
Post #1595842
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse