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:-
· 0x0EAC
· 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)
· Time: 2:32:56 PM
· Correlation Id: 87a08e57-822e-4ec9-9a47-671f14679d6e
· 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.
· 0x0CAC
· 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)
· Time: 2:38:50 PM
· 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.
· 0x1204
· 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.
· Event ID: 7685
· Time: 2:51:09 PM
· 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.
· 0x0D44
· 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
· Time: 2:57:01 PM
· User: <SERVER>\ASAdmin
· 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 Source: MSSQLServerOLAPService
· Event Category: (289)
· Event ID: 3
· 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 ID: 7691
· Time: 2:57:02 PM
· 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: 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
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.
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.
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?
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.
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.
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.
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.
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.
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?
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,
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.
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.
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.
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...