Limit of 32000 rows has been exceeded in P3

R
Robin Reyes 👤 Member for 19 years 8 months
D
David Kelly 👤 Member for 21 years 7 months

The tabular reports have no limit, unlike layouts - so you can report all actvities there.

R
Robin Reyes 👤 Member for 19 years 8 months

Yes, There is no limitation in the number of activities for P3. The only thing that I am asking is how to remove the warning that the number of rows exceeded the maximum limit of 32,000 rows when I want to filter all activities. Because in the generation of Baseline, we wanted to filter all activities and make a printout.



Nevertheless, it is still calculating properly, though we cannot make a print-out of all activities for the purpose of official submission. What we did is we just filter the activities part by part to make printout.



I am still hoping that a better solution will come-out.

Merci.

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Ian,

ouf! I have always believed that P3 was able to accommodate huge files, much higher than 30000 activities, and I could not understand why Robin was asking the question this way.

Thanks for your info

Alexandre

I
Ian Nicholson 👤 Member for 16 years 4 months

The limit is only on the layout, not on the file itself. I can’t imaging why you would want a layout to show > 32,000 activities but P3 won’t lose the data if you go over, it just won’t display it all on the screen at the same time.



Primavera has run test files up to 100k activities and 100k relationships. Make sure you are backing your schedule up religiously and run PFXW.exe on the file on a regular basis. You dont want a file corruption to ruin your day - been there, done that.



You might want to look at running an upgraded Pervasive database to manage that large a file. P3 on Btrieve 6 is very sensitive to network hiccups, so don’t try to run it over a WAN.



Ian



http://www.emerald-associates.com

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Robin

why can’t you split your huge project because of 10 digit Activity Codes?

it is possible to use the same Activity Codes sequence in more than one project, look at the CLIN sample project that ships with P3

about P3 registry: P3 is a 16 bit application, which does not use the Windows registry; it uses a P3.INI file located in the C:\Windows folder

You should try splitting your project on a small scale, and advise.

Alexandre

R
Robin Reyes 👤 Member for 19 years 8 months

Thanks for the replies guys.

I am using P3 Version 3.1

I cannot use P6 since it is the client/Engineer requirement to use P3.

Moreover, I cannot split the project into two and cannot do a subproject since we already used all ten digits Activity ID.



The only solution applicable for me is to tweak the P3 registry that limit the maximum rows to 32,000 but apparently, I cannot find the P3 register so I can edit it.



Goodluck to me.


A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Robin,

Split your initial 28000+ activity project into smaller projects, based on the WBS

Then create a master project in which you will insert the "smaller projects"; this way, all your sub projects will share the same data dictionary: wbs, resources, activity codes, ...

Alexandre

S
Shah. HB 👤 Member for 17 years 6 months

You can convert P3 to P6 ,work on P6 then convert the same to P3 but it is time consuming

S
Shah. HB 👤 Member for 17 years 6 months

Hi to all



Another option is to convert P3 programme to P6 which is very easy step for you to carry on

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts