Export (0) Print
Expand All
Expand Minimize

Project Cube Build Service OLAP Processing Failure

 

Applies to: Project Server 2013, Project Server 2010

Topic Last Modified: 2013-12-18

Element ID / Rule Name:   Project_Cube_Build_Service_OLAP_Processing_Failure

Summary:   After the Microsoft Project Server cube structures are built, the computer that is running Microsoft SQL Server Analysis Services (SSAS) processes the cubes in order to obtain the data from its data source. The data source is the associated Project Server Reporting database. This processing also obtains any customized data that was added to the cubes.

Cause:   Several things could cause the SQL Server Analysis Services database processing to fail. The most common case is that the Analysis Services server does not have access to the data in the Project Server Reporting database. This could be the case if the following are true:

  • The Reporting database and the Analysis Services server are on separate computers

  • The instance of SQL Server Analysis Services is not running under an account that has at least read access to the Reporting database

This might also occur if there is a custom extension to the cubes that attempts to read data from a source without having sufficient permission.

Possible resolutions include the following:

  • You can use the ULS logs to verify that the processing failure is caused by permission problems.

  • To resolve permission problems:

    1. In the computer where Analysis Services server is running, ensure that the account that is used by the computer that is running SQL Server Analysis Services is a Windows domain account instead of a service account, such as Local System.

    2. Ensure that this account has read access to the Project Server Reporting database from the site on which you want to build cubes. If there are multiple sites building cubes on the same Analysis Services server, the Windows domain account that is used by SQL Server Analysis Services should have read access to all corresponding Project Server Reporting databases.

  • If processing fails but the credentials are configured correctly, go directly to the Analysis Services server and manually attempt to process the database. This action will give you detailed information about where the failure is occurring.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft