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
·