Reply to thread

Message: [QUOTE="Siraj, post: 4942361"] 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> ********************* [/QUOTE]

Verification