Analysis Services error

I was able to build SQL 2005 cubes from my project. However, for some reasons, it doesn't work any more, and I have the error below. Anyone can shed some light would be greatly appreciated.

Error 1 File system error: The logical file cannot be found inside the physical file. Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Tbl Policy Coverage Data.6.dim\14.ERP Effective Month.Tbl Policy Coverage Data.dstore. Logical file: . Errors in the metadata manager. An error occurred when loading the Coverage dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Tbl Policy Coverage Data.16.dim.xml'. Errors in the metadata manager. An error occurred when loading the Production cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Beacon DW.350.cub.xml'. 0 0

Hi,

It sounds like the file is corrupted. It looks like its only the Coverage dimension, so you may be lucky.

Can the project be built or is the error when you try to deploy the project to the server?

If the error is in the deployment try to deploy to a new database to see if the corruption is on the server itself.

If the error is on the build which tells me something is corrupted in the project files itself do the following.

1. Go to a back up of the project if you have one.

2. If not make a backup of the project now and delete the Coverage dimension from the project to see if you can build it without that dimension.

I hope that helps,

David Botzenhart

|||

It appears that it is one of the xml files for the Coverage dimension was corrupted on the SQL server. I have deleted the Coverage dimension on my project, and it failed with the same error when I rebuilt the cube. Do you know of how to fix the corrupted file on the SQL server?

Mitch Cheung