Home » Microsoft Technologies

OLAP Cube Building in Project server 2007 with SQL Server 2008 R2

Can anybody help me out..

I am deploying a project server 2007 sp2 in VPC. I have Windows Server 2008 SP2 (32bit), Project server 2007 and SQL Server 2008 R2, I have properly Installed feature pack of SQL R2 I have take care of versions also.


And I have also copy the msmdrep.mdb file in “C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\DSO9” location with sharing and security permission. And I have did job in SQL Server Analysis Properties Job (DSO Setting).

After all setting trying to build OLAP Cube but it giving the error

“Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server epmdemo. Error: ActiveX component can't create object” 

These all settings i did through the help of Microsoft Project server deployment guide.

Thanks in advance….. J


6 Answers Found


Answer 1

Hi Avinash,

Have you followed the instruction in the article: http://support.microsoft.com/kb/921116

its addresses the issue you are facing.

Let us know if it helps.



Answer 2

Thanks for reply Khurram,

But I have successfully build OLAP in OS 2003 and sql server 2005. this time I have OS 2008 and SQL server 2008 R2 in Project server 2007 and am stuck with this error.



Answer 3

Actually the error you are facing is related to one of the component missing, mentioned in the KB, while configuring analysis services for OLAP cube.

Whats your ULS log saying, please share with us, it will be more indicative.


Answer 4


Please go through this blog, its addressing exactly the issue you are facing:


Does that help?


Answer 5

Ya dear Jamshed,

I have read the blog given by you. thanks.

can you remind me all feature packs which need to be installed on my server with SQL Server 2008 R2.

Error Log :

Standard Information:PSI Entry Point:

Project User: EPMDEMO\Farmadmin

Correlation Id: 2cb2b0c7-030a-4d44-a678-f31f51ca7225

PWA Site URL: http://epmdemo/Litware

SSP Name: ProjectServer_SSP

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=epmdemo ASDBName=OLAP Cube ASExtraNetAddress=epmdemo RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=01/16/2011 21:55:25 ToDate=01/16/2011 21:55:25 HighPriority=True


Standard Information:PSI Entry Point:

Project User: EPMDEMO\Farmadmin

Correlation Id: 2cb2b0c7-030a-4d44-a678-f31f51ca7225

PWA Site URL: http://epmdemo/Litware

SSP Name: ProjectServer_SSP

PSError: GeneralQueueJobFailed (26000)

A queue job has failed. This is a general error logged by the Project Server Queue everytime a job fails - for effective troubleshooting use this error message with other more specific error messages (if any), the Operations guide (which documents more details about queued jobs) and the trace log (which could provide more detailed context). More information about the failed job follows. GUID of the failed job: 192ecf30-fef2-4a12-8ace-8a896ac75263. Name of the computer that processed this job: EPMDEMO (to debug further, you need to look at the trace log from this computer). Failed job type: CBSRequest. Failed sub-job type: CBSQueueMessage. Failed sub-job ID: 2. Stage where sub-job failed:  (this is useful when one sub-job has more than one logical processing stages).




Answer 6

Hi Avinash

have you installed "SQL Server 2005 backward compatibility Component" ?

issue typically caused if you haven't added the SSP Admin account to Analysis Server security group with write access ?

Also after adding SSP Account, restart the SSAS service in services.msc

Let me know if this helps


Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com


I followed this instruction to setup Analysis Services with the Project Server 2007 with SQL 2008 : http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx

I went through Option 1: Create the repository database by creating a SQL Server 2008 database

I am getting :



Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server “servername.domain.com”. Error: Cannot connect to the repository. Analysis server: “servername.domain.com” Error: Provider cannot be found. It may not be properly installed


I put the right server name between””.

My questions are:

1-is this the right instruction to follow for installing Analysis Services? if not please provide it.
2-I have one SQL server 2008 , and on a separate server I have project server 2007, and on another server I have SharePoint 2007 (3 servers total). I
Installed the DSO client components only on  Project Server , is it right?

Please advice.




I have been researching this online and connot seem to find a definitive answer. So, forgive me for the newbie question, but is it possible to view OLAP cubes in SQL Server 2008 Express? I have been trying to view these through Excel 2003 but this seems to be a limitation and I cannot find a data connector for the transport layer in Excel. So, I thought I would try to view the OLAP cubes through SQL Server 2008 Express version. Is this a limitation of SQL Server express? If so, is there another alternative someone could suggest?




