Cube Building problem and MSP_VIEW_RES_TP_BY_DAY problem

[Kurte]

I recently installed Project Server 2003 and Analysis Services along with
View Processing on a server which has SharePoint 2003 installed. The database
is on another server. Both Project Server, Analysis Services and SQL 2000 are
on Service Pack 3.

I have also migrated the Analysis Services Repository to database server and
all the required permissions from what I can see are set on the database
included the project server database.

The Olap Administrators groups is also on both Servers and the user
configured for the OLAP cube components has administrators rights. To build
the cube I first try to update the resource availibility table but when I
check the MSP_VIEW_RES_TP_BY_DAY table the rows are blank. As I initiate this
process I did a check in the component services and see that the OLAP process
starts, VNOTIFY.exe services is also running.

The application event logs do not have any errors relating to Project 2003.
In terms of project publishing there are no problems here we can post
projects to Project Web Access without any problems.

I would really appreciate if anyone on this group have any suggestions that
I could try to resolve this problem.

Thanks

Kurte

 

[Marc S.]

Kurte,

If you go to Analysis Manager, can you actually see the cube you're trying
to build? If it does appear, try deleting and letting it build from scratch
again.

Is there any data in the three following tables: MSP_CUBE_ASSN_FACT,
MSP_CUBE_RES_AVAIL_FACT, MSP_CUBE_TIME_BY_DAY? You may want to run a SQL
truncate query on these 3 tables, restart Views Notifications Service and
then initiate the cube building process again.

Hope this helps, let us know the news...

Marc

 

[Kurte]

Thanks Marc for your suggestions, I will try these steps and let you know how
it goes.

Kurte

 

[Kurte]

Marc,

I check and the tables MSP_CUBE_ASSN_FACT, MSP_CUBE_RES_AVAIL_FACT,
MSP_CUBE_TIME_BY_DAY do not have any information in them. Also the table
MSP_VIEW_PROJ_ASSN_TP_BY_DAY does not have any information although I updated
the Resource Availibility table in Project Web Access.

When I generate the cube process I also checked the OLAP component Service
and it starts as a running service but the VNotify.exe in Task Manager does
not show any CPU activity. I also ran the EditSite tool to test the
connections and all areas passed without any errors. I even reset PC11DSN
using the EditSite utility but still nothing.

Kurte

 

[Rolly Perreaux]

Marc,

I check and the tables MSP_CUBE_ASSN_FACT, MSP_CUBE_RES_AVAIL_FACT,
MSP_CUBE_TIME_BY_DAY do not have any information in them. Also the table
MSP_VIEW_PROJ_ASSN_TP_BY_DAY does not have any information although I updated
the Resource Availibility table in Project Web Access.

When I generate the cube process I also checked the OLAP component Service
and it starts as a running service but the VNotify.exe in Task Manager does
not show any CPU activity. I also ran the EditSite tool to test the
connections and all areas passed without any errors. I even reset PC11DSN
using the EditSite utility but still nothing.

Kurte

Hi Kurte,

Can you successfully build an OLAP cube?
What does the Current Cube Status message say in the Update resource
tables and OLAP cube section?


--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Marc S.]

Kurte,

You have already checked the COM+ Applications for OLAP in Component
Services on your server, right?

The cube building process will first create a XML file in the ViewDrop
folder on the machine running the Views Notification Service. If you initiate
the cube building process again, can you actually see the XML file in
ViewDrop? By default you find ViewDrop in \Microsoft Office Project Server
2003\BIN\VIEWDROP. Also every publish of a project will create a XML file in
this folder.

Hope this helps...

Marc

 

[Kurte]

Hi Rolly,

Thank you for your response, to answer your question I am receiving the
following message "The cube building process was initiated on 8/13/2006 at
12:23 PM". I currently only have two active projects for now as I wanted to
test the product features to ensure that everything is working.

Kurte

The cube parameters have been validated

 

[Kurte]

Hi Marc,

Yes the COM+Applications for OLAP is working. Regarding your other question
here is what I did after reading it.

1. First I deleted all the xml files from the view drop folder, I currently
am only working with two projects right now so as to test the system
functionality.

