Failed to build the OLAP cubes

[Santosh]

Hi All,

I am seeing this error when I am trying Data Analysis.

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to create the Project Non Timephased cube. Error:
Unable to save object. The object has been modified by another application.

Please help me.........
Why I am getting this error?

 

[Marc Soester [MVP]]

Santosh,

has the cube worked before?
if so what has changed
do you also get event log errors? if so what are their
and last but not least, what version of Analysis Services are you running on?
thanks

 

[Santosh]

Hi Marc,

Yes the cube worked before, we have just restored cube before it failed.

The error which we got in event log is

Standard InformationSI Entry Point:
Project User: ENTERPRISE\epmadmin01
Correlation Id: d4ddbe54-664a-4546-9324-b010746dabd2
PWA Site URL: http://project.enterprisenet.org/PWA
SSP Name: SharedServices1
PSError: CBSOlapDatabaseSetupFailure (17007)
Project Server failed to generate an OLAP object.
CBS queued message: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9
ASServerName=nawinclssql002 ASDBName=Project1
ASExtraNetAddress=http://nawinclssql002/olap/msmdpump.dll
RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0
FromDate=03/10/2009 17:08:59 ToDate=03/10/2009 17:08:59 HighPriority=False.
Error: Analysis Services session failed with the following error:
Failed to create the Project Non Timephased cube. Error: Unable to save
object.
The object has been modified by another application.

Project Server analysis cube building --7690 event ID
Project server cube 7704.

We are using Sql server 2005 and project server 2007

Hope so this information will help you.