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.

Activity Count

17 replies [Last post]
Aleli Florencia M...
User offline. Last seen 16 years 2 weeks ago. Offline
Joined: 9 Dec 2003
Posts: 8
Groups: None
Is the activity count in P3 limited to 200 only? I am creating a project plan on P3 and it cannot add anymore activities, why so?

Replies

Sen Moc
User offline. Last seen 18 years 33 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Is the activity count in P3 limited to 200 only? I am creating a project plan on P3 and it cannot add anymore activities, why so?

Hi Aleli,

200 is good for Level 1 or 2 program only. The other guys are talking of THOUSANDS activities. Refer to Number of Activities.
Alex Wong
User offline. Last seen 11 years 22 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Gents

Please start a new topic

:-)

Good luck

Alex
Philip Jonker
User offline. Last seen 15 years 38 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi guys,

In the old days, 1994, you used to go into the database, and create an index, and this created the links between ID’s. The best explanation I can give was going to the library and looking for a book, on civil engineering.

They had all these cards in a drawer, and then you looked for drawer C, and found the card for civil engineering, here was a card, the referred to several sub-disciplines, and you found what you where looking for ie geotechnics, this referred you to another drawer with more cards, and you found the card, related to geotechnical, and then you find the subject collapsing sands, and it refers you to another drawer, where you finally find the book by A Brink (the author) where he refers to collapsing sands, and you have your answer. If you had known you where looking for A Brink in the first place, you would have found the book in less steps, by going to the authors index in the first place. This is the role indexes and filters play, ie the drawers are indexes. For some or other reason programmers decided in their attempts to make programs user friendly to remove the word index and call it a link.

Hope this explains part of the problem of RDBF’s

Regards

Philip
Hannes de Bruyne
User offline. Last seen 1 year 49 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
Hi Philip,

I cannot say by 100 % that Suretrak is not a database, because I don’t know the source-code. But there are a lot of things that give me the impression that it is not. The big advantage of a database is that it is a multiuser application. This can be achieved by locking single "lines" instead of the whole file. Suretrak is not a multiuser-software. The difference between worksheet and database is not the form of saving. Saving can be done in any kind of format (as long as I know the format). Suretrak was created after P3 for single user, limited amount of activities - and as I think - to use the advantage of a worksheet. A Worksheet-software normaly would write into a single file, but to stay in the same family why not read and write in the same format with many files for the related groups as P3 does? So, therefore I don’t think Suretrak is P3-Lite but an own software.

Regards
Hannes
Mario Sanvitale
User offline. Last seen 12 years 29 weeks ago. Offline
Joined: 22 Sep 2005
Posts: 139
Groups: None
Actually Philip I do understand RDBMSs pretty well. The DB relationship tables for Primavera V5 are detailed in the schema on the CDs, so I don’t understand your comment about the system not appearing to be an RDBMS, that is exactly what it appears to be in my view.
Philip Jonker
User offline. Last seen 15 years 38 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi Mario,

I don’t believe you understand the concept of relational databases. What happened in the 90’s was the programmers, wrote programs such as Access and MSP, which had the appearence of that they were spreadsheets, but they called things by different names, like database files (DBF) became tables, and the various database files were saved under one name, ie 32-bit technology vs 16-bit techology, But essentialy things are still the same, but a different look. Take a look at EPM V5, and although you cannot see the way data is stored, it essentially still a relational database, but appears not to be. To try and explain relational databases here would be quite a task, but I will scan in some old manuals this weekend, and send them to whoever is interested, it is only a couple of pages, but will give you an idea, of the workings behind whatever software you are using.

Regards

Philip
Mario Sanvitale
User offline. Last seen 12 years 29 weeks ago. Offline
Joined: 22 Sep 2005
Posts: 139
Groups: None
The default saving in Suretrak is in Suretrak format. There are two further options to reconfigure the files in P3 format. The Suretrak format is not compatible with P3.
Philip Jonker
User offline. Last seen 15 years 38 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Well how come, it save the files in the same format as P3?
Mario Sanvitale
User offline. Last seen 12 years 29 weeks ago. Offline
Joined: 22 Sep 2005
Posts: 139
Groups: None
Don’t think you’re quite right there Philip! My understanding is that Suretrak is a RAM resident application, it doesn’t work the same way as P3. Hannes is right in what he says.

Philip Jonker
User offline. Last seen 15 years 38 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi Hannes, both P3 and Suretrak has engines, and as such, programms disk resident and not RAM. Suretrak looks like a spreadsheet, but has the same database configured files as P3. This is in fact true for almost all planning programmes.

Regards,

Philip
Hannes de Bruyne
User offline. Last seen 1 year 49 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
P3 is a database-programm i.e. limitation does not depend on memory installed. Each activity is loaded into the memory at the moment it is used and saved to the hard disk as soon as another activity is selected. Therefore recalculation takes a lot more time than a worksheet recalculation, P3 is slower in a network and no "File Save" is needed, etc.
Limitation therefore is by a) Harddisk b) recalculation time c) limited ID

Suretrack however works like a Worksheet and not like a database. So - limitation by memory, faster recalculation and "File Save"

Hannes de Bruyne


Alex Wong
User offline. Last seen 11 years 22 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Gents

the only down turn is, it take a very long ....... time to schedule "F9" thats why they only schedule to "schedule F9" the schedule @ nigth.

Cheers

ALex
Alex Wong
User offline. Last seen 11 years 22 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Philip

I actually saw a company uses over 1million activities in a structured P3 schedule and updated weekly.

You have to see it to believe it. It was in a housing development industry (Building New House)

Alex
Philip Jonker
User offline. Last seen 15 years 38 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi guys,

Having spoken with several people, both from Primavera, and other experienced planners, I was trying to find the limitations for P3, and the answers varied. The official number of activities is 100 000, however, apparently after 60 000, the program loses stability. The most I have handled was 35 000. This is purely an academic question, as we are migrating to V5. How many activities have anybody managed in P3 successfully?

Prior to primavera, I had used OP dos V4, and it had certain limitations, such as 15 000, on the normal version, but could be extended to something like 60 000 using an extended scheduler, and by changing to a unix version at the time, you could go to something like 200 000. This probably sounds like I was Noah’s planner, but it would be worthwile to know:-)

I have heard talk of 1,3 million activities, on a certain job at present. But find this a bit hard to believe.

Regards

Philip
Ronald Winter
User offline. Last seen 3 years 23 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None
Yes, you most assuredly have a Student Version of P3. This is sold at a discount only to students and is intended only for education, not actual business use.
Steven Oliver
User offline. Last seen 11 years 39 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
I think that there is a "student" version with an activity count limitation.
Bill Guthrie
User offline. Last seen 8 years 15 weeks ago. Offline
Joined: 14 Mar 2005
Posts: 262
man you have a problem with your set up

p3 3.1 is almost unlimited

cheers bill guthrie