Common Error Messages When Building Cubes with Project Server 2007

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

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

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

Page 8 of 8