Building the OLAP cube for Project Server 2013

I am running SQL 2012 as my Database Server and Analysis Server. Note: SQL Server 2008 R2 Analysis Management Objects (AMO) is  installed on each application server in the farm before your proceed with the below.

  1. Grant the Farm admin Account the Analysis Server Administrator privilege.

  2. Grant the Project Web App database access (PS DataAccess Role) to the analysis services Service account.

  3. In SharePoint Central Administration under Application management, click manage Service Applications
  4. Click project server Service application
  5. In the drop down box for the project server instance click on Manage

  6. You should now see the following interface

  7. Click on OLAP Database Management

    You should see the next screen

  8. Click on the Database Name and enter the details

  9. You can specify the Project Server OLAP details on this screen

I encountered a couple of errors with the Cube build Server queue Error 1 ===== Process Completed ===== [4/30/2013 7:54 PM] Failed to build the OLAP cubes. Error: The attempt to build the OLAP database on server PS2013 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. Resolution In its current form the SQL Server Analysis Services Analysis Management Objects (AMO) for SQL 2012 was not supported. I had to install the AMO for SQL 2008 R2 after reading. NOTE:
This could change down the track. So please check with latest Published material from Microsoft. Refer: http://blogs.msdn.com/b/brismith/archive/2012/11/12/project-server-2013-requirements-to-build-an-olap-cube.aspx
Server queue Error 1 Failed to build the OLAP cubes. Error: Failed to connect to the Analysis Services server PS2013. Error: Deserialization failed: Requested value ‘EnterpriseCore64’ was not found.

  • EnterpriseCore64 (as mine was)
  • EnterpriseCore
  • BusinessIntelligence64
  • BusinessIntelligence

Resolution

I Installed the CU hotfix and this fixed the issue…

Download Cumulative Update http://support.microsoft.com/kb/2679368

The Cumulative Update itself can be found at http://support.microsoft.com/kb/2679368 – Cumulative update package 1 for SQL Server 2012.

If you encounter some other errors you may want to check Brian Smiths blog here http://blogs.msdn.com/b/brismith/archive/2012/07/03/a-new-sql-server-and-some-different-cube-building-errors.aspx

Server queue Error 3 [11/7/2013 3:18 PM] Verifying and running pre-build server event handler ===== Determining database and OLAP database structure ===== [11/7/2013 3:18 PM] Cube build initialization started ===== Building database and cubes ===== [11/7/2013 3:18 PM] Cube build session started ===== Process Completed ===== [11/7/2013 3:19 PM] Failed to build the OLAP cubes. Error: Failed to connect to the Analysis Services server SPDEVDB01. Error: A connection cannot be made. Ensure that the server is running Resolution This could occur because the firewall on the DB Server is preventing accessing the Analysis services ports. Create an inbound allow rule in the firewall as in diagram below for the following ports 2382, 2383

Cube build Error 4 (I recently faced this error when recently configuring Cube)

[6/03/2014 11:10 AM] Failed to build the OLAP cubes. Error: The attempt to build the OLAP database on server SQL Server 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

Resolution

I installed SQLSERVER2008_ASAMO10_amd64.msi whch can be download link is here. This worked for me.

<<Update 06/03/2014>>

Cube build Error 5 (I recently faced this error when recently configuring Cube)

===== Process Completed =====

[6/03/2014 11:10 AM] Failed to build the OLAP cubes. Error: Failed to process the Analysis Services database Cube on the EPM server. Error: Errors in the back-end database access module. The provider ‘SQLNCLI10’ is not registered.

The following system error occurred:  Class not registered

After analysis I found the cube refused to build although:

  • I installed the SQLCLI10 client and on the Web and App servers.
  • Installed the required SQL Analysis Management Objects on the web and App server
  • I restarted the Project Queue and Event service
  • I gave Analysis services account DataRead Permission only to the Project Server Database (for reporting)

Resolution

I was only able to resolve the issues by downloading SQL Native client 10.x from http://www.microsoft.com/en-us/download/details.aspx?id=30440

The file name sqlncli_amd64.msi

I installed this on the SQL Server 2012 Analysis Server. I was a bit apprehensive installing this on the SQL Analysis Server, bit this was the only way I was able to get the cube to build.

Blogged by: Gordon


Recent Comment

Leave Reply

Hey, so you decided to leave a comment! That’s great. Just fill in the required fields and hit submit. Note that your comment will need to be reviewed before it’s published Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>