2. I published all project information then checked the viewdrop folder for
xml files. There I found four (4) xml files with a size of 1kb each. But my
questions are (A) Why should there be fours xml files as I along published 2
projects? (B) Why would each project have a duplicate xml file? (C) Should
these files not be larger than 1kb in size? below is the contents of one of
the files.

- <ViewsDropData>
- <ProjectData>
- <EntProjectName>
- <![CDATA[ XXX Project Plan.Published
]]>
</EntProjectName>
<EntProjectID>61</EntProjectID>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<ProjectID>107</ProjectID>
<BasePath>projectserver</BasePath>
<TimeStamp>2006-08-14T08:51:27</TimeStamp>
</ViewsDropData>

Kurte

 

[Rolly Perreaux]

Hi Rolly,

Thank you for your response, to answer your question I am receiving the
following message "The cube building process was initiated on 8/13/2006 at
12:23 PM". I currently only have two active projects for now as I wanted to
test the product features to ensure that everything is working.

Kurte

The cube parameters have been validated

Hi Kurte,

Do you still see the same message right now?


--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Kurte]

Rolly,

Yes I can.

Kurte

Hi Kurte,

Do you still see the same message right now?


--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Gary L. Chefetz [MVP]]

One for the publish, one for the close - three to get ready and four to go!
OK, forget everything after the dash.

Hi Marc,

Yes the COM+Applications for OLAP is working. Regarding your other
question
here is what I did after reading it.

1. First I deleted all the xml files from the view drop folder, I
currently
am only working with two projects right now so as to test the system
functionality.

2. I published all project information then checked the viewdrop folder
for
xml files. There I found four (4) xml files with a size of 1kb each. But
my
questions are (A) Why should there be fours xml files as I along published
2
projects? (B) Why would each project have a duplicate xml file? (C) Should
these files not be larger than 1kb in size? below is the contents of one
of
the files.

- <ViewsDropData>
- <ProjectData>
- <EntProjectName>
- <![CDATA[ XXX Project Plan.Published
]]>
</EntProjectName>
<EntProjectID>61</EntProjectID>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<ProjectID>107</ProjectID>
<BasePath>projectserver</BasePath>
<TimeStamp>2006-08-14T08:51:27</TimeStamp>
</ViewsDropData>

Kurte

Kurte,

You have already checked the COM+ Applications for OLAP in Component
Services on your server, right?

The cube building process will first create a XML file in the ViewDrop
folder on the machine running the Views Notification Service. If you
initiate
the cube building process again, can you actually see the XML file in
ViewDrop? By default you find ViewDrop in \Microsoft Office Project
Server
2003\BIN\VIEWDROP. Also every publish of a project will create a XML file
in
this folder.

Hope this helps...

Marc

 

[Rolly Perreaux]

Rolly,

Yes I can.

Kurte

OK Kurte,

Let's see if I have your configuration straight...

Server 1 has the following installed:
Project Server 2003 (Front End)
View Processing
SQL Server 2000 Analysis Services with SP3
Windows SharePoint Services

Server 2 has the following installed:
SQL Server 2000 with SP3

ASSUMPTIONS
Session Manager (a Project Server component) and Windows SharePoint
Services 2.0 is installed on Server 1. Also when you say Project Server
2003 I will assume the Front End component of Project Server 2003.

QUESTION
Why is Analysis Services installed on Server 1, instead on Server 2 with
SQL Server 2000? This could pose a problem for Server 1 when you are
building the OLAP cube as it requires a lot of CPU cycles to build.

If you can, uninstall Analysis Services from Server 1 and install on
Server 2. This way you will get better performance and eliminate
potential bottleneck.

Then install the latest service pack for Analysis Services on Server 2.

Afterwards, you will need to install the Decision Support Objects (DSO)
and Client Components from the Analysis Services CD on Server 1. Make
sure to only select DSO and Client Components.

*Special Note:
If you have the Project Server Front End and Views Processing on
different servers, the DSO must be installed on each server that has
these components.

Then install the latest service pack for Analysis Services on Server 1.
This will upgrade the version of the DSO

Then go to the Computer Management console on Server 1 and there will be
a new group listed called OLAP Administrators. Add the same OLAP service
account that you used in your installation.

Then go to Server 2 and open SQL Enterprise Manager console and create a
new Repository database for the Analysis Services.

Then open the Analysis Services console and migrate the Repository to a
new database on the SQL Server.

Then go to PWA and build the OLAP Cube.

Since you only have 2 projects, it shouldn't take too long
(15 mins or so)

KEY ITEMS
It is very important that the DSO component's version must be the same
on all servers. What typically happens is that a SQL DBA might upgrade
to the latest service pack for the SQL and Analysis Services. If the
Project Server Front End and/or View Processing do not receive the same
service pack then you will not be able to build the OLAP cube.

Another point is not to forget to add the OLAP service account to the
servers that installed the DSO (Project Server Front End and/or Views
Processing) in the new group called OLAP Administrators.

Now, if you cannot uninstall Analysis Services from Server 1, then try
installing the DSO on Server 2 instead and follow steps listed above. I
have not tried or tested this, but it would make pretty good sense.

Good Luck and let know how it turns out.


--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Marc S.]

Kurte,

as Gary has already replied one XML file for publishing, one for closing.

The point though is can you see a XML file in the ViewDrop folder after you
have clicked the "update now" button in "Manage enterprise features". With
the small number of projects you have in your DB it should only take about 5
minutes to build the cube.

Are the publish XML files processed by the Views Notification Service after
a while or did you delete all file manually? They will automatically
disappear after being processed.

Marc

--
MCP, EPM consultant
Basel, Switzerland
http://msepm.blogspot.com

Hi Marc,

Yes the COM+Applications for OLAP is working. Regarding your other question
here is what I did after reading it.

1. First I deleted all the xml files from the view drop folder, I currently
am only working with two projects right now so as to test the system
functionality.

2. I published all project information then checked the viewdrop folder for
xml files. There I found four (4) xml files with a size of 1kb each. But my
questions are (A) Why should there be fours xml files as I along published 2
projects? (B) Why would each project have a duplicate xml file? (C) Should
these files not be larger than 1kb in size? below is the contents of one of
the files.

- <ViewsDropData>
- <ProjectData>
- <EntProjectName>
- <![CDATA[ XXX Project Plan.Published
]]>
</EntProjectName>
<EntProjectID>61</EntProjectID>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<ProjectID>107</ProjectID>
<BasePath>projectserver</BasePath>
<TimeStamp>2006-08-14T08:51:27</TimeStamp>
</ViewsDropData>

Kurte

Kurte,

You have already checked the COM+ Applications for OLAP in Component
Services on your server, right?

The cube building process will first create a XML file in the ViewDrop
folder on the machine running the Views Notification Service. If you initiate
the cube building process again, can you actually see the XML file in
ViewDrop? By default you find ViewDrop in \Microsoft Office Project Server
2003\BIN\VIEWDROP. Also every publish of a project will create a XML file in
this folder.

Hope this helps...

Marc

 

[Kurte]

Marc,

I ran the cube build and do an xml file with the following contents...

ViewsDropData>

- <ProjectData>

- <EntProjectName>

- <![CDATA[ resglobal ]]>
</EntProjectName>

<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2006-08-01T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2006-09-11T00:00:00</EntResourceFinishDate>

- <BuildCubeRequest>

- <CubeUpdate>

<CubeStart>20060801</CubeStart>

<CubeFinish>20060911</CubeFinish>

<Connection>Provider=SQLOLEDB; Initial Catalog=ProjectServer;Data
Source=DBSERVER</Connection>

<DBType>0</DBType>

<DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=ProjectServer;Data Source=XXXISERVER</DSOConnection>

<Server>XXXserver</Server>

<CubeDB>ProjectServerCube</CubeDB>

<CubeDesc>Project Cube</CubeDesc>

<BasePath>projectserver</BasePath>

<CubeGUID>3940CA37-4D63-4067-9E8F-D8F1079648EF</CubeGUID>

