OLAP Cube build no longer works

K

Kris

After rebooting our server, the OLAP cube is no longer able to be
built and generates an Application Log Error (see below). Prior to
the reboot, the cube was working fine. We are running a single server
configuration.

How can we get our OLAP cube working again?
What should we look into?

Application Log Error
=====================
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x80010108
Description: Error Information: Method '~' of object '~' failed
Additional Information: An error occured processing the following view
:-
<ViewsDropData>

<ProjectData>

<EntProjectName><![CDATA[resglobal]
]></EntProjectName>


<EntResourceIDList>*</EntResourceIDList>


<EntResourceStartDate>1/1/2002</EntResourceStartDate>


<EntResourceFinishDate>4/23/2005</EntResourceFinishDate>


<BuildCubeRequest><CubeUpdate><CubeStart>20020401</CubeStart><CubeFinish>20050422</CubeFinish><Connection>Provider=SQLOLEDB;User
ID=ProjectServerUser; Password=psu;Persist Security Info=False;Initial
Catalog=ProjectServer;Data
Source=OurServer</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB;User
ID=ProjectServerUser; Password=psu;Persist Security Info=False;Initial
Catalog=ProjectServer;Data
Source=OurServer</DSOConnection><Server>OurServer</Server><CubeDB>Staffing</CubeDB><CubeDesc>Enterprise
Resources</CubeDesc></CubeUpdate></BuildCubeRequest>

</ProjectData>

<OrgGuid>projectserver</OrgGuid>

<BasePath>projectserver</BasePath>

<TimeStamp>10/23/2003 10:58:30 AM</TimeStamp>

</ViewsDropData>
 
G

Gary L. Chefetz

Kris:

Did the password for the OLAPAdmin account expire or did the account
otherwise become locked out?

--

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.

Kris said:
After rebooting our server, the OLAP cube is no longer able to be
built and generates an Application Log Error (see below). Prior to
the reboot, the cube was working fine. We are running a single server
configuration.

How can we get our OLAP cube working again?
What should we look into?

Application Log Error
=====================
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x80010108
Description: Error Information: Method '~' of object '~' failed
Additional Information: An error occured processing the following view
:-
<ViewsDropData>

<ProjectData>

<EntProjectName><![CDATA[resglobal]
]></EntProjectName>


<EntResourceIDList>*</EntResourceIDList>


<EntResourceStartDate>1/1/2002</EntResourceStartDate>


<EntResourceFinishDate>4/23/2005</EntResourceFinishDate>
Click to expand...
ID=ProjectServerUser; Password=psu;Persist Security Info=False;Initial
Catalog=ProjectServer;Data
Click to expand...
 
K

Kris

Gary,

How would I check for these conditions?
The password for the OLAPAdmin account expired
The account becomes locked out

Thanks in advance,

- Kris
 
G

Gary L. Chefetz

Kris:

Is this the only error you're seeing in the application log? Did anyone
apply any changes to IIS directory security? Get someone to check the
Project Server Services on the server and look at the component services and
make sure that the OLAP COM object is running and happy. Please don't ask me
to give you step-by-step instructions on each of these. You can also try
stopping and restarting IIS or even the rebooting the server to see if that
has any effect. This will at least eliminate the possibility you're
experiencing a server hiccup.

--

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.
 
Top