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: Thursday, July 24, 2014 4:11 AM
Points: 853, Visits: 787
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: Monday, October 20, 2014 1:39 PM
Points: 3,126, Visits: 792
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: Tuesday, October 28, 2014 9:59 AM
Points: 2,126, Visits: 1,474
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: Thursday, July 24, 2014 4:11 AM
Points: 853, Visits: 787
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