none
PWA 2007 and SQL 2008 R2 - Failed to build OLAP Cube error - cannot find the file specified RRS feed

  • Question

  • Hello,

    We are using Project Server 2007 and SQL 2008 R2 on a single server.

    When we try to build an OLAP cube we get the following error:

    [10/23/2013 5:47 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <servername>. Error: Automation error
    The system cannot find the file specified

    Have followed MS based article (to the letter):

    the Feature Pack for Microsoft SQL Server 2005 - December 2008

    Installed the Feature Pack for Microsoft SQL Server 2005 - December 2008

    Am I missing something?

    Does it work with SQL 2008 R2?

    thanks

    Wednesday, October 23, 2013 10:05 PM

All replies

  • Take a look at this excellent blog by Brian, which covers most of the scenarios and one of them seems to be what you are having, hopefully this should help http://blogs.msdn.com/b/brismith/archive/2007/02/14/common-error-messages-when-building-cubes.aspx 

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

    Tuesday, October 29, 2013 3:09 PM
    Moderator
  • Thanks Sunil,

    I have viewed that log and applied the recommendations, but the same error persists

    This (Cube build) worked a few years ago when we had SQL 2005; Since we upgraded to SQL 2008 R2 (recently) I have not been able to get the cube build to complete (it starts off as normal) but 2 minutes later this persistent error reoccurs

    regards

    Martin

    Monday, November 4, 2013 4:54 PM
  • Hi

    DSO library must be installed on every server on which the Project Server application server is running. Please check if it is present in all application servers ?

    http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx

    Monday, November 4, 2013 5:28 PM
  • Project Server and SQL Server are on the same machine

    DSO is installed as per MS requirements doc. 

    SQL Server Analysis Services  is logged on as Local System Account


    Monday, November 11, 2013 10:22 PM
  • When installed the ADO and DSO components, you must use the 2005 SQL components and not the 2008.  Project server does not understand the higher versions.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Tuesday, November 12, 2013 5:08 AM
    Moderator