OLAP Cube generation

J

Jonathan Vardy

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
 
G

Gary L. Chefetz [MVP]

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.




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
Click to expand...
 
J

Jonathan Vardy

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




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
Click to expand...
Click to expand...
 
G

Gary L. Chefetz [MVP]

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.




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




message
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
Click to expand...
Click to expand...
Click to expand...
 
J

Jonathan Vardy

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?

Thanks, Jonathan


"Gary L. Chefetz [MVP]" schreef:
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.




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




message
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
Click to expand...
Click to expand...
Click to expand...
 
G

Gary L. Chefetz [MVP]

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,

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?

Thanks, Jonathan


"Gary L. Chefetz [MVP]" schreef:
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.




message
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:

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.




message
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
Click to expand...
Click to expand...
Click to expand...
 
J

Jonathan Vardy

Hi Gary,

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

Jonathan

"Gary L. Chefetz [MVP]" schreef:
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,

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?

Thanks, Jonathan


"Gary L. Chefetz [MVP]" schreef:
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.




message
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:

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.




message
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
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cube building problem!! 11
Cube build fails, security check failure 11
OLAP CUBE ERROR in Project Server 2003 environment..Need help!!!!! 1
Having trouble building OLAP cube 2
Cube failed - (-2147221492) Unable to save object. 1
OLAP Cube creation errors 4
Cube building doesn't update PS database? HELP! 2
OLAP Cube Creation Error 3

Top