Project Cube Build Service Decision Support Object is not installed

 

Applies to: Project Server 2013, Project Server 2010

Topic Last Modified: 2013-12-18

Element ID / Rule Name:   Project_Cube_Build_Service_Decision_Support_Object_Is_Not_Installed

Summary:   The Cube Build Service requires the Decision Support Object (DSO) component of SQL Server Analysis Services be installed on the Microsoft Project Server application server from which the Project Server farm connects to the Analysis Services server to generate the cubes structure.

Cause:   The DSO component of Analysis Services is not installed on the Project Server application server.

Possible resolutions include the following:

• Use the Analysis Services 2000 setup wizard to install the DSO component on the Project Server application server. Note that you do not have to install the Analysis Services, only the DSO component. In the setup wizard, the DSO component is known as the "Client Component."

• If the cubes will be built on SQL Server 2005 Analysis Services, you have to install the following components on the application server:

  • Microsoft SQL Server Native Client (installed by using sqlncli.msi).

  • Microsoft SQL Server 2005 Management Objects Collection (installed by using sqlserver2005_xmo.msi).

  • Microsoft SQL Server 2005 Backward Compatibility Components (installed by using SQLServer2005_BC.msi).

  Note

  These components can be downloaded from the Feature Pack for Microsoft SQL Server 2005 - April 2006 release (or newer). For additional configuration information, see Deployment for Project Server 2010.

• Move the Content and Delete the old ProjectBICenter site. And then re-create PWA site.