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

  • Question

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

    1. SQLSERVER2008_ASADOMD10
    2. msxml6-KB954459-enu-x86
    3. SQLSERVER2008_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


    Avinash kumar
    Monday, January 17, 2011 7:01 AM

Answers

  • 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
    Monday, January 17, 2011 9:10 AM

All replies

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

     


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Monday, January 17, 2011 7:26 AM
  • 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


    Avinash kumar
    Monday, January 17, 2011 8:00 AM
  • 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.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Monday, January 17, 2011 8:11 AM
  • 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?


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Monday, January 17, 2011 8:15 AM
  • 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


    Avinash kumar
    Monday, January 17, 2011 8:40 AM
  • 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
    Monday, January 17, 2011 9:10 AM
  • Avinash

    Do you somehow manage to get the Project Server 2007 installed successfully with SQL 2008 R2 Analysis Service? I am having the same situation here. Thanks!

    Philip

    Monday, March 21, 2011 9:42 AM
  • We have gotten PS2007 installed and functional with SQL 2008 R2 Analysis Services.  After setting up the SQL 2005 Features as described for the "Requirements for using SQL Server 2008 Analysis Services with the Project Server 2007 Cube Building Service" and having the cube fail with the following error:

    Failed to connect to the Analysis Services server SERVER. Error: Cannot connect to the repository. Analysis server: SERVER Error: Provider cannot be found. It may not be properly installed.

    It was necessary to complete the following:

    From the Microsoft SQL Server 2008 Feature Pack (April 2009 linked here), install the Microsoft SQL Server 2008 Native Client on Project Server Application Servers (note, this is AFTER installing the Microsoft SQL Server 2005 Native Client, and all relevant SQL DSO client components on the Application Servers).  Test the cube build.
    Note: This is NOT the SQL 2008 R2 Feature Pack.

    Hopefully that helps! The only additional thought here is - Is SQL 2008 R2 (DB and AS) a supported environment for Project Server 2007, from Microsoft's perspective?


    Dave Dunn
    Friday, June 10, 2011 3:16 PM