Welcome to MSDN Blogs Sign in | Join | Help

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:

 

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

Thursday, March 01, 2007 12:52 PM by Christophe Fiessinger's Blog

# Analysis Services 2005 (OLAP) Permission for Project Server 2007

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

Tuesday, May 08, 2007 11:23 AM by Mike

# re: Common Error Messages when Building Cubes with Project Server 2007

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?

Friday, May 18, 2007 10:28 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Thursday, May 24, 2007 11:52 AM by Pavel

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Thursday, May 24, 2007 7:06 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Wednesday, June 13, 2007 11:53 PM by Eric Dennis

# re: Common Error Messages when Building Cubes with Project Server 2007

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

Thursday, June 14, 2007 12:01 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Tuesday, June 19, 2007 1:46 PM by trb

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Tuesday, June 19, 2007 4:33 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

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?

Wednesday, June 27, 2007 4:36 PM by jroe@journalsentinel.com

# re: Common Error Messages when Building Cubes with Project Server 2007

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

Thursday, June 28, 2007 11:46 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Wednesday, July 11, 2007 1:13 PM by PAUL

# re: Common Error Messages when Building Cubes with Project Server 2007

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

Friday, July 13, 2007 3:31 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

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

Tuesday, August 07, 2007 11:19 AM by Ray

# re: Common Error Messages when Building Cubes with Project Server 2007

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!!!

Monday, August 13, 2007 1:31 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Friday, August 17, 2007 2:37 AM by Bill Murphy

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Saturday, August 18, 2007 5:42 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Sunday, August 19, 2007 10:30 PM by Bill Murphy

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Monday, August 27, 2007 11:58 PM by Michael Patrick

# re: Common Error Messages when Building Cubes with Project Server 2007

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!

Friday, September 07, 2007 12:17 AM by Michael Santos

# re: Common Error Messages when Building Cubes with Project Server 2007

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.

Wednesday, September 12, 2007 4:09 PM by Dan Knowles

# re: Common Error Messages when Building Cubes with Project Server 2007

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!

Thursday, September 13, 2007 11:16 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

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"></PROPERTY></CUSTOMPROPERTIES></DATABASE>

So potentially you could replace the Site UID to overcome the issue, rather than deleting.  The Site UID can be found in several different ways – going to the Manage PWA page under the SSP and then choosing to Edit your site and getting the ID from the URL is probably easiest.

http://brismith260:10988/ssp/admin/_layouts/createpwa.aspx?task=Edit&id=ea8ecdc7-bc0c-4788-9abd-5744605d2974

This is easier if you have your repository in SQL Server - I haven't tried this when the repository is an mdb file but potentially you could do this with Access.

I am interested in hearing of scenarios that lead to this error.

Best regards,

Brian.

Friday, September 14, 2007 10:20 AM by Bianca

# re: Common Error Messages when Building Cubes with Project Server 2007

I hope you can help.

I have a single server implementation of Project Server 2007, SQL Server 2005 and Analysis Services 2005. Every time I try to run the cube build I get the following error:

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <ServerName>:<Port>\<InstanceName>. Error: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running.

The SQL Browser service is running, nuder the same account as the Analysis Services. Any ideas?

Friday, September 14, 2007 1:52 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Bianca,

The string you enter for the analysis server and instance should follow the pattern <ServerName>:<Port>\<InstanceName> but will actually read something like server1, or server1:1234, or server1\proj - so should be the real name of your server - and in a single server install you probably don't have multiple instances so it will very likely be just the server name.  I think this is the problem as I can repro the error you get by putting in the literal string <ServerName>:<Port>\<InstanceName>.

I hope this helps.

Brian.

Monday, September 17, 2007 5:59 AM by Guidho's MS EPM Blog

# EPM2007 and SQL Server 2005: error message when building OLAP cube

Setting up OLAP cubes for Project Server 2007 on SQL Server 2005 Analysis Services can be a real pain.I followed the TechNet article and all guidelines on Brian Smith's Project Support WebLog (which contains all possible errors you might run into when