</CubeUpdate>

</BuildCubeRequest>

</ProjectData>

<OrgGuid>projectserver</OrgGuid>

<BasePath>projectserver</BasePath>

<TimeStamp>2006-08-14T12:36:33</TimeStamp>

</ViewsDropData>

Close to a half an hour has passed and no cube building process started as
the VNOTIFY.exe service is not utilizing any CPU resources and the memory
size for this service is still the same.

Kurte,

as Gary has already replied one XML file for publishing, one for closing.

The point though is can you see a XML file in the ViewDrop folder after you
have clicked the "update now" button in "Manage enterprise features". With
the small number of projects you have in your DB it should only take about 5
minutes to build the cube.

Are the publish XML files processed by the Views Notification Service after
a while or did you delete all file manually? They will automatically
disappear after being processed.

Marc

--
MCP, EPM consultant
Basel, Switzerland
http://msepm.blogspot.com

Hi Marc,

Yes the COM+Applications for OLAP is working. Regarding your other question
here is what I did after reading it.

1. First I deleted all the xml files from the view drop folder, I currently
am only working with two projects right now so as to test the system
functionality.

2. I published all project information then checked the viewdrop folder for
xml files. There I found four (4) xml files with a size of 1kb each. But my
questions are (A) Why should there be fours xml files as I along published 2
projects? (B) Why would each project have a duplicate xml file? (C) Should
these files not be larger than 1kb in size? below is the contents of one of
the files.

- <ViewsDropData>
- <ProjectData>
- <EntProjectName>
- <![CDATA[ XXX Project Plan.Published
]]>
</EntProjectName>
<EntProjectID>61</EntProjectID>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<ProjectID>107</ProjectID>
<BasePath>projectserver</BasePath>
<TimeStamp>2006-08-14T08:51:27</TimeStamp>
</ViewsDropData>

Kurte

Kurte,

You have already checked the COM+ Applications for OLAP in Component
Services on your server, right?

The cube building process will first create a XML file in the ViewDrop
folder on the machine running the Views Notification Service. If you initiate
the cube building process again, can you actually see the XML file in
ViewDrop? By default you find ViewDrop in \Microsoft Office Project Server
2003\BIN\VIEWDROP. Also every publish of a project will create a XML file in
this folder.

Hope this helps...

Marc


--
MCP, EPM consultant
Basel, Switzerland
http://msepm.blogspot.com


:

Marc,

I check and the tables MSP_CUBE_ASSN_FACT, MSP_CUBE_RES_AVAIL_FACT,
MSP_CUBE_TIME_BY_DAY do not have any information in them. Also the table
MSP_VIEW_PROJ_ASSN_TP_BY_DAY does not have any information although I updated
the Resource Availibility table in Project Web Access.

When I generate the cube process I also checked the OLAP component Service
and it starts as a running service but the VNotify.exe in Task Manager does
not show any CPU activity. I also ran the EditSite tool to test the
connections and all areas passed without any errors. I even reset PC11DSN
using the EditSite utility but still nothing.

Kurte

:

Kurte,

If you go to Analysis Manager, can you actually see the cube you're trying
to build? If it does appear, try deleting and letting it build from scratch
again.

Is there any data in the three following tables: MSP_CUBE_ASSN_FACT,
MSP_CUBE_RES_AVAIL_FACT, MSP_CUBE_TIME_BY_DAY? You may want to run a SQL
truncate query on these 3 tables, restart Views Notifications Service and
then initiate the cube building process again.

Hope this helps, let us know the news...

Marc

--
MCP, EPM consultant
Basel, Switzerland
http://msepm.blogspot.com


:

I recently installed Project Server 2003 and Analysis Services along with
View Processing on a server which has SharePoint 2003 installed. The database
is on another server. Both Project Server, Analysis Services and SQL 2000 are
on Service Pack 3.

I have also migrated the Analysis Services Repository to database server and
all the required permissions from what I can see are set on the database
included the project server database.

The Olap Administrators groups is also on both Servers and the user
configured for the OLAP cube components has administrators rights. To build
the cube I first try to update the resource availibility table but when I
check the MSP_VIEW_RES_TP_BY_DAY table the rows are blank. As I initiate this
process I did a check in the component services and see that the OLAP process
starts, VNOTIFY.exe services is also running.

The application event logs do not have any errors relating to Project 2003.
In terms of project publishing there are no problems here we can post
projects to Project Web Access without any problems.

I would really appreciate if anyone on this group have any suggestions that
I could try to resolve this problem.

Thanks

Kurte

 

[Rolly Perreaux]

Marc,

I ran the cube build and do an xml file with the following contents...

ViewsDropData>

- <ProjectData>

- <EntProjectName>

- <![CDATA[ resglobal ]]>
</EntProjectName>

<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2006-08-01T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2006-09-11T00:00:00</EntResourceFinishDate>

- <BuildCubeRequest>

- <CubeUpdate>

<CubeStart>20060801</CubeStart>

<CubeFinish>20060911</CubeFinish>

<Connection>Provider=SQLOLEDB; Initial Catalog=ProjectServer;Data
Source=DBSERVER</Connection>

<DBType>0</DBType>

<DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=ProjectServer;Data Source=XXXISERVER</DSOConnection>

<Server>XXXserver</Server>

<CubeDB>ProjectServerCube</CubeDB>

<CubeDesc>Project Cube</CubeDesc>

<BasePath>projectserver</BasePath>

<CubeGUID>3940CA37-4D63-4067-9E8F-D8F1079648EF</CubeGUID>

</CubeUpdate>

</BuildCubeRequest>

</ProjectData>

Hi Kurte,


<Server>XXXserver</Server>
Is this correct?

Did you retype the actual server name when you posted your message to
us?
OR
Is this the actual XML entry?

--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Rolly Perreaux]

Marc,

I ran the cube build and do an xml file with the following contents...

ViewsDropData>

- <ProjectData>

- <EntProjectName>

- <![CDATA[ resglobal ]]>
</EntProjectName>

<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2006-08-01T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2006-09-11T00:00:00</EntResourceFinishDate>

- <BuildCubeRequest>

- <CubeUpdate>

<CubeStart>20060801</CubeStart>

<CubeFinish>20060911</CubeFinish>

<Connection>Provider=SQLOLEDB; Initial Catalog=ProjectServer;Data
Source=DBSERVER</Connection>

<DBType>0</DBType>

<DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=ProjectServer;Data Source=XXXISERVER</DSOConnection>

<Server>XXXserver</Server>

Hi Kurte,

Also the same with this XML entry:

<DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=ProjectServer;Data Source=XXXISERVER</DSOConnection>


Should it not be:
Data Source=DBSERVER for <DSOConnection> and <Server>?


--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Kurte]

Rolly,

I substituted the server names so "XXXISERVER" would be the database server
and "XXXserver" would be server where Analysis Servers and View Processing
are.

Kurte

Marc,

I ran the cube build and do an xml file with the following contents...

ViewsDropData>

- <ProjectData>

- <EntProjectName>

- <![CDATA[ resglobal ]]>
</EntProjectName>

<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2006-08-01T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2006-09-11T00:00:00</EntResourceFinishDate>

- <BuildCubeRequest>

- <CubeUpdate>

<CubeStart>20060801</CubeStart>

<CubeFinish>20060911</CubeFinish>

<Connection>Provider=SQLOLEDB; Initial Catalog=ProjectServer;Data
Source=DBSERVER</Connection>

<DBType>0</DBType>

<DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=ProjectServer;Data Source=XXXISERVER</DSOConnection>

<Server>XXXserver</Server>

<CubeDB>ProjectServerCube</CubeDB>

<CubeDesc>Project Cube</CubeDesc>

<BasePath>projectserver</BasePath>

<CubeGUID>3940CA37-4D63-4067-9E8F-D8F1079648EF</CubeGUID>

</CubeUpdate>

</BuildCubeRequest>

</ProjectData>

Hi Kurte,


<Server>XXXserver</Server>
Is this correct?

Did you retype the actual server name when you posted your message to
us?
OR
Is this the actual XML entry?

