OLAP Cube error

D

David

While updating the OLAP Cube I am getting the following
error:
VBScript: The operation failed. Your session might have
expired. Reload the page to verify.
Any help appreciated as what this error means & what is
the resolution??
Regards,
David
 
W

William Raymond

Hi David,

This could be one of two things...

1) you are running MSP Client and IE. Exit both, just run IE and make the
change.
2) PWA is not configured to be a trusted site in IE. Go to Tools->Internet
Options, add the URL for the Project Server as a Trusted Site and set the
security settings to low (only for the trusted sites though).

-Bill
 
D

David

I have tried both options listed in 1 & 2. Still resulting
in the same error while updating OLAP Cube.
What is this error about the session? Any other
suggestions?
Regards,
David
 
G

Gary L. Chefetz

David:

Do you have the latest version of MDAC on your workstation? If not upgrade
it.

--

Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.
 
D

DAvid

Now the session error has been cleared after adding roles
& i am getting the following error:
The cube scheduled to be built on 10/15/2003 at 1:14 PM
failed.
(-2147221387) Cannot connect to the Analysis server on
computer 'xyz'. Connection to the server is lost.
How can I restore back the connection.
Any help appreciated?
Regards,
David.
 
W

William Raymond

David,

Reading your post, it sounds like you might have the SQL Analysis Services
installed on another computer. If this is the case, you will need to:

1) Install Decision Support Objects (DSO) on the Project Server. Do this by
running the SQL Server CD, installing Analysis Services and [minimally]
selecting "Decision Support Objects" and "Client Components".
2) Install SP3 (or SP3a) for SQL Server and SQL Server Analysis services on
SQL Server.
3) Install the same service pack level just for SQL Analysis Services on the
Project Server.
4) As Gary mentioned in a previous post, install MDAC on the Project Server
and the SQL Server.

You can download MDAC 2.8 from:

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en

Hope this helps!

-Bill
 
Top