Analysis Services session failed:Cannot overwrite an Olap database

[Sushant]

Hello –

We are using Project Server 2007.We have been trying to figure out what may
be wrong , but not could find resolution, any help would be highly
appreciated!!

===== Initiating cube build process =====
[8/31/2007 8:36 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[8/31/2007 8:37 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[8/31/2007 8:37 PM] Cube build initialization started
[8/31/2007 8:37 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[8/31/2007 8:37 PM] Cube build session started
[8/31/2007 8:37 PM] Analysis Services session started
[8/31/2007 8:37 PM] Analysis Services session failed with the following
error: Cannot overwrite an Olap database created outside of Project Server or
by another Project Server Site.
===== Process Completed =====
[8/31/2007 8:37 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Cannot overwrite an Olap database
created outside of Project Server or by another Project Server Site.

 

[Ben Howard]

Either
1. Try deleting the cube before building a new one
or
2. specify a new name for the cube and then build it.

Do either of these work?

 

[Marc Soester [MVP]]

Hi Sushant,

please bare in mind that if you use a new name, you will need to make sure
that all current Data Analysis views need to be changed to the new database
name.

--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com

Either
1. Try deleting the cube before building a new one
or
2. specify a new name for the cube and then build it.

Do either of these work?
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Hello –

We are using Project Server 2007.We have been trying to figure out what may
be wrong , but not could find resolution, any help would be highly
appreciated!!

===== Initiating cube build process =====
[8/31/2007 8:36 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[8/31/2007 8:37 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[8/31/2007 8:37 PM] Cube build initialization started
[8/31/2007 8:37 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[8/31/2007 8:37 PM] Cube build session started
[8/31/2007 8:37 PM] Analysis Services session started
[8/31/2007 8:37 PM] Analysis Services session failed with the following
error: Cannot overwrite an Olap database created outside of Project Server or
by another Project Server Site.
===== Process Completed =====
[8/31/2007 8:37 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Cannot overwrite an Olap database
created outside of Project Server or by another Project Server Site.

 

[Sushant]

thanks Marc and Ben for your response.

I tried following
First Deleted the OLAP DB, then tried to create with the same name from
the UI(Server Settings ->Build Settings), it failed, then renamed and OLAP DB
and built cube again, this time the cube started building but it fails
sometimes (no pattern identified). Also the DataAnalysis views stopped
building and the name if the OLAP DB does not appear in the Server
Settings-->ManageViews-->Newview-->Viewtype=DataAnalysis-->Analysis Services
Database to be created = ??? there is no DB listed there.

What should I do get the OLAP DB Name in the drop down list so that my Data
Analysis views start working?


I didn't this response earlier hence posted another question, then thought
makes sense to continue this thread.
--
Regards,
Sushant

Hi Sushant,

please bare in mind that if you use a new name, you will need to make sure
that all current Data Analysis views need to be changed to the new database
name.

--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com

Either
1. Try deleting the cube before building a new one
or
2. specify a new name for the cube and then build it.

Do either of these work?
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Hello –

We are using Project Server 2007.We have been trying to figure out what may
be wrong , but not could find resolution, any help would be highly
appreciated!!

===== Initiating cube build process =====
[8/31/2007 8:36 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[8/31/2007 8:37 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[8/31/2007 8:37 PM] Cube build initialization started
[8/31/2007 8:37 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[8/31/2007 8:37 PM] Cube build session started
[8/31/2007 8:37 PM] Analysis Services session started
[8/31/2007 8:37 PM] Analysis Services session failed with the following
error: Cannot overwrite an Olap database created outside of Project Server or
by another Project Server Site.
===== Process Completed =====
[8/31/2007 8:37 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Cannot overwrite an Olap database
created outside of Project Server or by another Project Server Site.