B
BTOjohn
Hi, I realise I'm turning into a regular questioner without actually being
able to reciprocate, but I'm learning!
My cube suddenly failed to build over the last two nights, and messages in
the event viwer are copied below. I can get the cube to build if I delete it
in Analysis Manager, and then "Update Now" in PWA. But then it fails again on
the scheduled overnight build. I have checked project/resource/task names for
illegal characters, but it all seems to be in order. I have checked Viewdrop
permissions, and in "manage roles" for the cube, all seem fine. When I
"Process the Database" I receive these kinds of messages:
A member with key '332' was found in the fact table but was not found in the
set of leaf members of dimension 'Tasks'.; Time:26/01/2006 09:53:48
I would be most greatful for any help or suggestions. Many thanks. John
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3061
Description: <Description><![CDATA[Error #: -2147221411 Desc.
:]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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>20060930</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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>2006-09-30T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20060930</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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>2006-09-30T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20060930</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=project</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2006-01-26T03:08:47</TimeStamp>
</ViewsDropData>]]></Description>
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2006-09-30T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20060930</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=project</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2006-01-26T03:08:47</TimeStamp>
</ViewsDropData>]]></Description>
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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>2005-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2006-09-30T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20060930</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=project</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2006-01-26T03:08:47</TimeStamp>
</ViewsDropData>]]></Description>
able to reciprocate, but I'm learning!
My cube suddenly failed to build over the last two nights, and messages in
the event viwer are copied below. I can get the cube to build if I delete it
in Analysis Manager, and then "Update Now" in PWA. But then it fails again on
the scheduled overnight build. I have checked project/resource/task names for
illegal characters, but it all seems to be in order. I have checked Viewdrop
permissions, and in "manage roles" for the cube, all seem fine. When I
"Process the Database" I receive these kinds of messages:
A member with key '332' was found in the fact table but was not found in the
set of leaf members of dimension 'Tasks'.; Time:26/01/2006 09:53:48
I would be most greatful for any help or suggestions. Many thanks. John
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3061
Description: <Description><![CDATA[Error #: -2147221411 Desc.
:]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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>20060930</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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>2006-09-30T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20060930</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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>2006-09-30T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20060930</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=project</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2006-01-26T03:08:47</TimeStamp>
</ViewsDropData>]]></Description>
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2006-09-30T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20060930</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=project</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2006-01-26T03:08:47</TimeStamp>
</ViewsDropData>]]></Description>
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 26/01/2006
Time: 03:14:17
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
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>2005-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2006-09-30T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20050101</CubeStart><CubeFinish>20060930</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=project</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data Source=project;Connect
Timeout=15</DSOConnection><Server>project</Server><CubeDB>BTOCube</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>9CD88402-0D68-443F-8944-CE47B818250E</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2006-01-26T03:08:47</TimeStamp>
</ViewsDropData>]]></Description>