none
Project Server 2019 OLAP cube build error RRS feed

  • Question

  • [15/01/2020 14:26] Failed to create the OLAP cubes. Error: Failed to create the OLAP database on the spp2019msp001 server. SQL Server Analysis Services (AMO) client software (Analysis Management Objects) may not be installed on this server. Please install / update the client on this server and try again. The underlying exception was: Unable to load file or assembly 'Microsoft.AnalysisServices, Version = 13.0.0.0, Culture = neutral, PublicKeyToken = 89845dcd8080cc91' or one of its dependencies. The specified file can not be found.
    Wednesday, January 15, 2020 1:31 PM

All replies

  • Hi,

    The message says that AMO is not installed.

    SQL Server Analysis Management Objects (AMO) must be installed on each application server in the farm.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Wednesday, January 15, 2020 3:06 PM
    Moderator
  • Analysis service est installé sur le serveur. 
    Wednesday, January 15, 2020 3:10 PM
  • @Guillaume Do you know where to download the AMO?  Searches have not resulted in finding the files needed.  
    Thursday, October 29, 2020 7:06 PM
  • @Guillaume Do you know where to download the AMO? 

    You get it from SQL Server feature pack: Download SQL Server extended features and tools  => Analysis Services


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, October 30, 2020 7:32 AM
  • I was able to download and install all the files from the feature pack.  We are still getting the same error we did previously.  Just to verify...I installed all the 64 bit files.  Any further direction would be much appreciated.  This is Project Server 2019 and SQL 2017 for reference.

    -Rod

    Friday, October 30, 2020 5:49 PM