We are seeing instances of deleted projects still existing in the Cube build. Normally, once a schedule has been deleted from the draft & published data stores, the next Cube build will not contain data associated with the deleted schedule. This is resulting in descrepancies when we use the PWA data analysis function.

The "deleted" project dos still exist in the project server archive.

Any thoughts/suggestions.



Hi at all,

in our environment we build Portfolio_Analyzer cube in complete way. We have some custom field with lookup table associate.

In data analisys view, we can filter our views using this custom fields values correctly.

I.E. (the custom field TEAM_LEADER based on a lookup table with key (code of resource) and description (name of resource))

Now, in my dataAnalisys view filter, i can see TEAM_LEADER filter, and, if i expand this, i see all keys (code of resource). This work but it's not so usefull. 

In your opinion is it possible to have in these filter (on Custom field based on a look up table) both key and description together?

In order to semplify our filtering work, is there some customization to get this?

Thank you


Paolo O.






I am having some issues creating the OLAP cubes in our newly migrated Project Server 2010 instance.

the path I followed for migration was the DB Attach method, so I installed a new server from scratch for the installation.

As I am using SQL 2005 as an DB Engine (including Analysis Services), I have tried building the cube both with the 2005 and 2008 versions of the Native Client installed, as well as only with the 2005 version, and only with the 2008 version - neither has worked.

I am assuming that SQL 2008 Native Client has to be installed, as that is what the prerequisites installer installs before you install SharePoint.  In this case, this is the error that I am getting:

Failed to build the OLAP cubes. Error: Failed to process the Analysis Services database pwa on the ptasql1 server. Error: OLE DB error: OLE DB or ODBC error: Class not registered.

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 'pwa', Name of 'Resource Type' was being processed.

Server: The operation has been cancelled.


I have ensure the following permissions is configured:


·The Analysis Services service account has DB_DATAREADER permissions on the ProjectServer_Reporting database

·The SharePoint Farm Service account as well as the Project Server Administrator account has administrative permissions in the Analysis Services instance

Is there anything else you guys think I can try? 






Goodday everybody...

I am having troubles building my OLAP-cube in Project Server 2010 this morning. An excerpt from the building report:

"Could not load file or assembly 'Microsoft.AnalysisServices, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified."

So I went to Microsoft Downloads and downloaded and installed the file "SQLSERVER2008_ASAMO10.msi", and installed it on the SQL box. But I continue to keep the message above and the Cube won't build. Does anybody have any ideas? Thanks ahead!






Hi Folks,


I keep running into the following OLAP Cube Build issue for alot of our instances.

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.

<?xml version="1.0" encoding="utf-16"?>



    <class name="CBS message processor failed">

      <error id="17013" name="CBSAttemptToOverwrite" uid="aeab96a7-9a14-4f50-8599-733861ad400e" CBSRequest="Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=xx.xx.xx.xx ASDBName=ALD_Analysis ASExtraNetAddress=xx.xx.xx.xx RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/11/2010 09:51:34 ToDate=08/11/2010 09:51:34 HighPriority=True" />


    <class name="Queue">

      <error id="26000" name="GeneralQueueJobFailed" uid="a4288103-62f1-4fa2-9ed8-e886a9752e9e" JobUID="3e0b8c89-8009-474c-a7fb-c6852b86449a" ComputerName="Servername" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />




I have tried deleting the row in the OLAPObjects table of the Analysis Services Repository and also any entry with the same parentID as the parent row(above). After doing that the cube build ok for a few days then it will fail again. I think the client is adding some dimensions to the configuration but I'm not sure that would cause it to fail.

If anyone has any tips on how to get a sustainable cube built to work with going forward, I would be very grateful.

PS - We are using MOPS 2007 with SP2 & Feb CU with a seperate boxes for SQL DB and Analysis DB.




My cube builds were working fine a week ago (Project server 2007).  Now I am getting the following error

Now the error was :

===== Initiating cube build process =====

[7/27/2010 6:11 PM] Cube build request message has been added to the Project Server queue

===== Verifying and running pre-build server event handler =====

[7/27/2010 6:11 PM] Verifying and running pre-build server event handler

