OLAP cube generation doesn't work anymore

O

orobla

We have been building OLAP cubes for a while and last week it failed. We get
a lot of errors in the Event Log. We have tried to use the EditSite tool, we
have configured it but the OLAP cube is not generated.
Could someone tell us how we can fix it? Thanks

These are the errors from the Event Log:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 12/11/2007
Time: 5:49:49 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CTCAP1500
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>
___________________________________

Description: <Description><![CDATA[Cannot open project
'<PC11DSN>\resglobal']]></Description>




Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 12/11/2007
Time: 5:49:49 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CTCAP1500
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>



Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 12/11/2007
Time: 5:49:49 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CTCAP1500
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>



Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 12/11/2007
Time: 5:49:49 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CTCAP1500
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>



Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 12/11/2007
Time: 5:49:49 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CTCAP1500
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>



Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 12/11/2007
Time: 5:49:49 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CTCAP1500
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>2007-09-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-08-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20070901</CubeStart><CubeFinish>20080831</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=CTCDS1500</DSOConnection><Server>CTCAP1500</Server><CubeDB>CIO_FY08_02</CubeDB><CubeDesc>Cube
for
CIO</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>7D8B50A1-4F27-4F08-BB1E-6E312A6BB354</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>



Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 12/11/2007
Time: 5:49:49 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CTCAP1500
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>2007-09-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-08-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20070901</CubeStart><CubeFinish>20080831</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=CTCDS1500</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=CTCDS1500</DSOConnection><Server>CTCAP1500</Server><CubeDB>CIO_FY08_02</CubeDB><CubeDesc>Cube
for
CIO</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>7D8B50A1-4F27-4F08-BB1E-6E312A6BB354</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2007-12-11T05:48:31</TimeStamp>
</ViewsDropData>]]></Description>



Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 12/11/2007
Time: 5:49:49 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CTCAP1500
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>2007-09-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-08-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20070901</CubeStart><CubeFinish>20080831</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=CTCDS1500</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=CTCDS1500</DSOConnection><Server>CTCAP1500</Server><CubeDB>CIO_FY08_02</CubeDB><CubeDesc>Cube
for
CIO</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>7D8B50A1-4F27-4F08-BB1E-6E312A6BB354</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2007-12-11T05:48:31</TimeStamp>
</ViewsDropData>]]></Description>



Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 12/11/2007
Time: 5:49:49 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CTCAP1500
Description:
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>2007-09-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-08-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20070901</CubeStart><CubeFinish>20080831</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=CTCDS1500</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=CTCDS1500</DSOConnection><Server>CTCAP1500</Server><CubeDB>CIO_FY08_02</CubeDB><CubeDesc>Cube
for
CIO</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>7D8B50A1-4F27-4F08-BB1E-6E312A6BB354</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2007-12-11T05:48:31</TimeStamp>
</ViewsDropData>]]></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