OLAP Cube failure

[Tru]

Hi,

Recently we started getting OLAP Cube failures. Cube is
genterated every night. Last sucessful cube built was
about 2 weeks ago. I am running IIS Server with analysis
server and a SQL server is on a different box. Below is
the event log errors I am getting.

The cube scheduled to be built on 7/26/2004 at 5:19 AM
failed.

(-2147221411)

Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: Error Information: Invalid procedure call or
argument
Additional Information: An error occured processing the
following view :-

<ViewsDropData>

</EntProjectName>

<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>1/1/2002</EntResourceStartDat
e>

<EntResourceFinishDate>8/15/2006</EntResourceFinish
Date>

<BuildCubeRequest><CubeUpdate><CubeStart>20020101</
CubeStart><CubeFinish>20060814</CubeFinish><Connection>Prov
ider=SQLOLEDB;User ID=MSProjectServerUser;
Password=^6Pm8zwyHeY!N4CMnr;Persist Security
Info=False;Initial Catalog=ProjectServer;Data
Source=wmghpwmsprop03</Connection><DBType>0</DBType><DSOCon
nection>Provider=SQLOLEDB;User ID=MSProjectServerUser;
Password=^6Pm8zwyHeY!N4CMnr;Persist Security
Info=False;Initial Catalog=ProjectServer;Data
Source=wmghpwmsprop03</DSOConnection><Server>wmghpwmsprop03
</Server><CubeDB>IMSS_CUBE_1</CubeDB><CubeDesc>IMSS
Portfolio OLAP
CUBE</CubeDesc></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>7/29/2004 4:29:24 AM</TimeStamp>
</ViewsDropData>

 

[rcool]

Hi Tru,

Have you any fix for this problem. Actually i am also getting the sam
problem in my default cube.

*Hi,

Recently we started getting OLAP Cube failures. Cube is
genterated every night. Last sucessful cube built was
about 2 weeks ago. I am running IIS Server with analysis
server and a SQL server is on a different box. Below is
the event log errors I am getting.

The cube scheduled to be built on 7/26/2004 at 5:19 AM
failed.

(-2147221411)

Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: Error Information: Invalid procedure call or
argument
Additional Information: An error occured processing the
following view :-

<ViewsDropData>

<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>1/1/2002</EntResourceStartDat
e>

<EntResourceFinishDate>8/15/2006</EntResourceFinish
Date>

<BuildCubeRequest><CubeUpdate><CubeStart>20020101</
CubeStart><CubeFinish>20060814</CubeFinish><Connection>Prov
ider=SQLOLEDB;User ID=MSProjectServerUser;
Password=^6Pm8zwyHeY!N4CMnr;Persist Security
Info=False;Initial Catalog=ProjectServer;Data
Source=wmghpwmsprop03</Connection><DBType>0</DBType><DSOCon
nection>Provider=SQLOLEDB;User ID=MSProjectServerUser;
Password=^6Pm8zwyHeY!N4CMnr;Persist Security
Info=False;Initial Catalog=ProjectServer;Data
Source=wmghpwmsprop03</DSOConnection><Server>wmghpwmsprop03
</Server><CubeDB>IMSS_CUBE_1</CubeDB><CubeDesc>IMSS
Portfolio OLAP
CUBE</CubeDesc></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>7/29/2004 4:29:24 AM</TimeStamp>
</ViewsDropData>

-
rcoo

 

[Guest]

Hi Rcool,

In our instance we found the STS account had reached
maximum group assignment. After removing some of those
groups, and started the STS component. Cube started to
build again.

Tru