Cube Building

[Chris Hughes(UK)]

Hi

I have setup Analysis Services done all the DS09 Olap stuff.
Installed all the components like
Setup the msmdrep.mdb.
I have done all the connection settings.
DSO\ RemoteLocksDirectory
DSO\ RemoteRepositoryConnectionString
DSO\ RepositoryConnectionString
Installed all the other sql addons you need like
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Backward Compatibility Components
Set the DS09 share name to MSOLAPREPOSITORY$

Everytime I try to build a cube I am getting the following error.

===== Initiating cube build process =====
[3/26/2007 5:24 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[3/26/2007 5:24 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[3/26/2007 5:24 PM] Cube build initialization started
[3/26/2007 5:24 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[3/26/2007 5:24 PM] Cube build session started
[3/26/2007 5:25 PM] Analysis Services session started
[3/26/2007 5:25 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server sbanb-esprj07.
Error: Path not found
===== Process Completed =====
[3/26/2007 5:25 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server sbanb-esprj07. Error: Path not found


Any ideas?

Chris Hughes

 

[Brian Tkatch]

Hi

I have setup Analysis Services done all the DS09 Olap stuff.
Installed all the components like
Setup the msmdrep.mdb.
I have done all the connection settings.
DSO\ RemoteLocksDirectory
DSO\ RemoteRepositoryConnectionString
DSO\ RepositoryConnectionString
Installed all the other sql addons you need like
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Backward Compatibility Components
Set the DS09 share name to MSOLAPREPOSITORY$

Everytime I try to build a cube I am getting the following error.

===== Initiating cube build process =====
[3/26/2007 5:24 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[3/26/2007 5:24 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[3/26/2007 5:24 PM] Cube build initialization started
[3/26/2007 5:24 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[3/26/2007 5:24 PM] Cube build session started
[3/26/2007 5:25 PM] Analysis Services session started
[3/26/2007 5:25 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server sbanb-esprj07.
Error: Path not found
===== Process Completed =====
[3/26/2007 5:25 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server sbanb-esprj07. Error: Path not found


Any ideas?

Chris Hughes

I'm no expert, but i've just been dealing with related issues. Perhaps
if you answer these questions, someone can help you better.

Is Analysis Services on the same box as Project Server?
Have you setup PSComPlus.exe?
Have you setup CONNINFO.EXE?
Have you added the login to the OLAP Administrators group?

B.