Cube file corrupted, cant restore backup

• Ian C0ckcroft

  Hall of Fame

  Points: 3373

  More actions

  July 18, 2014 at 10:26 am

  #397081

  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

• Thomas LeBlanc

  SSCrazy Eights

  Points: 8085

  More actions

  July 19, 2014 at 6:02 am

  #1730822

  I would re-deploy the cube from Visual Studio With Full Deploy and Process All Data.

  Thomas

  Thomas LeBlanc, MVP Data Platform Consultant

• Lempster

  SSCoach

  Points: 15651

  More actions

  July 24, 2014 at 4:09 am

  #1732049

  Did that solution work for you? If not, there are some extra steps you may need to do which are covered in this[/url] link.

• Ian C0ckcroft

  Hall of Fame

  Points: 3373

  More actions

  July 24, 2014 at 4:13 am

  #1732052

  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