--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Marc S.]

Kurte,

thanks for the update. So this means that an XML file is actually created
and that it does show up in the ViewDrop folder. What happens next? Will the
XML file for the cube disappear on its own (meaning it has been processed),
after how long?

Marc

--
MCP, EPM consultant
Basel, Switzerland
http://msepm.blogspot.com

Rolly,

I substituted the server names so "XXXISERVER" would be the database server
and "XXXserver" would be server where Analysis Servers and View Processing
are.

Kurte

Marc,

I ran the cube build and do an xml file with the following contents...

ViewsDropData>

- <ProjectData>

- <EntProjectName>

- <![CDATA[ resglobal ]]>
</EntProjectName>

<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2006-08-01T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2006-09-11T00:00:00</EntResourceFinishDate>

- <BuildCubeRequest>

- <CubeUpdate>

<CubeStart>20060801</CubeStart>

<CubeFinish>20060911</CubeFinish>

<Connection>Provider=SQLOLEDB; Initial Catalog=ProjectServer;Data
Source=DBSERVER</Connection>

<DBType>0</DBType>

<DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=ProjectServer;Data Source=XXXISERVER</DSOConnection>

<Server>XXXserver</Server>

<CubeDB>ProjectServerCube</CubeDB>

<CubeDesc>Project Cube</CubeDesc>

<BasePath>projectserver</BasePath>

<CubeGUID>3940CA37-4D63-4067-9E8F-D8F1079648EF</CubeGUID>

</CubeUpdate>

</BuildCubeRequest>

</ProjectData>

Hi Kurte,


<Server>XXXserver</Server>
Is this correct?

Did you retype the actual server name when you posted your message to
us?
OR
Is this the actual XML entry?

--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Kurte]

Marc,

The xml files are still in the viewdrop folder. One question, should the
VNOTIFY.exe service run as NT AUTHORITY\Local Service? Or Local System?
Currently it is running as Local Service.

Kurte,

thanks for the update. So this means that an XML file is actually created
and that it does show up in the ViewDrop folder. What happens next? Will the
XML file for the cube disappear on its own (meaning it has been processed),
after how long?

Marc

--
MCP, EPM consultant
Basel, Switzerland
http://msepm.blogspot.com

Rolly,

I substituted the server names so "XXXISERVER" would be the database server
and "XXXserver" would be server where Analysis Servers and View Processing
are.

Kurte

Marc,

I ran the cube build and do an xml file with the following contents...

ViewsDropData>

- <ProjectData>

- <EntProjectName>

- <![CDATA[ resglobal ]]>
</EntProjectName>

<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2006-08-01T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2006-09-11T00:00:00</EntResourceFinishDate>

- <BuildCubeRequest>

- <CubeUpdate>

<CubeStart>20060801</CubeStart>

<CubeFinish>20060911</CubeFinish>

<Connection>Provider=SQLOLEDB; Initial Catalog=ProjectServer;Data
Source=DBSERVER</Connection>

<DBType>0</DBType>

<DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=ProjectServer;Data Source=XXXISERVER</DSOConnection>

<Server>XXXserver</Server>

<CubeDB>ProjectServerCube</CubeDB>

<CubeDesc>Project Cube</CubeDesc>

<BasePath>projectserver</BasePath>

<CubeGUID>3940CA37-4D63-4067-9E8F-D8F1079648EF</CubeGUID>

</CubeUpdate>

</BuildCubeRequest>

</ProjectData>

Hi Kurte,


<Server>XXXserver</Server>
Is this correct?

Did you retype the actual server name when you posted your message to
us?
OR
Is this the actual XML entry?

--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[Rolly Perreaux]

Hi Kurte,

The Project Server Views Notification Service should be running as:
NT AUTHORITY\Local Service.

The difference between Local Service and Local System is...

Local Service: A limited or restricted privilege account granting access
to the local computer only.

Local System: A full privilege account granting access to the entire
computer. Local System should be avoided as much as possible.

PS
Did you get a chance to try the solution that I posted a couple of days
ago?

Please let us know when you have a chance

Thanks!

--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com