Project Server OLAP Database - Corrupted Files

L

luai7

Today I started getting a strange error whenever I access anything within the
Project Server OLAP database.

Questions:
1. The actual Project Server databases (non OLAP) are working fine. Can I
generate or recover the OLAP database from the non-OLAP databases (Note: I
don't have a backup for the OLAP database but only for the non-OLAP
databases) ?
2. Is there any fix for this issue?


The error is as follows:

File system error: The following file is corrupted: Physical file:
\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\ProjectServer.0.db\Task Is Milestone.o.dim\1.TaskUID
1.Task.1dstore.Logical file.
Errors in metadata manager. An error occurred when loading the Task Is
Milestone dimension, from the file, "\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\ProjectServer.0.db\Task Is Milestone.1.dim.xml".
Errors in the metadata manager. An error occurred when loading the
Assignment Non Timephased cube, from the file, "\\?\C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\ProjectServer.o.db\Assignemenet
Non Timephased.1.cub.xml", (Microsoft.AnalysisServices)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLAP Error 0
OLAP Cube build failure – What is the meaning of the queue job err 9
Elusive cube error 1
Project Server 2007 SP2: Gantt with data in OLAP but not in Published or Draft Databases 0
PS2007. Cube Build Failure. Failed to connect to the Analysis Serv 2
OLAP Cube 8
OLAP Cube -- Build failed 1
Error 3240034310 1

Top