OLAP Cube generation

9 views
Skip to first unread message

Vardy@discussions.microsoft.com Jonathan Vardy

unread,
Dec 7, 2005, 2:02:02 AM12/7/05
to
Hi,

We've just installed Project Server 2003 (single machine setup) in the
following setup:

Windows Server 2003 SP1
SQL Server 2000
SQL Server SP4
Analysis Server
Analysis Server SP4
Project Server 2003
Project Server SP1
Project Server MUI Dutch
Project Server MUI SP2

All works fine except the cube generation always fails. I've checked the
viewdrop folder settings, the OLAP administrator rights, the COM+ identity
and they are all correct.

We've synced 6 users from the AD which had some periods and comma's so I
removed those just in case but this didn't help either. I've changed the
setting to a number of different ranges but that doesn't help.

Here are the errors from the event log:
Component: Views Notification Service
File: C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 127
Error Number: 0x800a0005
Description: <Description><![CDATA[View scheduler received error while
scheduling views]]></Description>
___________________________________
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[Error Information: Invalid procedure call
or argument
Additional Information: An error occured processing the following view :-
<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2005-12-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-12-29T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20051201</CubeStart><CubeFinish>20051229</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=BFEPM1</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=BFEPM1</DSOConnection><Server>BFEPM1</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>C75EF86D-4213-45AD-998D-4A06C2013AA1</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-12-01T10:00:16</TimeStamp>
</ViewsDropData>]]></Description>
Component: Views Notification Service
File: C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 132
Error Number: 0x800a0005
Description: <Description><![CDATA[The views processor failed to process the
following document:
<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2005-12-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-12-29T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20051201</CubeStart><CubeFinish>20051229</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=BFEPM1</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=BFEPM1</DSOConnection><Server>BFEPM1</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>C75EF86D-4213-45AD-998D-4A06C2013AA1</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-12-01T10:00:16</TimeStamp>
</ViewsDropData>]]></Description>
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[Error Information: Invalid procedure call
or argument
Additional Information: An error occured processing the following view :-
<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2005-12-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-12-29T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20051201</CubeStart><CubeFinish>20051229</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=BFEPM1</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=BFEPM1</DSOConnection><Server>BFEPM1</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>C75EF86D-4213-45AD-998D-4A06C2013AA1</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-12-01T10:00:16</TimeStamp>
</ViewsDropData>]]></Description>
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2005-12-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-12-29T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20051201</CubeStart><CubeFinish>20051229</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=BFEPM1</DSOConnection><Server>BFEPM1</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>C75EF86D-4213-45AD-998D-4A06C2013AA1</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 881
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1448
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 110
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1195
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________
Component: Microsoft OLE DB Service Components
Description: <Description><![CDATA[Unspecified error]]></Description>

My guess is that the bit "Invalid procedure call or argument" is the actual
error but what is causing it I cannot see.
Could we have missed a step somewhere in a servicepack?

Any help would be greatly appreciated.

Jonathan Vardy

Gary L. Chefetz [MVP]

unread,
Dec 7, 2005, 10:57:41 AM12/7/05
to
Jonathan:

The most likely cause is permissions for the account running under COM+ To
make this determination, please logon to your system at the server console
using a domain admin account and use the Cube build page to build now. Let
us know what happens.

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project


"Jonathan Vardy" <Jonathan Va...@discussions.microsoft.com> wrote in message
news:A82C3F34-B870-44D0...@microsoft.com...

Jonathan Vardy

unread,
Dec 13, 2005, 4:40:03 AM12/13/05
to
Hi Gary,

We tried logging on with a domain admin and a local admin, it didn't help.
We also scheduled the cube build with a domain admin and a local admin, both
members of the OLAP admin. group, but this didn't help either.

Any other ideas that we could try?

Thanks, Jonathan

"Gary L. Chefetz [MVP]" schreef:

Gary L. Chefetz [MVP]

unread,
Dec 13, 2005, 7:44:35 AM12/13/05
to
Jonathan:

My next concern would be the fact that you say you have Project Server SP1
installed with a MUI pack for SP2. If we can't find a logical authentication
issue, then the 0x5 errors might indicate that the system is crashing on the
data.

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project


"Jonathan Vardy" <Jonath...@discussions.microsoft.com> wrote in message
news:B02D4D34-65D7-425D...@microsoft.com...

Jonathan Vardy

unread,
Dec 13, 2005, 7:55:03 AM12/13/05
to
Gary,

Is it incorrect to install the MUI SP2 with Project Server SP1? Are there
any steps we can take to debug or test where the error is occuring? Or is the
only possible resolution now to contact MS Support?

Gary L. Chefetz [MVP]

unread,
Dec 13, 2005, 8:10:25 AM12/13/05
to
Jonathan:

You can turn on SQL profiler and force a cube build. This should show you
where it's failing, if it's failing in SQL.

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project


"Jonathan Vardy" <Jonath...@discussions.microsoft.com> wrote in message

news:AAE1893D-5538-4FA5...@microsoft.com...

Jonathan Vardy

unread,
Dec 14, 2005, 3:57:02 AM12/14/05
to
Hi Gary,

Whatever it was, SP2a fixed it. I'm glad it was released, it was in the nick
of time for us :)

Reply all
Reply to author
Forward
0 new messages