Welcome to MSDN Blogs Sign in | Join | Help

Brian Smith's Project Support WebLog

What's new and upcoming in the world of Microsoft Office Project Support (PSS).
Common Error Messages when Building Cubes with Project Server 2007

I am reproducing some common errors, both from the USL logs and the Application Event logs to assist with troubleshooting cube building issues.  These are in a sort of order that follows my previous article - so first I will give a description of the problem and the errors you will see.  Note that the same Application Event log can appear for multiple failure modes (1 to 3 listed below all have the same error in the application event log) - but the ULS logs tend to be more indicative of the real problem.  Another common error I have not listed and potentially the first you will see is “ActiveX component can't create object” which is usually related to missing components detailed in KB921116.

So here are the 5 errors:-

1. SSPAdmin is not an admin in Analysis Services

ULS Logs

·         Microsoft.Office.Project.Server

·         0x0924

·         Project Server                

·         Project Server Analysis Cube Bu

·         8swn

·         Medium  

·         PWA:http://<server>/PWA, SSP:SharedServices1, User:DOMAIN\User, PSI:   [CBS] ProjectServerOlapCubeGenerator status: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <SERVER>. Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

Application Event Log

·         Event Type:        Error

·         Event Source:    Office SharePoint Server

·         Event Category:                Project Server Analysis Cube Building

·         Event ID:                              7682

·         Date:                     2/7/2007

·         Time:                     11:01:09 AM

·         User:                     N/A

·         Computer:          <SERVER>

·         Description:

·         Standard Information:PSI Entry Point:

·         Project User: DOMAIN\User

·         Correlation Id: 69521947-e064-4bff-88e9-2176674a766f

·         PWA Site URL: http://<server>/PWA

·         SSP Name: SharedServices1

·         PSError: CBSASConnectionFailure (17003)

·         Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=<SERVER> ASDBName=PSCube ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=02/07/2007 11:00:39 ToDate=02/07/2007 11:00:39 HighPriority=TrueFor more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

2.            If you don’t restart the Analysis Server service after adding the SSPAdmin as an admin then you may see:-

ULS Logs

·         Microsoft.Office.Project.Server

·         0x0EAC

·         Project Server

·         Project Server Analysis Cube Bu

·         8swn

·         Medium  

·         PWA:http://<server>/PWA, SSP:SharedServices1, User:DOMAIN\User, PSI:   [CBS] ProjectServerOlapCubeGenerator status: ProjectServerOlapCubeGenerator failed with exception: Microsoft.Office.Project.PI.CBSCommon.CBSProcessException: Failed to connect to the Analysis Services server <SERVER>. Error: Your permissions on the server computer do not allow you to administer this Analysis server.      Error:  ---> System.Runtime.InteropServices.COMException (0x80040026): Your permissions on the server computer do not allow you to administer this Analysis server.      Error:      at Interop.Dso.ServerClass.Connect(String ServerName)     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.ConnectToAnalysisServer()     --- End of inner exception stack trace ---     at ProjectServerO...lapCubeGenerator.OlapDatabaseBuilder.ConnectToAnalysisServer()     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.GenerateOlapDatabase()     at ProjectServerOlapCubeGenerator.CMain.Main(String[] args)

Application Event Log

·         Event Type:        Error

·         Event Source:    Office SharePoint Server

·         Event Category:                Project Server Analysis Cube Building

·         Event ID:              7682

·         Date:                     2/7/2007

·         Time:                     2:32:56 PM

·         User:                     N/A

·         Computer:          <SERVER>

·         Description:

·         Standard Information:PSI Entry Point:

·         Project User: DOMAIN\User

·         Correlation Id: 87a08e57-822e-4ec9-9a47-671f14679d6e

·         PWA Site URL: http://<server>/PWA

·         SSP Name: SharedServices1

·         PSError: CBSASConnectionFailure (17003)

·         Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=<SERVER> ASDBName=PSCube ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=02/07/2007 14:32:23 ToDate=02/07/2007 14:32:23 HighPriority=TrueFor more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp

3.            If the SSPAdmin does not have access to the repository for Analysis Services then you will see the following.  This was on a single server – you may see MSOLAPRepository$ rather than the full path.

ULS Logs

·         Microsoft.Office.Project.Server

·         0x0CAC

·         Project Server                

·         Project Server Analysis Cube Bu

·         8swn

·         Medium  

·         PWA:http://<server>/PWA, SSP:SharedServices1, User:DOMAIN\User, PSI:   [CBS] ProjectServerOlapCubeGenerator status: ProjectServerOlapCubeGenerator failed with exception: Microsoft.Office.Project.PI.CBSCommon.CBSProcessException: Failed to connect to the Analysis Services server <SERVER>. Error: Cannot connect to the repository.    Analysis server: <SERVER>    Error:  The Microsoft Jet database engine cannot open the file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\DSO9\msmdrep.mdb'.  It is already opened exclusively by another user, or you need permission to view its data. ---> System.Runtime.InteropServices.COMException (0x80040033): Cannot connect to the repository.    Analysis server: <SERVER>    Error:  The Microsoft Jet database engine cannot open the file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\DSO9\msmdrep.mdb'.  It is already opened exclusively by another user, or you need permission to view its data.     at Interop.Dso.ServerClass.Connect(String ServerName)     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.ConnectToAnalysisServer()     --- End of inner exception stack trace ---     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.ConnectToAnalysisServer()     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.GenerateOlapDatabase()     at ProjectServerOlapCubeGenerator.CMain.Main(String[] args)

Application Event Log

·         Event Type:        Error

·         Event Source:    Office SharePoint Server

·         Event Category:                Project Server Analysis Cube Building

·         Event ID:              7682

·         Date:                     2/7/2007

·         Time:                     2:38:50 PM

·         User:                     N/A

·         Computer:          <SERVER>

·         Description:

·         Standard Information:PSI Entry Point:

·         Project User: DOMAIN\User

·         Correlation Id: 87a08e57-822e-4ec9-9a47-671f14679d6e

·         PWA Site URL: http://<server>/PWA

·         SSP Name: SharedServices1

·         PSError: CBSASConnectionFailure (17003)

·         Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=<SERVER> ASDBName=PSCube ASExtraNetAddress=<SERVER> RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=02/07/2007 14:32:23 ToDate=02/07/2007 14:32:23 HighPriority=TrueFor more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

4.            This is probably going to be a fairly uncommon error.  In my case my repository copied from another server already had a cube referenced and I was trying to use the same cube name on this new server.  The error messages are slightly misleading as they tend to indicate the server name is already in use – rather than the cube name.

ULS Logs

·         Microsoft.Office.Project.Server

·         0x1204

·         Project Server                

·         Project Server Analysis Cube Bu

·         8swn

·         Medium  

·         PWA:http://<server>/PWA, SSP:SharedServices1, User:DOMAIN\User, PSI:   [CBS] ProjectServerOlapCubeGenerator status: ProjectServerOlapCubeGenerator failed with exception: Microsoft.Office.Project.PI.CBSCommon.CBSProcessException: Cannot overwrite an Olap database created outside of Project Server or by another Project Server Site.     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.VerifySiteOwner(Server dsoAnalisysServer, Database oldOlapDatabase, Guid siteUid)     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.GenerateOlapDatabase()     at ProjectServerOlapCubeGenerator.CMain.Main(String[] args)

·         Critical

·         Standard Information:PSI Entry Point:   Project User: DOMAIN\User  Correlation Id: 87a08e57-822e-4ec9-9a47-671f14679d6e  PWA Site URL: http://<server>/PWA  SSP Name: SharedServices1  PSError: CBSAttemptToOverwrite (17013) The Analysis Services server name that has been selected is already being used by another Project site. Select a different name or remove the existing one and try again.

Application Event Log

·         Event Type:        Error

·         Event Source:    Office SharePoint Server

·         Event Category:                Project Server Analysis Cube Building

·         Event ID:                              7685

·         Date:                     2/7/2007

·         Time:                     2:51:09 PM

·         User:                     N/A

·         Computer:          <SERVER>

·         Description:

·         Standard Information:PSI Entry Point:

·         Project User: DOMAIN\User

·         Correlation Id: 87a08e57-822e-4ec9-9a47-671f14679d6e

·         PWA Site URL: http://<server>/PWA

·         SSP Name: SharedServices1

·         PSError: CBSAttemptToOverwrite (17013)

·         The Analysis Services server name that has been selected is already being used by another Project site. Select a different name or remove the existing one and try again.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

5.            This final error occurs if the account running Analysis Services is not a datareader in the reporting database for Project Server.

ULS Logs

·         Microsoft.Office.Project.Server

·         0x0D44

·         Project Server                 

·         Project Server Analysis Cube Bu

·         8swn

·         Medium  

·         PWA:http://<server>/PWA, SSP:SharedServices1, User:DOMAIN\User, PSI:   [CBS] ProjectServerOlapCubeGenerator status: ProjectServerOlapCubeGenerator failed with exception: Microsoft.Office.Project.PI.CBSCommon.CBSProcessException: Failed to process the Analysis Services database PSCubeTest on the <SERVER> server. Error: OLE DB error: OLE DB or ODBC error: Login failed for user '<SERVER>\ASAdmin'.; 42000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'PSCubeTest', Name of 'Booking Type' was being processed.  ---> System.Exception: OLE ...DB error: OLE DB or ODBC error: Login failed for user '<SERVER>\ASAdmin'.; 42000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'PSCubeTest', Name of 'Booking Type' was being processed.      at Interop.Dso._Database.Process(ProcessTypes ProcessOption)     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.ProcessOlapDatabase(Database olapDatabase)     --- End of inner exception stack trace ---     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.ProcessOlapDatabase(Database olapDatabase)     at ProjectServerOlapCubeGenerator.OlapDatabaseBuilder.ProcessOlapDatabase()     at ProjectServerOlapCubeGenerator.CMain.Main(String[] args)

Application Event Log (3 errors)

·         Event Type:        Failure Audit

·         Event Source:    MSSQLSERVER

·         Event Category:                (4)

·         Event ID:              18456

·         Date:                     2/7/2007

·         Time:                     2:57:01 PM

·         User:                     <SERVER>\ASAdmin

·         Computer:          <SERVER>

·         Description:

·         Login failed for user '<SERVER>\ASAdmin'. [CLIENT: 157.59.123.99]For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

 

·         Event Type:        Error

·         Event Source:    MSSQLServerOLAPService

·         Event Category:                (289)

·         Event ID:              3

·         Date:                     2/7/2007

·         Time:                     2:57:01 PM

·         User:                     N/A

·         Computer:          <SERVER>

·         Description:

·         OLE DB error: OLE DB or ODBC error: Login failed for user '<SERVER>\ASAdmin'.; 42000.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

·         Event Type:        Error

·         Event Source:    Office SharePoint Server

·         Event Category:                Project Server Analysis Cube Building

·         Event ID:              7691

·         Date:                     2/7/2007

·         Time:                     2:57:02 PM

·         User:                     N/A

·         Computer:          <SERVER>

·         Description:

·         Standard Information:PSI Entry Point:

·         Project User: DOMAIN\User

·         Correlation Id: 87a08e57-822e-4ec9-9a47-671f14679d6e

·         PWA Site URL: http://<server>/PWA

·         SSP Name: SharedServices1

·         PSError: CBSOlapProcessingFailure (17004)

·         Cube build failed during an OLAP Processing operation. CBS queued message: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=<SERVER> ASDBName=PSCubeTest ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=02/07/2007 14:56:01 ToDate=02/07/2007 14:56:01 HighPriority=True. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database PSCubeTest on the <SERVER> server. Error: OLE DB error: OLE DB or ODBC error: Login failed for user '<SERVER>\ASAdmin'.; 42000.Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'PSCubeTest', Name of 'Booking Type' was being processed.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

Technorati Tags:

 

Posted: Wednesday, February 14, 2007 9:33 PM by BriSmith

Comments

Christophe Fiessinger's Blog said:

