Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Data Mining

Can't Run any DM Until Delete Lost Cube?

I (unsuccessfully) made a cube named, MSR TRANCHES. I can't find any trace of it anymore. However, I can't make a new Mining Structure because VS complains of:

Error 1 File system error: Error opening file;\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the MSR TRANCHES ~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml'. 0 0

I can't find any cube anywhere, nor do I find this missing file. How does Visual Studio know to look and how do I clear this up.

Thank you very much,

[825 byte] By [AndrewAPlus] at [2008-2-6]
«« External Tools
»» How do I draw a shape on an existing image?
# 1

I obtain the same error when I try to develop a mining structure. Anybody know the solution?

Thanks in advance.

PaTaKi at 2007-9-8 > top of Msdn Tech,SQL Server,Data Mining...
# 2
The error you're seeing indicates that the database is corrupt (internal files associated with certain system objects are missing). If you don't have any other database/objects you need to save on the server, the workaround would be to shut down the AS2005 service (SQL Server Analysis Service (<instancename>)), delete the "\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Data" folder and restart the service.
RamanIyer at 2007-9-8 > top of Msdn Tech,SQL Server,Data Mining...
SQL Server
Data Mining

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified