error in creating OLAP cube

M

Mike

Hi everybody !
I've got MS Project 2002 Server, SQL and OLAP Server with SP3a apllied.
Every time I try to create OLAP cube on PWA page using fixed date range
exceeded current year I failed. The cube isn't created and you can find 3
following errors in the Application Event Log:

error 1:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 2003-10-14
Time: 14:38:24
User: NT AUTHORITY\SYSTEM
Computer: TETA-PROJECT
Description:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3071
Description: Error #: -2147221411 Desc. :

error 2:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 2003-10-14
Time: 14:38:24
User: NT AUTHORITY\SYSTEM
Computer: TETA-PROJECT
Description:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x80004005
Description: Failed to generate OLAP Cube for the following Request :
<BuildCubeRequest><CubeUpdate><CubeStart>19990101</CubeStart><CubeFinish>200
51231</CubeFinish><Connection>Provider=SQLOLEDB;User ID=...;
Password=...;Persist Security Info=False;Initial Catalog=TETA;Data
Source=TETA-PROJECT</Connection><DBType>0</DBType><DSOConnection>Provider=SQ
LOLEDB;User ID=...; Password=...;Persist Security Info=False;Initial
Catalog=TETA;Data
Source=TETA-PROJECT</DSOConnection><Server>TETA-PROJECT</Server><CubeDB>CUBE
_3</CubeDB><CubeDesc></CubeDesc></CubeUpdate></BuildCubeRequest>

error 3:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 2003-10-14
Time: 14:38:24
User: NT AUTHORITY\SYSTEM
Computer: TETA-PROJECT
Description:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: Error Information:
Additional Information: An error occured calling
CallViewGenerator(projectserver, projectserver, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>1999-01-01</EntResourceStartDate>
<EntResourceFinishDate>2006-01-01</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>19990101</CubeStart><CubeFinish>200
51231</CubeFinish><Connection>Provider=SQLOLEDB;User ID=...;
Password=...;Persist Security Info=False;Initial Catalog=TETA;Data
Source=TETA-PROJECT</Connection><DBType>0</DBType><DSOConnection>Provider=SQ
LOLEDB;User ID=...; Password=...;Persist Security Info=False;Initial
Catalog=TETA;Data
Source=TETA-PROJECT</DSOConnection><Server>TETA-PROJECT</Server><CubeDB>CUBE
_3</CubeDB><CubeDesc></CubeDesc></CubeUpdate></BuildCubeRequest>
</ProjectData>)

Do you have any ideas ?
Best regards
Mike
 
G

Gary Chefetz MVP

Mike:

It's likely that permissions are set incorrectly on the
ViewDrop folder. I'm on the road and don't have my link
list with me, however there is a KB article that covers
these setting and it is well described in the installation
guide.

Gary

-----Original Message-----
Hi everybody !
I've got MS Project 2002 Server, SQL and OLAP Server with SP3a apllied.
Every time I try to create OLAP cube on PWA page using fixed date range
exceeded current year I failed. The cube isn't created and you can find 3
following errors in the Application Event Log:

error 1:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 2003-10-14
Time: 14:38:24
User: NT AUTHORITY\SYSTEM
Computer: TETA-PROJECT
Description:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3071
Description: Error #: -2147221411 Desc. :

error 2:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 2003-10-14
Time: 14:38:24
User: NT AUTHORITY\SYSTEM
Computer: TETA-PROJECT
Description:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x80004005
Description: Failed to generate OLAP Cube for the following Request :
<BuildCubeRequest><CubeUpdate><CubeStart>19990101</CubeSta
ID=...;
Password=...;Persist Security Info=False;Initial Catalog=TETA;Data
Source=TETA-
Click to expand...
PROJECT said:
LOLEDB;User ID=...; Password=...;Persist Security Info=False;Initial

quest>

error 3:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 2003-10-14
Time: 14:38:24
User: NT AUTHORITY\SYSTEM
Computer: TETA-PROJECT
Description:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: Error Information:
Additional Information: An error occured calling
CallViewGenerator(projectserver, projectserver, -1,
Click to expand...
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>1999-01-01</EntResourceStartDate>
<EntResourceFinishDate>2006-01-01</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>19990101</CubeSta
rt> said:
51231</CubeFinish><Connection>Provider=SQLOLEDB;User
Click to expand...
ID=...;
Password=...;Persist Security Info=False;Initial Catalog=TETA;Data
Source=TETA-
Click to expand...
 
M

Mike

What's more strange: cube is built OK in different settings but failed only
with period of time ended in the far future (2005).
Is there any limitation to time ?
One short remark about ViewDrop folder: aren't its permissions set once
during the setup of Project Server ? I wonder if it's necessary to change
them...

Mike
 
Top