Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Linking two or more projects with external relations

4 replies [Last post]
Ahmed Aziz
User offline. Last seen 8 years 45 weeks ago. Offline
Joined: 12 Aug 2014
Posts: 25
Groups: None

Hi all,

I am dealing with a large project that’s estimated to have about 50,000 activities with over 100,000 relations, this project is divided into three large phases, we have developed the first phase and it’s about 19,259 activities and with 37,851 relations this project currently schedules in 48 seconds and takes around 20 mins to be imported. (Knowing that my laptop operates Windows 7 64 bit with 8 GB and I have the standalone version of Primavera p6 v8.3).

I am getting frustrated to start with the remaining two phases as primavera is getting more and more slow in operation, so we decided that we can deal with each phase as a separate project with external relations between the three project (phase 1, 2 and 3), I haven't tried this before so if anyone can point out the drawbacks of dividing the project into three projects with external relationships and if anyone have a better solution his/her contribution is highly appreciated.

Thanks

Replies

Dieter Wambach
User offline. Last seen 7 years 26 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350

Hi Ahmed

The performance you describe is not normal, even for a stand-alone installation. Check first with an IT specialist where is the bottleneck. In the stand-alone installation you still have a 3-tier application:

- Database server, Oracle or MS-SQL, a normal licence or Oracle XE which was delivered with P6; space, extensions,... My feeling would let me first check this area.

- Process server (some of the processes run on a dedicated server

- Application Server; the pm.exe + ...

First you need sufficient space on your HDD, then - as mentioned before, a good processor,... The slow import is not related to processor but more to hdd space. The greedy algorithm of "F9" requires processor but hdd as well.

Whats about your hdd and your Oracle installation? Contact your IT because something's wrong with the installation.

A separation of a project can be helpful, especially in co-operations and the relate access-rights. But - as written before - to create an overall schedule you'll have open all related projects simultaneously.

How many notebook items and codes you use?

Good luck!

Dieter

MK TSE
User offline. Last seen 4 years 19 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None

If split activities into more than 1 project, you still need open all projects together for master level scheduling, i.e. the slow response experience still exist in this situation.

Ahmed Aziz
User offline. Last seen 8 years 45 weeks ago. Offline
Joined: 12 Aug 2014
Posts: 25
Groups: None

Tom,

Thanks for your reply, i have sent my email to the email you have provided, and will keep you updated

Tom Reichner
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 23 Nov 2011
Posts: 46

Ahmed,

 

I think your approach of splitting into several projects is a good one. Windows 8.1 on your laptop with a faster chip would help, too.

 

Treating the project phases as separate schedules will work as long as you carefully build those external links between schedules. For the purpose of summarizing the linked activities and checking the critical milestones for critical predecessors, I've made several special Primavera P6 reports. If you send an email to me at treichner@yahoo.com I will send those P6 reports (erp files). They will be easy to import from the Reports tab into the Open Projects node in Reports. When you use them you will need to have the project xer files open at the same time.

 

When I build P6 reports I like to format them to look like Excel spreadsheets, with borders around the cells and a colored background for the column titles. This makes it easier to read by the non-expert reader.

 

Tom Reichner