Having trouble building OLAP cube

C

Chris M

Here is my setup: One server running windows 2003 sp2, with project server
2003 sp3. Another server running sql 2005 and wss 2.0 both with sp3 parts
installed.

there are the errors I am getting on the Project server:

File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1692
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Description: <Description><![CDATA[Cannot find file
'<PC11DSN>\resglobal']]></Description>

Component: PjViewMgr
File:
C:\Office\devsp\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1195
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Additional Information: An error occured calling
CallViewGenerator(projectserver, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2005-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

Component: PjViewMgr
File:
C:\Office\devsp\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1454
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjQuery
File: C:\Office\devsp\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: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 883
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></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-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=bostonsql</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2008-09-12T11:41:13</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-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=bostonsql</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2008-09-12T11:41:13</TimeStamp>
</ViewsDropData>]]></Description>

<Error><Component>Views Notification
Service</Component><File>C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp</File><Line>127</Line><Number>0x800a0005</Number><Description><![CDATA[View
scheduler received error while scheduling
views]]></Description><Error><Component>PCSViews</Component><File>ViewsDrop.cls</File><Line>-1</Line><Number>0x5</Number><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-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=bostonsql</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2008-09-12T11:41:13</TimeStamp>
</ViewsDropData>]]></Description></Error>

On the admin page it says: "The cube building process was initiated on
9/12/2008 at 11:41 AM" and doesn't change.

Any help you could give would be much appreciated, Thanks in advance.
 
M

Martin Winzig

My bst guess is that on Project server, computer were not installed
components required to acces SQL 2005 AS.
--
Blog: http://www.projectserver.cz


Chris M said:
Here is my setup: One server running windows 2003 sp2, with project server
2003 sp3. Another server running sql 2005 and wss 2.0 both with sp3 parts
installed.

there are the errors I am getting on the Project server:

File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1692
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Description: <Description><![CDATA[Cannot find file
'<PC11DSN>\resglobal']]></Description>

Component: PjViewMgr
File:
C:\Office\devsp\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1195
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Additional Information: An error occured calling
CallViewGenerator(projectserver, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2005-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

Component: PjViewMgr
File:
C:\Office\devsp\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1454
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjQuery
File: C:\Office\devsp\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: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 883
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></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-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=bostonsql</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2008-09-12T11:41:13</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-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=bostonsql</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2008-09-12T11:41:13</TimeStamp>
</ViewsDropData>]]></Description>

<Error><Component>Views Notification
Service</Component><File>C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp</File><Line>127</Line><Number>0x800a0005</Number><Description><![CDATA[View
scheduler received error while scheduling
views]]></Description><Error><Component>PCSViews</Component><File>ViewsDrop.cls</File><Line>-1</Line><Number>0x5</Number><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-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=bostonsql</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2008-09-12T11:41:13</TimeStamp>
</ViewsDropData>]]></Description></Error>

On the admin page it says: "The cube building process was initiated on
9/12/2008 at 11:41 AM" and doesn't change.

Any help you could give would be much appreciated, Thanks in advance.
Click to expand...
 
C

Chris M

Can you elaborate?

Martin Winzig said:
My bst guess is that on Project server, computer were not installed
components required to acces SQL 2005 AS.
--
Blog: http://www.projectserver.cz


Chris M said:
Here is my setup: One server running windows 2003 sp2, with project server
2003 sp3. Another server running sql 2005 and wss 2.0 both with sp3 parts
installed.

there are the errors I am getting on the Project server:

File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1692
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Description: <Description><![CDATA[Cannot find file
'<PC11DSN>\resglobal']]></Description>

Component: PjViewMgr
File:
C:\Office\devsp\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1195
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Additional Information: An error occured calling
CallViewGenerator(projectserver, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2005-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

Component: PjViewMgr
File:
C:\Office\devsp\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1454
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjQuery
File: C:\Office\devsp\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: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 883
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></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-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=bostonsql</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2008-09-12T11:41:13</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-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=bostonsql</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2008-09-12T11:41:13</TimeStamp>
</ViewsDropData>]]></Description>

<Error><Component>Views Notification
Service</Component><File>C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp</File><Line>127</Line><Number>0x800a0005</Number><Description><![CDATA[View
scheduler received error while scheduling
views]]></Description><Error><Component>PCSViews</Component><File>ViewsDrop.cls</File><Line>-1</Line><Number>0x5</Number><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-10-31T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2017-02-23T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20051031</CubeStart><CubeFinish>20170223</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=bostonsql</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=bostonsql</DSOConnection><Server>bostonsql</Server><CubeDB>ProjServCube3</CubeDB><CubeDesc>Default
Project Server
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F2A1E125-015B-42BF-ACCD-B903621B4CCA</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2008-09-12T11:41:13</TimeStamp>
</ViewsDropData>]]></Description></Error>

On the admin page it says: "The cube building process was initiated on
9/12/2008 at 11:41 AM" and doesn't change.

Any help you could give would be much appreciated, Thanks in advance.
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
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
The cube scheduled to be built on xxx at xxx failed. (-2147221411) 0

Top