Hi Chak
How r u.
When I have seen in manage enterprise features its shows as following :
The next 4 weeks
The past 3 months
now I change the settings as next 2 months ; past 2 weeks.
Is it ok or I want to change as per mention by you?
--
------------------------------
Thanks
Nitesh Mathur
------------------------------
:
Nitesh,
It seems to be error was originated on Resource Availability cube
build process. It also indicates that your project plans are not
causing any errors.
I guess, wide resource availability range is making impact on cube
build process. Currently your OLAP resource availability cube
considering the data from 1984 to 2014
Question for you, what are the settings under "Date range for resource
availability"? (Please look under PWA -> Admin -> Manage Enterpriese
Features -> Update resource tables and OLAP cube)
Please use the following date range for retrieving resource
availability information
The next X weeks/months
The past X weeks/months
Ideally recommended settings are next 18 months ; past 0 weeks/months
I hope this resolves your error.
Thanks
Chak
http://www.epmcentral.com
On Jul 23, 2:29 am, Nitesh Mathur
Hi Chak
Thx for reply.
I had cleared XML file from viewdrop but in Eventvwr its shows some error
and I'm unbale to understand them, will you please help me .
Here some errors from Event viewer log files :
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>1984-01-02T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2014-01-07T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>19840102</CubeStart><CubeFinish>20ÂÂ140107</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;PeÂrÂsist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=172.16.8.119;Connect
Timeout=15</DSOConnection><Server>epmudpd</Server><CubeDB>RA</CubeDB><CubeDÂÂesc>resource
analysis</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>54F7181F-4DCÂÂ9-45E4-8951-75DADA37DD92</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></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>19840102</CubeStart><CubeFinish>20ÂÂ140107</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;PeÂrÂsist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=172.16.8.119;Connect
Timeout=15</DSOConnection><Server>epmudpd</Server><CubeDB>RA</CubeDB><CubeDÂÂesc>resource
analysis</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>54F7181F-4DCÂÂ9-45E4-8951-75DADA37DD92</CubeGUID></CubeUpdate></BuildCubeRequest>]]></DeÂsÂcription>.
---------------------------------------------------------------------------ÂÂ--------------------------------------------------
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>1984-01-02T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2014-01-07T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>19840102</CubeStart><CubeFinish>20ÂÂ140107</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=172.16.8.119</Connection><DBType>0</DBType><DSOConnection>Provider=SÂÂQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=172.16.8.119;Connect
Timeout=15</DSOConnection><Server>epmudpd</Server><CubeDB>RA</CubeDB><CubeDÂÂesc>resource
analysis</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>54F7181F-4DCÂÂ9-45E4-8951-75DADA37DD92</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2008-07-23T01:45:05</TimeStamp>
</ViewsDropData>]]></Description>
File: C:\Office\devsp\project\WebClient\source\utility\pjsmtpemail.cpp
Line: 438
Error Number: 0x80040213
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________
Component: CDO.Message.1
Description: <Description><![CDATA[The transport failed to connect to the
server.
]]></Description>
--
------------------------------
Thanks
Nitesh Mathur
------------------------------
:
Nitesh,
Have you checked the view drop folder? Generally this folder is
located on your project server machine. The path is \Program Files
\Microsoft Office Project Server 2003\BIN\VIEWDROP
See, is there any XML files queued up? In general, when you publish ms
project plan, XML file will be generated for that particular project
and will be processed here to push the information to Project Web
Access.
If processing of these files struck, there are possibilities of
failing the cube build process.
If you see the files, you have to clear up these files. Also check
Error event log to find out which XML file is causing the blockage.
Thanks
Chak
http://www.epmcentral.com
On Jul 22, 7:52 am, Nitesh Mathur
Hi I’m using PWA & Project Prof 2003 and facing problem while updating OLAP
cube.
In Admin --> manage enterprise feature; we already scheduled to update OLAP
cube at 1:30 AM daily. This is a time when no user connected with Server and
its works fine for 10 – 15 days then its failed to build OLAP cube or hang on
with following message
“ the cube is being build†or
“The cube scheduled to be built on 7/22/2008 at 3:33 PM
failed.(-2147221411)†or
“The cube process has been initiated [date, time]â€
Generally we reset the password in PCComplus.exe and restart View
Notification Services and its become successful, but some times this exercise
not works and we have to restart our Production & data base server. But
generally we do this exercise in every 10 to 15 days.
Is there any permanent solution as I was tried many solutions which are
available on forums but those are not permanent solution ; its my opinion..
Point to note : We have two server : one is Production server & second is
database server.
Any suggestion please.
--
------------------------------
Thanks
Nitesh Mathur
------------------------------- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -
