Project Server 2003无法建立OLAP cube
环境:Win2003+sqlserver2000+project server 2003project server 2003升级至sp2a，但是升级之后发现用户无法建OLAP Cube
在Update resource tables and OLAP cube里配置了正确的server 和cube name
但在save changes后进行Update now后页面就停滞在那里,状态信息里一直显示:
The cube building process was initiated on 2007-7-3 at 13:54
在系统日志中的错误信息:
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 7/3/2007
Time: 9:44:30 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CNPEKJVPMTEST
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-07-02T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2007-07-04T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20070702</CubeStart><CubeFinish>20070704</CubeFinish><Connection>Provider=SQLOLEDB; Initial Catalog=ProjectServer;Data Source=172.16.2.207</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source=172.16.2.207</DSOConnection><Server>CNPEKJVPMTEST</Server><CubeDB>T3G_Analysis</CubeDB><CubeDesc>This cube will be used for the analysis of R&D portfolio</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F5731DFA-5960-46E7-92E2-B2EFB02BEAD9</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2007-07-03T09:44:29</TimeStamp>
</ViewsDropData>]]></Description>
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 7/3/2007
Time: 9:44:30 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CNPEKJVPMTEST
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-07-02T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2007-07-04T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20070702</CubeStart><CubeFinish>20070704</CubeFinish><Connection>Provider=SQLOLEDB; Initial Catalog=ProjectServer;Data Source=172.16.2.207</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source=172.16.2.207</DSOConnection><Server>CNPEKJVPMTEST</Server><CubeDB>T3G_Analysis</CubeDB><CubeDesc>This cube will be used for the analysis of R&D portfolio</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>F5731DFA-5960-46E7-92E2-B2EFB02BEAD9</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2007-07-03T09:44:29</TimeStamp>
</ViewsDropData>]]></Description>
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 7/3/2007
Time: 10:14:14 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CNPEKJVPMTEST
Description:
Component: Views Notification Service
File: C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 207
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[7208_ST_Proj.Published] ]></EntProjectName><EntProjectID>67</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>133</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2007-07-03T10:14:14</TimeStamp></ViewsDropData>
]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 7/2/2007
Time: 7:39:54 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CNPEKJVPMTEST
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[7210_SW_Proj.Published] ]></EntProjectName><EntProjectID>81</EntProjectID></ProjectData><OrgGuid>ProjectServer</OrgGuid><ProjectID>140</ProjectID><BasePath>ProjectServer</BasePath><TimeStamp>2007-07-02T19:39:54</TimeStamp></ViewsDropData>
]]></Description>
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 7/3/2007
Time: 10:46:45 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CNPEKJVPMTEST
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>2003-08-18T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2009-02-10T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20030818</CubeStart><CubeFinish>20090210</CubeFinish><Connection>Provider=SQLOLEDB; Initial Catalog=ProjectServer;Data Source=172.16.2.207</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source=172.16.2.207</DSOConnection><Server>CNPEKJVPMTEST</Server><CubeDB>Portfolio_Analyser</CubeDB><CubeDesc>This cube will be used for the analysis of R&D portfolio</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>405C6D84-DE25-45E1-8FF8-FA9A1DA32579</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2007-07-03T10:46:45</TimeStamp>
</ViewsDropData>]]></Description>
Event Type: Error
Event Source: PjTraceSvc
Event Category: None
Event ID: 2
Date: 7/3/2007
Time: 11:01:19 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CNPEKJVPMTEST
Description:
A message passed to the tracing service had an incorrect format, the message follows
8?1000?<Error><Component></Component><File>C:\Office\dev\project\WebClient\source\server\pjdbcomm\Main.cpp</File><Line>59</Line><Description><![CDATA[ process started.]]></Description></Error>
For more information, see Help and Support Center at [url=http://go.microsoft.com/fwlink/events.asp]http://go.microsoft.com/fwlink/events.asp[/url].
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 7/3/2007
Time: 11:13:27 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: CNPEKJVPMTEST
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>2003-08-18T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2009-02-10T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20030818</CubeStart><CubeFinish>20090210</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source=172.16.2.207</DSOConnection><Server>CNPEKJVPMTEST</Server><CubeDB>Portfolio_Analyser</CubeDB><CubeDesc>This cube will be used for the analysis of R&D portfolio</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>BC01DE07-0E5A-46CA-87BE-C0375CC8DAE5</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>
[[i] 本帖最后由 地下清泉 于 2007-7-4 10:40 编辑 [/i]] 没有人碰到这样的问题吗?急啊! 群体里没有一个这样的高手吗？说两句嘛！ 我自己再顶！ 我再顶！ 难道真的没有高手吗？:(: 我坚持！ 顶顶顶！ 澈底没戏了！ 这么多人看，没有人用过Project server 2003吗？没有碰到这样问题的吗？
还是我发错版块了？ 顶你个肺！ :L: 无语了！
页:
[1]
