Unable to create OLAP Cube

L

Langhorne

I got the OLAP build process going with what appears to be a successful
message ("The cube building process was initiated on ..."). But Analysis
Manager doesn't show it under the server name, just good old FoodMart 2000.
As a result I can't analyze resources. PS2003 with all current SPs (I
think). Any clues?
Thanks in advance.
 
M

Marc Soester

Langhorn,
from what I understand, the cube message does actually not say that it has
run successfully, it only tells you that it has been initiated. There are
several reasons why this could happen. lets try to elimite them
1. go to Analysis Server and delete the Actual Project Server connection
2. go into PWA and try to rebuild
3. This should rebuild your cube

If not you will need to check the Server event logs and see if there are any
error messages.
Please let me know how you go
 
L

Langhorne

Thanks Marc. I don't think there's an Actual Project Server connection to
delete. Under Analysis Servers there's just the server name, and under that,
"FoodMart 2000". Nothing else. So it seems like step 1 has already
occurred(!), and steps 2-3 don't recreate it. You're right, the message just
says the cube building process was initiated. It never updates with any
other success or error response. Any other thoughts?

- L
 
L

Langhorne

The plot thickens. I found a KB link that suggested i look at the event log
and discovered a permission problem, which evidently is preventing anything
else from occuring (no OLAP cube, no XML file in \viewdrop, no vwnotify task
running). So now I'm off in a whole new direction chasing this down. I
thought I had set up each and every account exactly per the instructions, but
evidently not. Any hints are welcome, otherwise stay tuned...

- L
 
M

Marc Soester

Hi Langhorne,

Yes that would ahve been my next step to look at the event logs, which you
did. Have a look at the Project Server service account you used when you
installed Project Server. This is the account that builds the OLAP Cube. Make
sure that it is in the OLAP Administrator on you application server and DB
Server ( should you have 2 servers).

That should bring you closer to your build :)
Let me know how it went
 
L

Langhorne

Thanks for staying with me on this. The service account had not been in the
OLAP Admin group, but no change after adding it. Unless it takes a while to
propagate. I notice that the event log entry says "User NT AUTHORITY\LOCAL
SERVICE", logged in from computer ..., does not have administrative
permissions on the server, but tried to perform an administrative operation
 
M

Marc Soester

I am not sure to be honest. The first thing I would do is actually give the
service account the appropriate admin rights to see if the Cube builds. If
this is the case, we can have a look into changing the service account to the
PS Account.
Let me know if adding the security builds the cube.
Thanks
 
L

Langhorne

Well, I added the local account I had created for WSS & Analysis Services
access to the local OLAP administrators group. Restarted the OLAP service.
No luck.

BTW, I've tried installing the View Effective Rights utility to see if that
sheds any light on this, but I'm flummoxed. It doesn't seem to have any
actual instructions on what to do after installation. Do you think that's
worth pursuing?

Thanks again...

- L
 
M

Marc Soester

Sorry Langhorne, I have not been using the effective rights tool. Do you have
a one or 2 server setup? ( Applciation and DB Server or singleserver?)
 
L

Langhorne

Single Server.

BTW the effective rights tool didn't seem to shed any light on the subject.
All the expected permissions and rights seem to be in place.
 
M

Marc Soester

Hi Langhorne,

Sorry mate, there is only one more "stab in the dark" that I can come up
with for now, that is Go the your server "Program Files" Project Server and
find the "Drop" folder. make sure that your sevice account has full access to
this folder.

Let me know if this did something, and I will do some more investigation. I
have a strong feeling that it has something to do with security.
 
R

Robert

Have you tried re-running PSCOMPlus? What kind of security and
permissions do you have on the view drop folder? Has this ever
worked?
 
L

Langhorne

Well, as it happens at Microsoft's suggestion I ran PSCOM+ yesterday and
added the domain admin account, and that did the trick. I still don't
understand why that was necessary but I'm happy enough for now. No, it had
never worked, BTW. Thanks, and thanks to you Marc also.

- L
 
Top