Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

Common Error Messages when Building Cubes with Project Server 2007

Common Error Messages when Building Cubes with Project Server 2007

Rate This
  • Comments 87

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:

 

Leave a Comment
  • Please add 6 and 5 and type the answer here:
  • Post
  • Common questions and answers on AS 2K5 permissions for EPM 2007: Getting Cube to Build 1. Which application

  • 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?

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

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

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

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

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

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

  • 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?

  • 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

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

  • 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

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

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

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

Page 1 of 6 (87 items) 12345»