Tuesday, February 14, 2012

corrupted file error

I think one of my file got corrupted when I tried to clean up my dsv and dimension since I got the following message when try to open the cube:

Errors in the metadata manager. An error occurred when loading the
DimProduct dimension, from the file, '\\?\E:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\Financial.0.db\DimProduct.4.dim.xml'.
Errors in the metadata manager. An error occurred when loading the
RevenueAnalysis cube, from the file, '\\?\E:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\AW.0.db\AW\View.26.cub.xml'.

What is the easy way to fix this, I have the back up copy or xmla script, but it won't allow me to run it. I can not even delete the AS database since I am thinking about restore from my backup

Thanks

Don

MS tech support claims this normally goes away after a full process of the database but I haven't found this to be true.

I had to shut down the SSAS service, delete all files within the data directory of the particular database with the problem, start back up the service, then delete the database via SSMS. After this I just re-deployed from our source control and did a full process.

Hasn't happened since our SP2 upgrade (fingers crossed).

Hope this helps.

No comments:

Post a Comment