Tuesday, September 18, 2007 5:14 PM by Bianca

# re: Common Error Messages when Building Cubes with Project Server 2007

I didn't mean to suggest that the literal string <ServerName>:<Port>\<InstanceName> was used. That is the pattern of the analysis server string.

My problem is the rest of the error, the part about not being able to connect to the redirector. The SQL Browser service is running, and it is running under the same login as the Analysis Services so it shouldn't be an access problem.

Wednesday, September 19, 2007 1:38 PM by dfknowles

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

Thank you for the information on reclaiming the cube name (http://blogs.msdn.com/brismith/archive/2007/02/14/common-error-messages-when-building-cubes.aspx#4895343).  The installation has the repository in an access database (msmdrep.mdb) as opposed to having it in SQL Server.  I was able to find the record in the mdb and modify the Database tag in ObjectDefinition field to contain

Description="Project Server Site UID: 1d59d459-90fc-4518-b6a5-f5a7fdb3c204"

as an attribute.

The following is an attempt to provide some background regarding how we got into this situation.  A second instance of project server was brought up to do some proof of concept.  As part of the proof of concept the cube was built with the database name being OLAP.  However, we did not wish to use this instance of project server, but we wanted to reclaim the OLAP name.

Thursday, September 20, 2007 11:14 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

OK, I would suggest using another client tool to try and access the same server.  It may be a name resolution issue, or a permissions issue, or a firewall issue stopping connection.

Thursday, September 20, 2007 11:40 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Thanks for the feedback DF, I can understand how this can happen.  I think there are also some other circumstances that can "break" the site id in the repository even when things come from the same PWA instance.  Any repros gladly reviewed...

Tuesday, September 25, 2007 8:47 AM by Mvanwyk

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi I'm new at this,

I get the following error, please assist.

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

[2007/09/25 02:28 PM] Cube build request message has been added to the Project Server queue

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

[2007/09/25 02:28 PM] Verifying and running pre-build server event handler

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

[2007/09/25 02:28 PM] Cube build initialization started

[2007/09/25 02:28 PM] OLAP database and cube structure was determined successfully

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

[2007/09/25 02:28 PM] Cube build session started

[2007/09/25 02:28 PM] Analysis Services session started

[2007/09/25 02:28 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server IGSP1. 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).

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

[2007/09/25 02:28 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server IGSP1. 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).

Tuesday, October 09, 2007 8:03 AM by Nico Oosthuysen

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

We are picking the following two erros at a couple of places:

_____________________________________________________

Analysis Services session failed with the following error: Cannot overwrite an Olap database created outside of Project Server or by another Project Server Site.

_____________________________________________________

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.

_____________________________________________________

This seems to occur only where the following is true:

1.  SQL 2005 Analysis Services is used (And related, the bug which prevents you from deleting AS databases through Management Studio)

2.  There are multiple PWA sites on the server

We confirmed that one PWA site is not trying to build on another's name.

I am wondering about your comment RE the Queue Names - would this be something we can check? (I.e. to confirm that 2 different PWA sites on the same installation does not have the same queue name)

Secondly, your suggestion of changing the SiteID - What would we do here?  Simply confirm that the SiteID is correct?

Thanks,

Nico Oosthuysen

Wednesday, October 10, 2007 6:13 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Nico,

Thanks for finding my error!  I should have said both are trying to write to the same CUBE name.  I will correct this.  You shouldn't have duplicate SiteID's but the easiest way to look at this is if you have the repository in SQL Server to open the tables and take a look.  See what cube names are given for the different PWA sites that you have.  It is possible that there is a bug that is causing some sort of clash.  You could also try setting cube build times far enough apart to avoid any clash of times.

Thursday, October 11, 2007 12:00 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Mvanwyk,

Sorry for the delay - it would appear the repository isn't being found.  I would take a look at the articles on http://technet2.microsoft.com/Office/en-us/library/ec990b7c-ec98-4d6d-b1a1-081a67fd66cc1033.mspx?mfr=true and specifically look at the article relating to the version of Analysis Services you are using and set you repository up in SQL Server.

Brian.

Monday, November 19, 2007 8:03 PM by Chris

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

We have been working to get our Analysis services started for quite some time. We have encountered all the errors noted but now, I have never seen this one posted:  Error: disk not ready. Cannot access repository server. Any clues?

Tuesday, November 20, 2007 10:14 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Chris,

I've not seen that one, but appears to be an I/O problem getting to the repository.  I would suggest re-building the repository as a SQL Server database following the TechNet article if you haven't already - or look for other errors in the event log that may indicate why disk I/O may be a problem. Also check the repository setting in Management Studio for Analysis Services in case they are pointing to a non-existent location.

Brian.

Thursday, December 13, 2007 2:25 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Vincent,

I'm guessing as my Spanish isn't good - but it may be the path to the Analysis Services repository. Try using a repository in a SQL db rather than an mdb in the filesystem.  The documents on TechNet for using Project Server 2007 with SQL 2005 detail how to configure this.

Brian.

Thursday, January 10, 2008 11:29 PM by Rakesh Luhar

# re: Common Error Messages when Building Cubes with Project Server 2007

I did all configuration according to guide. I am getting following error. Before this I was getting erro which say that your permission on AS not allow you to administrator.

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server. Error: Authentication failed.

Friday, January 11, 2008 12:16 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Rakesh,

FOr authentication errors I would check the event logs on all your servers, as there should be some other indication of this failure - hopefully detailing the account that couldn't be authenticated.  Possibly you may also need to restart AS to get changes to security to work.

Brian.

Monday, January 14, 2008 2:14 PM by Rakesh

# re: Common Error Messages when Building Cubes with Project Server 2007

Thanks for reply Brain.

Following is my setup.

I have Two servers. One have Project server running and second server has SQL 2005 database and AS on that.

I have used only one account <prsqlservice> for all places like WSS3.0 service account, SSP Pool account, and all other place where we need to use domain account.

I have added this user on the server carrying SQL 2005 Database and AS. I give server role of sysadmin, also added in AS security properties. I am using SQL 2005 database as Repository.

Now the Error of Authentication I was getting was b’coz I change the account running OLAP service to that account <prsqlservice> then local. As I change to Local that error stop coming and I am getting following error.

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <Server Name>. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

After this my event log shows error of 7704 & 7682.

Wednesday, March 12, 2008 5:37 AM by Ginni

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi,

I have followed all steps mentioned in the article below:

http://technet.microsoft.com/en-us/library/cc197728.aspx

still no luck,

I am getting the following error:

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

[3/12/2008 11:15 AM] Cube build request message has been added to the Project Server queue

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

[3/12/2008 11:15 AM] Verifying and running pre-build server event handler

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

[3/12/2008 11:15 AM] Cube build initialization started

[3/12/2008 11:15 AM] OLAP database and cube structure was determined successfully

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

[3/12/2008 11:15 AM] Cube build session started

[3/12/2008 11:15 AM] Analysis Services session started

[3/12/2008 11:15 AM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server DATIN06SQL01. Error: ActiveX component can't create object

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

[3/12/2008 11:15 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server DATIN06SQL01. Error: ActiveX component can't create object

Please suggest how to resolve it?

Wednesday, March 12, 2008 6:25 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Ginni,

This error can be seen when the components aren't the right version - but if everything is up to date you can still see it - particularly if re-building cubes frequently (within 10-20 minutes of a previous build).  I've seen it intermitently on my server and put it down to some process still running that is blocking.  Usually trying again after a short wait will work for me.  I must try and track down a better answer than this...  Any ideas anyone?

Best regards,

Brian.

Friday, March 28, 2008 8:03 PM by Kimberlee

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

I'm getting the same error posted by Michael Santos but I did not see a response to his issue.  For me this is the very first time I am building the cube.  It is a new installation with SP1 applied.

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database <NAME> on the <DB> 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.

Saturday, March 29, 2008 2:46 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Kimberlee,

I don't have an answer on this one yet.  Hopefully early next week I can get back to you.  It helps to know this is the first time you have tried to build a cube as it then would indicate some difference unrelated to any existing data - and perhaps a mis-match between the database and the binaries requesting the build.  I will keep digging.

Best regards,

Brian.

Tuesday, April 29, 2008 2:55 PM by VMAI

# re: Common Error Messages when Building Cubes with Project Server 2007

Brian... I'm getting this error... I hope you can guide me to a solution...

Error 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 'Resource is active', name of 'resouce is active' with different granularity attribute than its source object.

Tuesday, April 29, 2008 7:19 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi VMAI,

We are still researching this issue - but current thoughts are suggesting mis-matched versions of the SQL feature pack - so I would ensure you have all the latest updates for SQL Server loaded on the db engine, AS and alos your Project Server machine which needs to talk correctly to AS.

More as I find out more...

Best regards,

Brian.

Wednesday, April 30, 2008 10:56 AM by VMAI

# re: Common Error Messages when Building Cubes with Project Server 2007

TKS Brian... I checked the versions of the SQL Feature pack and that was the issue... I got PS2007 and SQL 2005 both in spanish... and I had one of the feature pack items installed in english... I reinstalled the spanish version of the item as well as the MSXML 6 SP1 and now I have the cubes generating without errors...

Thanks a lot... My head was about to roll because of this issue!!

Wednesday, April 30, 2008 12:54 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Excellent news VMAI.  Glad to hear this resolved things!

Wednesday, May 14, 2008 7:36 AM by PJ Mistry

# EPM2007 (64bit) - OLAP Cube Build Error; MD Dimension Task is Overallocated

Hi Brian;

we are getting an error message when building the OLAP cube.

Failed to build the OLAP cubes. Error: Analysis Services session failed with

the following error: Failed to process the Analysis Services database

OLAPCube on the ukapp09 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.

Please let me know what the cause might. I have come accross this error

before. Tried a few times.

This issue is also experienced by others I see and you had been looking into

this as well. Not sure what the outcome was.

Thanks

Regards

PJ Mistry

Wednesday, May 14, 2008 1:36 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi PJ,

This error appears to relate to mis-matched components - so make sure that all of the servers and components and parts of the feature pack (DSO, backwards compatibility etc.) are at the same release level.  This applies to the components on your application server as well as your Analysis Services and Database Engine server.  I'm not in the office right now but will try and do a full posting on this soon.

Best regards,

Brian.

Friday, May 16, 2008 1:04 PM by ladydemona

# re: Common Error Messages when Building Cubes with Project Server 2007

Brian,

Has there been a hotfix issued since September for the issue Dan had in this thread?  (Analysis Services session failed with the following error: Cannot overwrite an Olap database created outside of Project Server or by another Project Server Site.)  

Your work-around corrected the issue, but its not a permanent fix.  If you would like details surrounding our instance I can supply.  

-Christina Odom

Friday, May 16, 2008 6:37 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi LadyDemona,

There isn't a hotfix for this yet, but we have identified how it can happen.  I'll be doing a full post shortly but basically you can get into this bad state if you have two instances of PWA trying to build a cube at or around the same time.  One will work - the other will fail, and then the failing one will give this error as the repository details for the cube get corrupted.

Best regards,

Brian

Thursday, May 22, 2008 2:18 PM by Virgilio Arciniegas

# re: Common Error Messages when Building Cubes with Project Server 2007

One of my customers had the same issue Michael Santos and Kimberlee had:

"Error 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 'Resource is active', name of 'resouce is active' with different granularity attribute than its source object."

The problem was that they had installed SQL Analysis Services after they applied SP2 to SQL server. This lead to a mismatch of versions between MS SQL Server 2005 and MS SQL Analysis Services 2005.

Just as a little extra piece of information, the server was 64 bit, BUT I would expect the same issue on a 32 bit environment.

I hope this helps Michael or Kimberlee.

Regards,

Virgilio Arciniegas

virgilio.arciniegas@catapultsystems.com

MCSE, MCDBA, MCITP EPM

Monday, May 26, 2008 8:08 AM by Ginni

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

Still no luck. I am getting errors 7704 and 7762. Have tried re-installing evrythig again on both the database server as well as the project server.Any help?

Tuesday, July 08, 2008 1:52 PM by Sadaf Shaikh

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

I'm facing the same issue as Michael Santos and Kimberlee, at the client I've deploying project server 2007 at.

"Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database OMV_EPM_OLAPDB on the somvpk001203 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."

I have a two server scenario, with SQL Server 2005 Standard Edition plus AS on one machine, and the Feature Pack I had downloaded sometime back, works well with installations based on SQL Server 2005 Enterprise Edition. Is this issue related to the standard edition ? That is , is there a separate feature pack download for different versions of SQL Server 2005 ?

Tuesday, July 08, 2008 2:28 PM by Sadaf Shaikh

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

Any way we can check a mis-match between the database and the binaries requesting the build on the Application Server ?

Thursday, July 17, 2008 9:09 AM by Steve

# re: Common Error Messages when Building Cubes with Project Server 2007

I am coming across the error id="17013" name="CBSAttemptToOverwrite" messages.  

I can create a new cube and builds fine.  But my scheduled cube build at night fails and receive these error messages.  What would be preventing it to overwrite?  

Tuesday, July 29, 2008 6:11 AM by Johan

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

I have the same problem as Michael Santos, Kimberlee and Sadaf Shaikh. But I use SQL Server 2005 Enterprise edition, and with SP2 installed after Analysis Services was installed. The error message also pops up on the screen when I click properties on Analysis Services Repository in SQL Server Management Studio.

Any input on this issue would be highly appreciated.

Kind regards,

Johan

Tuesday, July 29, 2008 12:20 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Johan,

The error is caused by mis-matched versions of components and here is a set of steps suggested by one of my colleagues for resolving.  This was back in May - so check for even more recent versions than the ones listed.

Step #1: Installed newest Management Objects on SQL server

On SQL Server computer, please download and install the latest Management Objects from the following link:

http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/SQLServer2005_XMO.msi

Step #2: Updated Native Client and BC Objects, and reinstalled Management Objects on Application Server

On Project Server computer (Application Server), download and update Native Client from the following Link:

http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlncli.msi

On Project Server computer (Application Server), download and update BC Objects from the following link:

http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/SQLServer2005_BC.msi

On Project Server computer (Application Server), download and install the latest Management Objects from the following link:

http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/SQLServer2005_XMO.msi

Tuesday, July 29, 2008 12:58 PM by Mswt

# re: Common Error Messages when Building Cubes with Project Server 2007

Regarding -

"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."

I have the Network Service account running but want to change that to a domain user so i can test logging in to the Analysis server through the admin tool.  I have a build error saying i do not have permission to the analysis server.

How do i change the SSP Service Credentials and still get PWA to run.  When i tried the PWA site went down with an "unexpected" sharepoint error.

Anywhere else I need to update?

Many thanks...

Monday, August 04, 2008 10:09 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Sorry for the delayed response Mswt.  That is the only place - but the domain account will need the right permissions.  See http://blogs.msdn.com/brismith/archive/2007/02/08/operating-system-and-sql-permissions-for-the-microsot-office-project-server-2007-service-account.aspx for details of permissions required.

Best regards,

Brian.

Tuesday, August 05, 2008 9:51 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Steve,

Sorry for the delayed response.  The CBSAttemptToOverwrite error indicates that the cube named in the repository does not appear to match up to the instance of Project Server that is trying to build it.  It can happen if two cubes are being built at the same time from different instances.  Is this your scenario?  Another workaround is to edit the repository to remove this cube name, which is the same as using a new cube name - but will maintain all the views built against the named cube.

Best regards,

Brian.

Sunday, August 24, 2008 2:11 AM by Ravi Gokulgandhi

# re: Common Error Messages when Building Cubes with Project Server 2007

I am getting this error while building cubes.  I am using Sql Server 2008 and have also installed feature pack as well as backward compatibility pack for sql server 2005. Any pointers.

<--- Log---->

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

[8/24/2008 11:32 AM] Cube build request message has been added to the Project Server queue

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

[8/24/2008 11:32 AM] Verifying and running pre-build server event handler

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

[8/24/2008 11:32 AM] Cube build initialization started

[8/24/2008 11:32 AM] OLAP database and cube structure was determined successfully

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

[8/24/2008 11:32 AM] Cube build session started

[8/24/2008 11:32 AM] Analysis Services session started

[8/24/2008 11:33 AM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dev-1. Error: ActiveX component can't create object

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

[8/24/2008 11:33 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dev-1. Error: ActiveX component can't create object

<---End Log-->

Tuesday, August 26, 2008 12:38 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Ravi,

The "usual" reason for this error is incompatible versions of the various components.  Do you have SQL Server 2008 for your Analysis Services as well as your databases?  I will be moving some of my servers over to 2008 later this week so will test this scenario and check the component versions when I get it working.

Best regards,

Brian

Thursday, October 23, 2008 9:06 PM by Scott Stumpf

# re: Common Error Messages when Building Cubes with Project Server 2007

I am running into the same issue.  Even with all the SQL 2008 Feature Pack components installed, including SQL 2008 ADOMD.NET, we see the same error when trying to build the cube against SQL Server 2008 Analysis Services.  If I find a workaround, I will post it.

Saturday, October 25, 2008 12:37 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Scott - I am getting close on this one.  Try loading the 2005 stuff as per the previous docs and then add the SQL Server 2005 cumulative update 10.  KB956854.  I hope to do a full posting soon - just testing some things out...

Best regards,

Brian.

Thursday, October 30, 2008 6:10 AM by Paul Mather

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

We have an issue where the scheduled cube does not work but when you build now it works fine. On further investigation it appears that none of the scheduled jobs appear to be working. The cube build timer job references an old project server instance 'PWA' and not the new instance 'projectserver'. To try and resolve the issue we have deleted SSP and Web application.

Re-created the web application and SSP and then created new PWA instance linking to existing databases and that has not re-created the timer jobs. Please can you let me know if you have any ideas what could cause this issue or if you can think of anything else that we can try?

Kind Regards

Paul Mather

Wednesday, December 17, 2008 6:40 PM by Matt Stevenson

# re: Common Error Messages when Building Cubes with Project Server 2007

In addition to the above, in our customer's 2 server PS2007 + SP1 on SQL2005 + SP2 build it was necessary to manually enter the following value:

SQL Server Mgt Studio > Connect to Analysis Services > Right-click server > Properties > Show Advanced (All) Properties > DSO \ RemoteLocksDirectory > type in value of \\<servername>\MSOlapRepository$\ > OK

nb. Remember to re-start the Analysis Services service after this step and before trying to re-build your OLAP cube again.

This tip was found on: http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/f62966c5-522e-47fb-ae7e-90a445a6e9d5/

Regards: Matt Stevenson (matt@mstraining.net)

Thursday, December 18, 2008 12:12 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Thanks for sharing Matt.  

I must admit I prefer the option to use a repository in SQL Server - then none of this is necessary, and any issues are far easier to troubleshoot.

Best regards,

Brian.

Thursday, December 18, 2008 9:46 AM by Matt Stevenson

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

In this instance, they are using an SQL Server database. It still required this setting before things worked...

Matt

Thursday, December 18, 2008 10:05 AM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Interesting Matt.  I've never needed to set that.  Does it actually stop working if you remove those settings?  Just a double check to make sure that some other change didn't resolve the issue.  For instance the restart may have corrected a permissions issue.  Let me know how this goes.

Thanks,

Brian.

Tuesday, January 20, 2009 9:42 AM by PeteH

# re: Common Error Messages when Building Cubes with Project Server 2007

Finally got it working! The following steps solved a continuous "Your permissions on the server computer do not allow you to administer this Analysis server." error:

1. Setup DSO9 directory in \Program Files\Microsoft SQL Server\MSSQL.x\OLAP

2. Share the folder as MSOLAPRepository$

3. Give your SSP account full control of this share

4. Edit \Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Config\MSMdsrv.ini - add the following in the DSO section near the end:

<RemoteLocksDirectory>\\SERVERNAME\MSOLAPRepository$</RemoteLocksDirectory>

<LocksDirectory>C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\DSO9</LocksDirectory>

(where MSSQL.x is the directory that contains the OLAP folder)

5. Restart Analysis Services.

Good luck!

Pete

Tuesday, January 20, 2009 3:02 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Thanks for sharing Pete.  I must admit I prefer the option of using a SQL repository - but know of others that have better success using the mdb with the steps you give above.

Best regards,

Brian.

Sunday, January 25, 2009 8:31 AM by TomR

# re: Common Error Messages when Building Cubes with Project Server 2007

OMG!  Thanks Pete.  I've been trying to get this to work for 4 months (on and off).

I have read all of the technet tips, Brian's blog, waiting on the components that would work without a workaround etc., but kept getting the same error as you.

Your solution finally got rid of that error.

To Brian's comment about using the SQL repository, that is what I am using, but it wouldn't work until I added the share and put the lock folder in MSAS settings.

We have a small 20 person setup with a 2 server config (both running Win2k8).  A 64Bit SQL Server 2008 with a named instance supporting the second server.  This one is 32 bit and is hosting both Project Server and Team Foundation Server. I don't know what makes this setup unique, but I'm glad someone finally had the same issue as I did and solved it.

One other comment.  The build settings web interface in PS doesn't allow you to type the Backslash "\" to specify the named instance.  You have to paste it in from another program !#@$.

Thanks,

Tom

Friday, February 06, 2009 11:21 AM by Sara

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Brian,

I just finished reading through this blog and all the comments and wanted to touch base regarding the CBSAttemptToOverwrite error message.  You mentioned looking for ways to repro that error.  We just experienced this again and I believe I have one for you.  Our OLAP cube has been building successfully for months (every night).  However, yesterday I came in and it was still "processing" at 50%.  It started to build as scheduled at 1:00am.

So that it would not tie up a queue thread and since all the reporting jobs were getting backed up I canceled the job within the queue.  All the Data Analysis views were visible, so I believe the cube actually built, it just didn't finalize to 100% complete within the queue.  I couldn't find anything in the ULS or Application logs, granted I may not have known really what to look for over that 8 hour time frame.  

Today the OLAP cube build failed with the message about not being able to overwrite.  That is because I "touched" it by canceling it within the queue.  We had to use the workaround of renaming the cube in order for it to rebuild.  And of course we then had to rename all of our views to point to the newly created cube.  I would really like to understand why the cube hangs at 50%.  This was really strange for us as I stated before it had been working for quite some time.

Have you ran across this before and do you have any insight you can share?  If we can determine why it hangs occasionally, we can prevent this scenario of receiving that failure.

Thanks,

Sara

Monday, February 09, 2009 6:35 PM by BriSmith

# re: Common Error Messages when Building Cubes with Project Server 2007

Hi Sara,

Thanks for this feedback.  I haven' come across the 50% complete issue - but I think you are on the right track that cancelling somehow didn't then complete the update of the repository which led to the overwrite problems.  I will ask around to see if this is behavior we have seen elsewhere.

Best regards,

Brian.

Friday, February 20, 2009 6:29 AM by Fahiem Rahim

# re: Common Error Messages when Building Cubes with Project Server 2007

Pete,

Thank you so much for your steps. The 2 lines that go into the ini file have resolved my pains with Cube building. Thanks.

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker