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:DOMAINUser, 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: DOMAINUser

·         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:DOMAINUser, 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: DOMAINUser

·         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  

·   &nbsp