M
Max
Hi, after 6 months of use, suddendly the OLAP cube processing is not
completing. My architecture is as follows: 2 front end server( with project
server and WSS), 1 server with the ViewManager, Session Manager and Analysis
Services, and 1 DB server.
When the scheduled process tries to update the cube, the process never
completes. I tried to start the process manually but it does not complete.
The only part where I get some errors is the machine where the View and the
Session manager are installed. Please, if anyone has any other solution
other than re-install the whole thing...
The error message are the following:
FIRST MESSAGE
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>
___________________________________
Description: <Description><![CDATA[Cannot open project
'<PC11DSN>\resglobal']]></Description>
SECOND MESSAGE
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>
THIRD MESSAGE
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>
FOURTH MESSAGE
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>
FIFTH MESSAGE
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>
SIXTH MESSAGE
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>2004-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-10-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20040201</CubeStart><CubeFinish>20051001</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=PRJDOCDB\PRJSRVDB</DSOConnection><Server>VIEWSVR</Server><CubeDB>Cubo
di Project</CubeDB><CubeDesc>Dati delle Risorse TSF in
Project</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>4EB6CB42-948F-4104-ACC0-FB3BEE815DE2</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>
SEVENTH MESSAGE
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>2004-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-10-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20040201</CubeStart><CubeFinish>20051001</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=PRJDOCDB\PRJSRVDB</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=PRJDOCDB\PRJSRVDB</DSOConnection><Server>VIEWSVR</Server><CubeDB>Cubo
di Project</CubeDB><CubeDesc>Dati delle Risorse TSF in
Project</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>4EB6CB42-948F-4104-ACC0-FB3BEE815DE2</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2005-03-23T17:06:12</TimeStamp>
</ViewsDropData>]]></Description>
completing. My architecture is as follows: 2 front end server( with project
server and WSS), 1 server with the ViewManager, Session Manager and Analysis
Services, and 1 DB server.
When the scheduled process tries to update the cube, the process never
completes. I tried to start the process manually but it does not complete.
The only part where I get some errors is the machine where the View and the
Session manager are installed. Please, if anyone has any other solution
other than re-install the whole thing...
The error message are the following:
FIRST MESSAGE
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>
___________________________________
Description: <Description><![CDATA[Cannot open project
'<PC11DSN>\resglobal']]></Description>
SECOND MESSAGE
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>
THIRD MESSAGE
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>
FOURTH MESSAGE
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>
FIFTH MESSAGE
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>
SIXTH MESSAGE
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>2004-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-10-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20040201</CubeStart><CubeFinish>20051001</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=PRJDOCDB\PRJSRVDB</DSOConnection><Server>VIEWSVR</Server><CubeDB>Cubo
di Project</CubeDB><CubeDesc>Dati delle Risorse TSF in
Project</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>4EB6CB42-948F-4104-ACC0-FB3BEE815DE2</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>
SEVENTH MESSAGE
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>2004-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-10-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20040201</CubeStart><CubeFinish>20051001</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=PRJDOCDB\PRJSRVDB</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=PRJDOCDB\PRJSRVDB</DSOConnection><Server>VIEWSVR</Server><CubeDB>Cubo
di Project</CubeDB><CubeDesc>Dati delle Risorse TSF in
Project</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>4EB6CB42-948F-4104-ACC0-FB3BEE815DE2</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2005-03-23T17:06:12</TimeStamp>
</ViewsDropData>]]></Description>