OLAP Cube build error

[Sudhakar]

I am getting the following error while I was building the cube. Can someone
help me with this issue. I have Microsoft Project Server 2007 + SQL Server
2005 and needed software for OLAP cubes.

===== Initiating cube build process =====
[7/28/2008 5:51 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/28/2008 5:51 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/28/2008 5:51 PM] Cube build initialization started
[7/28/2008 5:51 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/28/2008 5:51 PM] Cube build session started
[7/28/2008 5:51 PM] Analysis Services session started
[7/28/2008 5:52 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server edprojects. Error:
The connection string to repository needs to be specified in the 9.0 server
properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
Services 9.0).
===== Process Completed =====
[7/28/2008 5:52 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server edprojects. Error: The connection string to repository needs
to be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

Thanks in advance. Kindly help.

regards,
Sudhakar

 

[Dharmesh Patel]

Hi there,

It seems like the latest DSO components may need to be re-installed on all
servers (Web, App, DB):

These include:
• Microsoft SQL Server Native Client (sqlncli.msi)
• Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi)
• Microsoft SQL Server 2005 Backward Compatibility Components
(SQLServer2005_BC.msi)

Please search for these on the Microsoft Site under Feature Pack for
Microsoft SQL Server 2005

Regards,

 

[Gordon]

HI Sudhakar,
You can check this blog post

http://gordonlewis.spaces.live.com/blog/cns!DBF26E9647C0BAED!194.entry

I would suggest you try the option 2 (SQL Database rather than the
repository file)

Cheers,

 

[Sudhakar]

I have followed all the steps mentioned in the following documents.
http://go.microsoft.com/fwlink/?LinkId=93743
I have installed all the needed components. Still I am getting the same
error.
Can someone help me.
regards,
Sudhakar

HI Sudhakar,
You can check this blog post

http://gordonlewis.spaces.live.com/blog/cns!DBF26E9647C0BAED!194.entry

I would suggest you try the option 2 (SQL Database rather than the
repository file)

Cheers,
--
Gordon Lewis
http://gordonlewis.spaces.live.com/

I am getting the following error while I was building the cube. Can someone
help me with this issue. I have Microsoft Project Server 2007 + SQL Server
2005 and needed software for OLAP cubes.