Common questions and answers on AS 2K5 permissions for EPM 2007: Getting Cube to Build 1. Which application

# March 1, 2007 12:52 PM

Mike said:

Hi Brian,

The error we're getting is:

"===== Verifying and running pre-build server event handler =====

[5/8/2007 8:40 AM] Verifying and running pre-build server event handler

===== Determining database and cube structure =====

[5/8/2007 8:40 AM] Cube build initialization started

[5/8/2007 8:40 AM] OLAP database and cube structure was determined successfully

===== Building database and cubes =====

[5/8/2007 8:40 AM] Cube build session started

[5/8/2007 8:41 AM] Analysis Services session started

[5/8/2007 8:41 AM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server Hqsql2005dev01. Error: Path not found

===== Process Completed =====

[5/8/2007 8:41 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server Hqsql2005dev01. Error: Path not found

"

AS is set up on the default instance & is using a SQL db.

Any ideas?

# May 8, 2007 11:23 AM

BriSmith said:

Hi Mike,

The error appears to suggest that the path to the repository is not working - so I would check the settings through Management Studio and look at the properties for the repository.

Brian.

# May 18, 2007 10:28 AM

Pavel said:

Hi Brian,

The error we're getting is:

Standard Information:PSI Entry Point:

Project User: DOMAIN\USER

Correlation Id: 57cf2e18-c555-4933-8721-93139e2414b1

PWA Site URL: http://project/PWA

SSP Name: SharedServices2

PSError: CBSOlapDatabaseSetupFailure (17007)

Project Server failed to generate an OLAP object. CBS queued message: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=SERVER ASDBName=ProjectAnalyseDb ASExtraNetAddress= RangeChoice=1 PastNum=2 PastUnit=2 NextNum=2 NextUnit=2 FromDate=05/24/2007 18:32:03 ToDate=05/24/2007 18:32:03 HighPriority=False. Error: Analysis Services session failed with the following error: Failed to delete the Olap database: ProjectAnalyseDb. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

# May 24, 2007 11:52 AM

BriSmith said:

It looks like you need to add the user running your SSP as an admin within Analysis Services.  Assuming this is 2005 go to Management Studio, connect to Analysis Services then right click the server name and go to properties.  You should be able to add the user as an admin there.

# May 24, 2007 7:06 PM

Eric Dennis said:

I am having the same problem. How do I determine which user is running the SSP?

# June 13, 2007 11:53 PM

BriSmith said:

The best way is to go to the Shared Services Administration in SharePoint Central Administration then select the drop down for the SSP you want to identify the user for and select edit properties. The user shown under SSP Service Credentials will be the one running this SSP.

# June 14, 2007 12:01 PM

trb said:

Hi Brian,

This is the out put from the Build Tracking Comments. This had been working, any ideas?

===== Initiating cube build process =====

[6/19/2007 10:36 AM] Cube build request message has been added to the Project Server queue

===== Verifying and running pre-build server event handler =====

[6/19/2007 10:37 AM] Verifying and running pre-build server event handler

===== Determining database and cube structure =====

[6/19/2007 10:37 AM] Cube build initialization started

[6/19/2007 10:37 AM] OLAP database and cube structure was determined successfully

===== Building database and cubes =====

[6/19/2007 10:37 AM] Cube build session started

[6/19/2007 10:37 AM] Analysis Services session started

[6/19/2007 10:38 AM] 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 =====

[6/19/2007 10:38 AM] 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.

# June 19, 2007 1:46 PM

BriSmith said:

Generally this error means that the cube you are trying to overwrite with this new cube was created by a different instance of PWA.  If nothing has changed and you are just rebuilding then I would suggest loggin a support call.  I assume using a different cube name still works?

# June 19, 2007 4:33 PM

jroe@journalsentinel.com said:

Hi Brian,

We are trying to build our cube, obviously, but get the following error.

===== Initiating cube build process =====

[6/27/2007 3:14 PM] Cube build request message has been added to the Project Server queue

===== Verifying and running pre-build server event handler =====

[6/27/2007 3:14 PM] Verifying and running pre-build server event handler

===== Determining database and cube structure =====

[6/27/2007 3:14 PM] Cube build initialization started

[6/27/2007 3:14 PM] OLAP database and cube structure was determined successfully

===== Building database and cubes =====

[6/27/2007 3:14 PM] Cube build session started

[6/27/2007 3:14 PM] Analysis Services session started

[6/27/2007 3:15 PM] 2 of the NT accounts that correspond to users that have 'View Olap Data' permission could not be added to the Project Server default OLAP role 'ProjectServerViewOlapDataRole'

[6/27/2007 3:15 PM] Analysis Services session completed successfully

===== Verifying and running post-build server event handler =====

[6/27/2007 3:15 PM] Verifying and running post-build server event handler

===== Processing OLAP database =====

[6/27/2007 3:15 PM] Process OLAP database session started

[6/27/2007 3:15 PM] Analysis Services session started

[6/27/2007 3:15 PM] Analysis Services session failed with the following error: Failed to process the Analysis Services database ProjectServer_AnalysisServices on the STBLBIZI server. Error: Server: The operation has been cancelled.

===== Process Completed =====

[6/27/2007 3:15 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database ProjectServer_AnalysisServices on the STBLBIZI server. Error: Server: The operation has been cancelled.

The cube used to build just fine.

But then we did the following:

1) We added the Timesheet view to the cube View.

2) Attempted to rebuild cube (never completed, was terminated 13 hrs after submission with a reboot.)

3) Deleted Timesheet View

4) Attemped to rebuild cube (assumed we were back to where things were able to build)

5) Received the error noted above.

We are stumped.

Any suggestions.

thanks,

jeff

# June 27, 2007 4:36 PM

BriSmith said:

Hi Joe,

Not sure why the timesheet addition broke your cube but to get back to a working system I would suggest deleting the cube through Analysis Services (or buidling a cube with a different name) as some of the metadata may be corrupt if the system previous build was ended abnormally.

Best regards,

Brian.

# June 28, 2007 11:46 AM

PAUL said:

Hi Brian,

The error we're getting is:

Standard Information:PSI Entry Point:

Project User: DOMAIN\USER

Correlation Id: 57cf2e18-c555-4933-8721-93139e2414b1

PWA Site URL: http://project/PWA

SSP Name: SharedServices2

PSError: CBSOlapDatabaseSetupFailure (17007)

Project Server failed to generate an OLAP object. CBS queued message: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=SERVER ASDBName=ProjectAnalyseDb ASExtraNetAddress= RangeChoice=1 PastNum=2 PastUnit=2 NextNum=2 NextUnit=2 FromDate=05/24/2007 18:32:03 ToDate=05/24/2007 18:32:03 HighPriority=False. Error: Analysis Services session failed with the following error: Failed to delete the Olap database: ProjectAnalyseDb. Error: Your permissions on the server computer do not allow you to administer this Analysis server

# July 11, 2007 1:13 PM

BriSmith said:

Probably your administrative account for SharedServices2 needs to be in the administrators group for Analysis Services.

# July 13, 2007 3:31 PM

Ray said:

Hi, I have the same problem :(

===== Initiating cube build process =====

[8/6/2007 11:00 PM] Cube build request message has been added to the Project Server queue

===== Verifying and running pre-build server event handler =====

[8/6/2007 11:00 PM] Verifying and running pre-build server event handler

===== Determining database and cube structure =====

[8/6/2007 11:00 PM] Cube build initialization started

[8/6/2007 11:00 PM] OLAP database and cube structure was determined successfully

===== Building database and cubes =====

[8/6/2007 11:01 PM] Cube build session started

[8/6/2007 11:01 PM] Analysis Services session started

[8/6/2007 11:04 PM] Analysis Services session failed with the following error: Failed to create the Olap database: CUBO_PCS. Error: Unable to save object.  The object has been modified by another application.

===== Process Completed =====

[8/6/2007 11:04 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to create the Olap database: CUBO_PCS. Error: Unable to save object.  The object has been modified by another application.

Can you please help me!!!

# August 7, 2007 11:19 AM

BriSmith said:

Hi Ray,

This error sounds like something has been done through SQL Management Studio against your analysis services database and it is no longer recognised.  Or your metadata in the repository has been changed.  I would try a new cube name to see if this works.

Best regards,

Brian.

# August 13, 2007 1:31 PM

Bill Murphy said:

Brian

PS 2007

We have the ;

'Cannot overwrite an Olap database created outside of Project Server or by another Project Server Site'

error on the build cube

The SQL server / Analysis server combination is common to two(2) PWAs one for Production and one Training i.e. the Cube names are diferent but it is  still thowing the error.  Naturally its the Production cube that's failing.

Can you suggest any actions that might 'switch ownership' so the Production cube gets built not the train.  Or any thing at all which will get us out of the problem.

The PWA / Project 2007 has been installed on separate servers i.e. one for the Web and one for the App ONLY the SQL server is shared.

# August 17, 2007 2:37 AM

BriSmith said:

Hi Bill,

*** Correction *** I said queue in place of cube in the original comment posting - sorry for the confusion.

This shouldn't happen unless both are trying to write to the same Cube name - whcih is not allowed.  I have heard a few reports of this message so there may be some other reason it is appearing.  Generally using a new cube name will resolve the issue - but if it keeps recurring then this can be very inconvenient.  Log a support incident if it recurs and you can see no reason for the clash of names with your other server,

Best regards,

Brian.

# August 18, 2007 5:42 PM

Bill Murphy said:

Brain

Thanks for your response.  The two installs of the PS2007 where on separate servers so you would think there would be totally separate queues.  We have raised a case with MS and are waiting for support.  If we get a solution I will post it back here.

# August 19, 2007 10:30 PM

Michael Patrick said:

I am getting the same issue with the 'Cannot overwrite an Olap database created outside of Project Server or by another Project Server Site' message when having two PWA sites hook up to the same Analysis server.  Please let me know if you get a resolution from MS!

# August 27, 2007 11:58 PM

Michael Santos said:

Hi Brian,

Not sure if you can help here, but I am getting this error message... basically I'm seeing that some of the cubes are built but then it fails and gives the following error... any ideas???

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database Rincon_ProjectServerCube on the SEVENSEAS server. Error: Errors in the OLAP storage engine: The linked measure group with the ID of 'EPM Timesheet', Name of 'EPM Timesheet' cannot be processed because it contains MG dimension with the ID of 'Task Is Overallocated', Name of 'Task Is Overallocated' with different granularity attribute than its source object.

# September 7, 2007 12:17 AM

Dan Knowles said:

We are getting the following error and have figured out why.  If we change the name of the database to be created it works fine.  However, is there any way to recover/reuse the original database name (the one that threw the error)?

===== Initiating cube build process =====

[9/12/2007 3:00 PM] Cube build request message has been added to the Project Server queue

===== Verifying and running pre-build server event handler =====

[9/12/2007 3:00 PM] Verifying and running pre-build server event handler

===== Determining database and cube structure =====

[9/12/2007 3:00 PM] Cube build initialization started

[9/12/2007 3:00 PM] OLAP database and cube structure was determined successfully

===== Building database and cubes =====

[9/12/2007 3:00 PM] Cube build session started

[9/12/2007 3:00 PM] Analysis Services session started

[9/12/2007 3:00 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 =====

[9/12/2007 3:00 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.

Thanks!

# September 12, 2007 4:09 PM

BriSmith said:

Hi Dan,

I am preparing a blog posting on this exact scenario.  The quick and dirty way is to delete a row from the repository that contain the cube name you are trying to overwrite - but this does then leave some orphaned rows in the database.  Another way is to edit the data in the ObjectDefinition column for that row.

The ObjectDefinition for the row actually contains the Site UID that causes the conflict - for example:–

<DATABASE Name="CubeDe" Description="

Project Server Site UID: 1d59d459-90fc-4518-b6a5-f5a7fdb3c204" LastUpdated="10:01:02 09/11/2007"><CUSTOMPROPERTIES><PROPERTY Name="RESERVED_DATABASE_LOCALE_UPDATED2" DataType="0" Value="B"&