OLAP Cubes never get built

[Greg]

Hi,

We recently migrated our SQL Server Project Server and WSS Databases to
new SQL Servers as well as the OLAP cubes. (Project Server and WSS
databases are on one server, OLAP cubes are on another).

Everything went smoothly except that we have no OLAP cube generation
any more. It just hangs and keeps saying that the cube is currently
being built. I have even tried narrowing the dataset down to 1 day and
this does not do anything.

Here is what we have done;

1 - The Analysis Service repository has been migrated to SQL Server and
the OLAP Admininstrators group (containing the msps user used for the
COM+ services on the MSPS server) has been granted dbo rights to that
database.

2 - The VIEWDROP folder; when the OLAP build process starts, I see the
XML file go in, then I see it go out.

3 - There are no errors in any of the event logs on either the OLAP
Server or the MPS Server.

4 - I have tried renaming the OLAP Cubes different names.

5 - I have restarted the MPS Services.

When I watch what is happening on the OLAP server through SQL Profiler,
I can see activity... but then it just stops.

Anyone with an idea how to get this work... I've gone through the
installation guide a couple of times, the implementation is exactly the
same as the previous one.

Thank you.

Greg Thomas

 

[FaisalM]

Check the event viewer logs relevant to this issue (if any) & post those here.

Provide some details on your previous & current environment.

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject

My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[Greg]

Sorry,

That is the last thing I forgot... there are no errors in the event
log.

None whatsoever.

Greg

 

[Ray McCoppin]

Turn on auditing for object access failures on the SQL and OLAP server. See
if there is a access failures in the log.

 

[Gary L. Chefetz [MVP]]

Your OLAP Admin account is likely failing database authentication early on
in the process. Did you add it to the Migrated Repository?

 

[Greg]

The OLAP account is in the OLAP Administrators Group which has dbo
permissions to the migrated AnalysisRepository.

 

[Gary L. Chefetz [MVP]]

Well it certainly would be interesting to see what in's the profiler at the
point the activity stops.