===== Initiating cube build process =====
[7/28/2008 5:51 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/28/2008 5:51 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/28/2008 5:51 PM] Cube build initialization started
[7/28/2008 5:51 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/28/2008 5:51 PM] Cube build session started
[7/28/2008 5:51 PM] Analysis Services session started
[7/28/2008 5:52 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server edprojects. Error:
The connection string to repository needs to be specified in the 9.0 server
properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
Services 9.0).
===== Process Completed =====
[7/28/2008 5:52 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server edprojects. Error: The connection string to repository needs
to be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

Thanks in advance. Kindly help.

regards,
Sudhakar

 

[Sander]

Did you restart the analysis services after all the configuration steps?
If so then there is probably an account trying to acces your repository and
it fails to do so. Could you add the SSP account to access the repository as
db_owner and try again?
You can also check your event logs on the server (where sql/analysis
services are installerd) if any logon denied popsup.

I have followed all the steps mentioned in the following documents.
http://go.microsoft.com/fwlink/?LinkId=93743
I have installed all the needed components. Still I am getting the same
error.
Can someone help me.
regards,
Sudhakar

HI Sudhakar,
You can check this blog post

http://gordonlewis.spaces.live.com/blog/cns!DBF26E9647C0BAED!194.entry

I would suggest you try the option 2 (SQL Database rather than the
repository file)

Cheers,
--
Gordon Lewis
http://gordonlewis.spaces.live.com/

I am getting the following error while I was building the cube. Can someone
help me with this issue. I have Microsoft Project Server 2007 + SQL Server
2005 and needed software for OLAP cubes.

===== Initiating cube build process =====
[7/28/2008 5:51 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/28/2008 5:51 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/28/2008 5:51 PM] Cube build initialization started
[7/28/2008 5:51 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/28/2008 5:51 PM] Cube build session started
[7/28/2008 5:51 PM] Analysis Services session started
[7/28/2008 5:52 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server edprojects. Error:
The connection string to repository needs to be specified in the 9.0 server
properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
Services 9.0).
===== Process Completed =====
[7/28/2008 5:52 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server edprojects. Error: The connection string to repository needs
to be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

Thanks in advance. Kindly help.

regards,
Sudhakar

 

[Chandra sekhar A]

Hi,

I'm getting the same problem. TFS2010 is also installed in the server where the Project Server is installed. So there is SQLServer2005 and SQLServer2008 versions are installed.

I'm not able to Build a cube. the the build process fails with the following error

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server. Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).



Sande wrote:

Did you restart the analysis services after all the configuration steps?
31-Jul-08

Did you restart the analysis services after all the configuration steps
If so then there is probably an account trying to acces your repository and
it fails to do so. Could you add the SSP account to access the repository as
db_owner and try again
You can also check your event logs on the server (where sql/analysis
services are installerd) if any logon denied popsup



:

Previous Posts In This Thread:

OLAP Cube build error
I am getting the following error while I was building the cube. Can someone
help me with this issue. I have Microsoft Project Server 2007 + SQL Server
2005 and needed software for OLAP cubes.

===== Initiating cube build process ====
[7/28/2008 5:51 PM] Cube build request message has been added to the Project
Server queu
===== Verifying and running pre-build server event handler ====
[7/28/2008 5:51 PM] Verifying and running pre-build server event handle
===== Determining database and cube structure ====
[7/28/2008 5:51 PM] Cube build initialization starte
[7/28/2008 5:51 PM] OLAP database and cube structure was determined
successfull
===== Building database and cubes ====
[7/28/2008 5:51 PM] Cube build session starte
[7/28/2008 5:51 PM] Analysis Services session starte
[7/28/2008 5:52 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server edprojects. Error:
The connection string to repository needs to be specified in the 9.0 server
properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
Services 9.0)
===== Process Completed ====
[7/28/2008 5:52 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server edprojects. Error: The connection string to repository needs
to be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0)

Thanks in advance. Kindly help.

regards
Sudhakar

Hi there,It seems like the latest DSO components may need to be re-installed
Hi there

It seems like the latest DSO components may need to be re-installed on all
servers (Web, App, DB)

These include
??? Microsoft SQL Server Native Client (sqlncli.msi
??? Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi
??? Microsoft SQL Server 2005 Backward Compatibility Components
(SQLServer2005_BC.msi

Please search for these on the Microsoft Site under Feature Pack for
Microsoft SQL Server 200

Regards
--
Dharmesh Pate
Project Server Consultan

:

RE: OLAP Cube build error
HI Sudhakar
You can check this blog pos

http://gordonlewis.spaces.live.com/blog/cns!DBF26E9647C0BAED!194.entr

I would suggest you try the option 2 (SQL Database rather than the
repository file

Cheers
--
Gordon Lewi
http://gordonlewis.spaces.live.com

:

RE: OLAP Cube build error
I have followed all the steps mentioned in the following documents.
http://go.microsoft.com/fwlink/?LinkId=9374
I have installed all the needed components. Still I am getting the same
error.
Can someone help me.
regards,
Sudhakar

:

Did you restart the analysis services after all the configuration steps?
Did you restart the analysis services after all the configuration steps?
If so then there is probably an account trying to acces your repository and
it fails to do so. Could you add the SSP account to access the repository as
db_owner and try again?
You can also check your event logs on the server (where sql/analysis
services are installerd) if any logon denied popsup.





:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Build A Self-Caching ASP.NET Web Site Thumbnail Control
http://www.eggheadcafe.com/tutorial...571-cdc4eb38f3c1/build-a-selfcaching-asp.aspx

 

[Rainiero Dinarte]

Hi Chandra, check this out: http://technet.microsoft.com/en-us/library/cc197552.aspx, hope this helps!



Chandra sekhar A wrote:

Error in buliding a cube in Project server 2007
09-Dec-09

Hi,

I'm getting the same problem. TFS2010 is also installed in the server where the Project Server is installed. So there is SQLServer2005 and SQLServer2008 versions are installed.

I'm not able to Build a cube. the the build process fails with the following error

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server. Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
JavaScript - Modal Dialog Box - Cross Browser
http://www.eggheadcafe.com/tutorial...c8-0f561ff9f681/javascript--modal-dialog.aspx