Cube building failing

[ghostme]

Hi guys I just have to re-send this thread. I have a two server configuration


Project server(sp1, infrastructure update)

Sql server(sp2)

However, creating cubes has not been successful because I keep the error.

'ActiveX component can't create object'

Has anyone tried building cubes on this type of configuration before and if
you were successful please share your experience.

Thanks guys

 

[Gary L. Chefetz]

ghostme:

The error you cite is the type you'd get when trying to create a data
analysis view, not build a cube. You need to post the actual cube build
errors to diagnose this problem.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[ghostme]

Hi Gary,

This error occurs when I try to build the cubes. Ok, this is the full errors

Failed to connect to analysis server:ActiveX component can't create object'

Once again I have done all that is stated in the Microsoft documentation of
creating cubes in project server using Sql ServerAnalysis services 2005.

 

[Gary L. Chefetz]

ghostme:

At least cut and past the chain of events from the cube build status window
and post it here.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[Brian H]

Have you looked at this article:
http://technet.microsoft.com/en-us/library/cc197552.aspx

It details all the components needed for Data Analysis / OLAP cube building
& viewing. There are items that need to be installed on the App server, SQL
server, as well as the local PC when using PWA.

Hope this helps,
Brian

 

[ghostme]

Hi Gary this is the chain of events in the build status windows. For Brain I
have gone through that article line by line and I know I have the components
installed correctly.

===== Initiating cube build process =====
[9/27/2008 10:00 AM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[9/27/2008 10:00 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[9/27/2008 10:00 AM] Cube build initialization started
[9/27/2008 10:00 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[9/27/2008 10:00 AM] Cube build session started
[9/27/2008 10:01 AM] Analysis Services session started
[9/27/2008 10:01 AM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server sqlserver. Error:
ActiveX component can't create object
===== Process Completed =====
[9/27/2008 10:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to connect to the
Analysis Services server sqlserver. Error: ActiveX component can't create
object

 

[ghostme]

Hi Guys I have finally gotten this sorted. Now, taken a cue from brain smith

http://blogs.msdn.com/brismith/arch...gainst-sql-server-2005-analysis-services.aspx
post on the website.

I loaded the entire client tools of sql server 2005. However, when I did
that I ran into some other errors that had to do the OLAP storage engine of
the AS server.

Now I then installed sp2 on the application server that had the client tools
because the AS server itself has been patch with sp2. Everything then worked
as it is supposed to.

I do suggest that Microsoft should update their kb so that others can learn.

Anyways, thanks alot guys for your support.

If you have all the components installed correctly, then the points of
failure here seem to be authentication. Does the SSP account have all it
needs for access?

Is it a member of the 2005MSOLAPUser local user group on the AS machine?
Did you make it a member of the Analysis Services Server Role in SQL
Analysis Services?
What about the repository? Did you create one? Does the SSP have the
necessary dbo rights to it?




--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

Hi Gary this is the chain of events in the build status windows. For Brain
I
have gone through that article line by line and I know I have the
components
installed correctly.

===== Initiating cube build process =====
[9/27/2008 10:00 AM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[9/27/2008 10:00 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[9/27/2008 10:00 AM] Cube build initialization started
[9/27/2008 10:00 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[9/27/2008 10:00 AM] Cube build session started
[9/27/2008 10:01 AM] Analysis Services session started
[9/27/2008 10:01 AM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server sqlserver. Error:
ActiveX component can't create object
===== Process Completed =====
[9/27/2008 10:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to connect to the
Analysis Services server sqlserver. Error: ActiveX component can't create
object

Have you looked at this article:
http://technet.microsoft.com/en-us/library/cc197552.aspx

It details all the components needed for Data Analysis / OLAP cube
building
& viewing. There are items that need to be installed on the App server,
SQL
server, as well as the local PC when using PWA.

Hope this helps,
Brian


:

ghostme:

At least cut and past the chain of events from the cube build status
window
and post it here.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


Hi Gary,

This error occurs when I try to build the cubes. Ok, this is the full
errors

Failed to connect to analysis server:ActiveX component can't create
object'

Once again I have done all that is stated in the Microsoft
documentation
of
creating cubes in project server using Sql ServerAnalysis services
2005.

:

ghostme:

The error you cite is the type you'd get when trying to create a
data
analysis view, not build a cube. You need to post the actual cube
build
errors to diagnose this problem.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


Hi guys I just have to re-send this thread. I have a two server
configuration


Project server(sp1, infrastructure update)

Sql server(sp2)

However, creating cubes has not been successful because I keep the
error.

'ActiveX component can't create object'

Has anyone tried building cubes on this type of configuration
before
and
if
you were successful please share your experience.

Thanks guys