===== Determining database and cube structure =====

[7/27/2010 6:11 PM] Cube build initialization started

[7/27/2010 6:11 PM] OLAP database and cube structure was determined successfully

===== Building database and cubes =====

[7/27/2010 6:17 PM] Cube build session started

[7/27/2010 6:17 PM] Analysis Services session started

[7/27/2010 6:22 PM] Analysis Services session completed successfully

===== Verifying and running post-build server event handler =====

[7/27/2010 6:22 PM] Verifying and running post-build server event handler

===== Processing OLAP database =====

[7/27/2010 6:22 PM] Process OLAP database session started

[7/27/2010 6:22 PM] Analysis Services session started

[7/27/2010 7:33 PM] Analysis Services session failed with the following error: Failed to process the Analysis Services database on the server.

Error: Internal error: The operation terminated unsuccessfully.

OLE DB error: OLE DB or ODBC error: Unspecified error.

Errors in the OLAP storage engine:

An error occurred while processing the 'Assignment Timephased' partition of the 'Assignment Timephased' measure group for the 'Assignment Timephased' cube from the database.

Internal error: The operation terminated unsuccessfully.

Server: The operation has been cancelled.

So desperate in  solving this .......hope some can help !!



Hi all,

we've got an issue with our Project Server 2007 (SP2, Dec2009 CU) Cube Build. It's taking quite a long time and before you quit reading: yes, I know the work around with the execution plan (we already had several in use), but the problem is exactly that - the trace is not showing the bad sql.

