Project Server 2003 OLAP cube generation error

J

Jos Broeren

We have a new installation of Project Server 2003.

All services are running with a local administrator domain account. This
account has also been added to the OLAP administrators group.

When we try to generate a new OLAP cube using the project server interface,
we receive a total of 5 errors in the eventlog within a second, nothing is
created in the OLAP server. We don’t use special characters for any input
values.

The strange thing is OLAP generation didn’t pose problems in our testing
environment which was installed with the same software and settings as far as
we can check. It must be caused by a very subtle difference.

Configuration:
Windows 2003 SP1
Project Server 2003 SP1
SQL 2000 SP4
Analysis SP4
WSS SP2

Any help is greatly appreciated.


Best regards,
Jos Broeren




The errors (top one is last):


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>
 

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

Top