Cannot build OLAP Cube

O

openjive

Hi,

We have a test environment setup where we have 1 SQL Server that hosts
the ProjectServer and SharePoint databases, 1 SQL Server that hosts the
Analysis Services Repository and Analysis Services and a web server
that hosts the Project Server Web Access Console. The analysis
services repository has been migrated to SQL Server and the OLAP
Administrators group has been granted dbo access on this database.

In this environment we are able to build OLAP cubes successfully
without issue.

When we moved the application to Production against the same setup the
OLAP cube generation failed. It remains stuck in a "Cube building
process was initiated...".

The odd thing is that from the test environment I am able to create
cubes against the test OLAP server and the Production OLAP server. But
from the Production server I never see a file go into the VIEWDROP
folder and there are no errors in the event viewer... it just sits
there. In the test environment I can see the file created in the
VIEWDROP folder.... wait awhile and then it disappears.

Has anyone else encountered anything like this? Is there something I
should be looking at?

Thanks - Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top