But let me start at the beginning: We had a project which could not be published to the Reporting DB due to an error referencing a foreign key constraint problem. We found a work around telling us to rebuild the Reporting DB by doing an administrative Backup and Restore of the Custom Fields. (We finally solved the problem otherwise, the rebuild didn't work).

The next morning we had a cube build error and the error led us to the following blog http://blogs.msdn.com/b/brismith/archive/2008/02/28/olap-and-data-analysis-timeouts-plan-guides-and-tempdb.aspx: our cube could not be built because of the rebuild of the Reporting DB.

We followed the blog advice removing all assignment dimensions from the cube configuration, saving it and then adding those dimensions again. And that's where our current problem probably results in:

By saving a new configuration (though we added the same dimensions in the seemingly right order) it seems that our execution plan we had in place can not be matched any more (at least this hint is given in one of the comments of the above mentioned blog entry) - the cube is now again taking hours to build.

We thought we could easily get the new execution plan into place (following the steps described by Brian Smith in http://blogs.msdn.com/b/brismith/archive/2008/02/28/olap-and-data-analysis-timeouts-plan-guides-and-tempdb.aspx). But Brian Smith is mentioning to wait a couple of minutes and then search the trace for "MSP_EpmAssignmentByDay_OlapView". But we are tracing for 11 hours now and still there is no sign of the statement we need to create the new execution plan.

As I already did the tracing a few times I find it rather odd that the Select-Statement is still not there, I never had to wait for such a long time until it showed up in my trace. Do you have any suggestions why this statement might not be there? Do you think it will appear if we wait a while longer? Or might there be another problem with the cube and that's the reason it's taking so long.

I would be grateful for all suggestions. We need the cube urgently and it is blocking our queue for quite some time now - and it is main reporting time. :-(

Thanks a lot,


PS: SQL Analysis Services run on SQL Server 2005 SP2 CU9.

At initial install of SQL Server 2008 R2 November CTP there was an option to use the Evaluation Version License Key or enter an actual License Key. We installed using the Evaluation Key. Will we be able to update the key to an acutual License once available? If so, what is the process for updateing the License Key from Evaluation to RTM. I ahve had many past experiences where RTM License Keys required new RTM Media.  


After I installed SQL Server Express 2008 R2 I realized that if I wanted to use the AdventureWorks sample databases I needed to have SQL Server Express 2008 R2 Advanced Services installed because Advanced Services has full text search installed which is required to install and run the sample databases. I downloaded the installation but nothing happened. So, do I need to uninstall SQL Server Express 2008 R2 and install SQL Server Express 2008 R2 Advanced Services? Or, is there a way I can upgrade my existing installation of SQL Server Express 2008 R2 to SQL Server Express 2008 R2 Advanced Services.


I have installed sql server 2008 r2 developer with its full tool set, finally, and though the sql2008r2 express with advanced tools stated that each instance has its own tools, registry values, etc, I thought it prudent to ask if sql server 2008 r2 express tools would screw up sql server 2008 r2 developer tools (limited functionality afterwards)?

I am trying to install sharepoint server 2007 on windows server 2008 r2,I downloaded the version of sharepoint that contains service pack2,after the installation finished,message displayed that mssql\officeservers cant be found?

Must I install sql server 208 before installing sharepoint,is sql express that is already installed with sharepoint 2007 not compatible with windows server 2008 r2


I have read many threads with similar questions and I did find confirmed support for CS 2007 SP2 on Win 2008 R2 (http://blogs.msdn.com/b/commercesupport/archive/2009/10/02/installing-commerce-server-2009-on-windows-server-2008-r2.aspx)

Can someone please confirm I can use SQL Server 2008 R2 (x64) on Win 2008 R2 (x64) for CS 2007 Sp2 web application (2 separate server deployments)? I see this link says it is supported but doesnt explicitly say x64 bit (http://blogs.msdn.com/b/commerce/archive/2008/11/21/cs2007-sp2-now-supports-sql-server-2008.aspx)

Has anyone done the SQL 2008 R2 in production? I dont see it listed in Software Requirements for CS 2007 Sp2.

Any feedback from Commerce Team is greatly appreciated.
Eagerly Awaiting response - We are few weeks away from Staging a Production release.


workflow question:
If I create a cube in the Visual Studio edition that comes with Sql 08 R2, deploy that cube to my new Sql 08 R2 instance, than re-deploy that same cube (via deployment options in the VS solution properties) to a Sql 05 AS instance, what happens when I re-deploy it do Sql08 R2?  By virtue of deploying the cube to the Sql08 R2 AS instance, does it than take advantage of all the Sql08 R2 goodness? 

Also, I

Steve Walker

Also, how does one determine the compatibility level of an AS cube?  In Sql Server DB/Relational, there is a compatibility level.


I have a project server environment that contains the following servers:

Server1:  Windows Server 2003
Server2:  Windows Server 2008
Server3:  Windows Server 2008
Database:  SQL Server 2000

Server1 currently hosts the Project Application Service.  I need to move the service over to Server2 or 3.  However, I tried to install the SQL Analysis Services components from the SQL Server 2000 CD, but I received a compatibility error message.

What components do I need to install on the Windows Server 2008 machines to be able to host the Project Application Services connected to a SQL 2000 Database Server?  I did find some components listed here (http://www.microsoft.com/downloads/details.aspx?FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c&displaylang=en) that work with SQL 2000, 2005, and 2008.  Will this allow me to host the Project Application Service on my Windows 2008 server?

Thank you!





I want to implement a high availability solution with SQL Server 2008 R2. Mostly I'm interested on Failover Clustering and Mirroring.

Which one of these two solutions would work?


I have two servers, both have installed Windows Server 2008 R2 and SQL Server 2008 R2 (ServerA and ServerB). But the first server (ServerA) is a physical server, and the second server (ServerB) is a virtual server with Hyper-V.



Option 1: Failover Clustering active/passive

If I try to implement Failover Clustering, would it work? I plan to make ServerA as a active server and ServerB as a passive server. So if ServerA fails then ServerB would become the new active server, and vice versa. Is it supported in Hyper-V R2?



Option 2: Mirroring without automatic failover
Would Mirroring work? What if I make ServerA Principal server and ServerB Mirroring server. So if ServerA fails then ServerB would become the production server for the databases. Is it supported on Hyper-V R2?

I am willing to implement only one of them. Which one will work and which one do your recommend?



just got the system up and running. however when I try to log in http://servername/reports on other machine of the same domain, I keep getting prompt for name and password.

I can login on the local machine..

Please help, I need to allow guest to view reports..




It is possible, in the Cube Build Settings page of PWA 2007, to create several cubes (one for each year for exemple) because I need to create several S curves starting from zero.

Wouls it be possible to set an automatic update frequency for each cube?




It is possible, in the Cube Build Settings page of PWA 2007, to create several cubes (one for each year for exemple) because I need to create several S curves starting from zero.

Wouls it be possible to set an automatic update frequency for each cube?



<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure