Adding Earned Value Analysis to Portfolio Analyzer - Urgent

S

Siraj

Hi,
I added Earned Value Analysis (EAV) cube to the Portfolio Analyzer
Virtual Cube. When I tried generating the cube from Analysis Manager, the
cube was built successfully. When I tried to build the cube from PWA I got
the following error message.

The cube scheduled to be built on 10/18/2005 at 7:36 PM failed.

(-2147221496) Error in BuildCube. Error in CreateOneTaskOutlineDimension.
Dimension 'Old Task Billing Category' cannot be deleted because it is used in
cube 'MSP_PORTFOLIO_ANALYZER'.


Following are the error messages from the Event Viewer.

Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 10/18/2005
Time: 7:36:20 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: SD4PCDEV
Description:
Component: Views Notification Service
File: C:\Office\dev\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 125
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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-12-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20051231</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</DSOConnection><Server>SD4PCDEV</Server><CubeDB>Test
Cube100</CubeDB><CubeDesc>Test
Cube100</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>E706C882-94A3-49BA-B24E-0E3E04AB470F</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2005-10-18T19:29:42</TimeStamp>
</ViewsDropData>]]></Description>



*****************************

Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 10/18/2005
Time: 7:36:20 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: SD4PCDEV
Description:
Component: Views Notification Service
File: C:\Office\dev\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 130
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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-12-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20051231</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</DSOConnection><Server>SD4PCDEV</Server><CubeDB>Test
Cube100</CubeDB><CubeDesc>Test
Cube100</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>E706C882-94A3-49BA-B24E-0E3E04AB470F</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2005-10-18T19:29:42</TimeStamp>
</ViewsDropData>]]></Description>


*******************

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/18/2005
Time: 7:36:20 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: SD4PCDEV
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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-12-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20051231</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</DSOConnection><Server>SD4PCDEV</Server><CubeDB>Test
Cube100</CubeDB><CubeDesc>Test
Cube100</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>E706C882-94A3-49BA-B24E-0E3E04AB470F</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2005-10-18T19:29:42</TimeStamp>
</ViewsDropData>]]></Description>


*****************

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/18/2005
Time: 7:36:20 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: SD4PCDEV
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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2005-12-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20051231</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</DSOConnection><Server>SD4PCDEV</Server><CubeDB>Test
Cube100</CubeDB><CubeDesc>Test
Cube100</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>E706C882-94A3-49BA-B24E-0E3E04AB470F</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


************************

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/18/2005
Time: 7:36:20 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: SD4PCDEV
Description:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x80004005
Description: <Description><![CDATA[Failed to generate OLAP Cube for the
following Request :

<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20051231</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=SD4PCDEV</DSOConnection><Server>SD4PCDEV</Server><CubeDB>Test
Cube100</CubeDB><CubeDesc>Test
Cube100</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>E706C882-94A3-49BA-B24E-0E3E04AB470F</CubeGUID></CubeUpdate></BuildCubeRequest>]]></Description>


*********************

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/18/2005
Time: 7:36:20 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: SD4PCDEV
Description:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 2001
Description: <Description><![CDATA[Error #: -2147221496 Desc. :Error in
BuildCube. Error in CreateOneTaskOutlineDimension. Dimension 'Old Task
Billing Category' cannot be deleted because it is used in cube
'MSP_PORTFOLIO_ANALYZER'.]]></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

Similar Threads

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

Top