Home » Microsoft TechnologiesRSS

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.

SQLSERVER2008_ASADOMD10msxml6-KB954459-enu-x86SQLSERVER2008_ASAMO10

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.

Regards

 

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

Kumar,

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

http://blogs.msdn.com/b/brismith/archive/2008/10/27/project-server-2007-and-sql-server-2008-error-messages-with-data-analysis-cubes-olap.aspx

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

 

Regards

 

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
 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter