locked
Failed to Build OLAP Cubes RRS feed

  • Question

  • When we attempt to build the cubes, we receive the following message:

    Failed to build the OLAP cubes. Error: The attempt to build the OLAP database on server pma-poc-sql01 failed, the SQL Server Analysis Services Analysis Management Objects (AMO) client software may not be installed on this server, please install/update the client on this server and retry. The underlying exception was: Could not load file or assembly 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

    We did install the "Microsoft Analysis Management Objects" from the page http://www.microsoft.com/downloads/details.aspx?FamilyID=228de03f-3b5a-428a-923f-58a033d316e1&DisplayLang=en.

    Any ideas?
    Gokul Rajan
    Thursday, January 14, 2010 9:51 PM

Answers

  • You do need to restart the Project Service Application on SharePoint Central Administration if you installed the AMO components AFTER Project Server.  If not then the Queue service does not know the components are there - hence the message.

    Let me know if this doesn't fix it for you.  And as Gary says, the account running AS needs data reader access to the reporting db.

    Best regards,

    Brian.
    Friday, January 15, 2010 11:18 PM

All replies

  • Assuming this is for Project Server 2010, have you carefully followed the procedure documented it here: http://technet.microsoft.com/en-us/library/ee662108(office.14).aspx
    Also check the ULS for more details on the exact issue please
    Thursday, January 14, 2010 10:36 PM
  • Hi Chris,

    We have followed the procedure document to the letter; However, we configured these changes on the SQL Server post SharePoint and Project Server 2010 installation and PWA instantiating.  Now the document suggests that this be done prior to installing SharePoint / P14.   Does this affect the configuration and building of OLAP cubes ?


    I shall check the ULS and keep you posted soon.  In the meantime, your thoughts on the above mentioned statement can be of help.

    Gokul R
    Gokul Rajan
    Friday, January 15, 2010 1:03 AM
  • Hello Gokul Rajan,

    My initial guess is that you missed something when setting up the security model.  Make sure that FarmAdmin or installation acount has the right roles set for the reporting database and that the analysis server has been setup.  Don't forgot that the user is included in the SQLserverMSAUser$<server>.

    Also, www.MsProjectExperts.com has published a beta copy of two chapters from one of their new books.  It's been really helpful.  There is a link on their web site to access them.  You got to love those guys for their contributions.

    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    www.WhartonComputer.com
     
    Friday, January 15, 2010 4:22 AM
  • Christophe:

    The TechNet documentation is missing the fact that the CBS uses the OLAP Application Service Account to access the reporting DB and must have reader rights and public role on the RDB if this is a different service account than the Farm Admin.
    Gary Chefetz, MCITP, MCP, MVP MSProjectExperts http://www.msprojectexperts.com FAQs: http://www.projectserverexperts.com BLOG: http://www.projectserverhelp.com
    Friday, January 15, 2010 2:43 PM
  • You do need to restart the Project Service Application on SharePoint Central Administration if you installed the AMO components AFTER Project Server.  If not then the Queue service does not know the components are there - hence the message.

    Let me know if this doesn't fix it for you.  And as Gary says, the account running AS needs data reader access to the reporting db.

    Best regards,

    Brian.
    Friday, January 15, 2010 11:18 PM
  • Thanks to you guys - I will test the last one and reply soon afterwards.


    Gokul Rajan
    Monday, January 18, 2010 2:31 AM
  • Brian:

    The error you get when the AS account doesn't have access is very different and much more explicit.


    Gary Chefetz, MCITP, MCP, MVP MSProjectExperts http://www.msprojectexperts.com FAQs: http://www.projectserverexperts.com BLOG: http://www.projectserverhelp.com
    Monday, January 18, 2010 3:08 PM
  • Hi All,

    I had to say that 'Rebooting' the servers that had AMO installed did make the OLAP CUBE build successfully.   Also, for some reason the SQL SErver service account reverted to NT Network Service, which had to be reset.

    But thanks to all who put their ideas and suggestions, We are glad that this is behind us.

    Good Day all,

    Best Regards -

    Gokul Rajan
    Gokul Rajan
    Wednesday, January 27, 2010 3:13 PM
  • Guys, i hope this helps. We spent ages trying to get analysis services to work on a project server 2010 with sql 2008 r2 implementation...

    Basically, on all wfe's/app servers,

    • install the sql 2008 native client
    • install the sql server analysis management objects

    you can get them from here:

    http://www.microsoft.com/en-us/download/details.aspx?id=8824

    you then need to go to central admin, manage services on server and restart the project application service on all servers in farm (except sql)

    Try again to rebuild the cube in PWA.


    Thursday, August 23, 2012 1:11 PM
  • Forgot to mention, it is also likely you will have to add the farm service account into the SQLServerMSASUser$ local group on the SQL server and add this account also to the security settings in the analysis instance in SQL management studio....
    Thursday, August 23, 2012 1:25 PM
  • Brian, you've done it again!  Saved my A**!  Thanks.

    Tuesday, November 29, 2016 10:32 PM